Back
[00:10:13] -!- jekhor [[email protected]] has joined #osm-ru
[00:27:21] -!- Mezonin_ [[email protected]] has joined #osm-ru
[00:33:58] -!- Mezonin has quit [Ping timeout: 480 seconds]
[00:41:46] -!- ErshKUS has quit [Ping timeout: 480 seconds]
[00:49:42] -!- zverik_ has quit [Ping timeout: 480 seconds]
[01:03:12] <olamedia> кто в курсе чем заканчивается импорт планеты?
[01:03:27] <olamedia> пошли пятые сутки :/
[01:03:31] <andrewsh> ужасом и разрушениями
[01:03:54] <andrewsh> и вторжением инопланетных огромных человекоподобных боевых роботов
[01:04:17] <olamedia> Committing transaction for planet_osm_point
[01:04:18] <olamedia> Committing transaction for planet_osm_line
[01:04:18] <olamedia> Committing transaction for planet_osm_polygon
[01:04:18] <olamedia> Committing transaction for planet_osm_roads
[01:04:18] <andrewsh> Komzzzpa в курсе
[01:04:19] <olamedia> ....
[01:04:21] <andrewsh> он научен
[01:04:32] <olamedia> Completed planet_osm_point
[01:04:32] <olamedia> Creating osm_id index on planet_osm_roads
[01:04:32] <olamedia> Creating indexes on planet_osm_roads finished
[01:04:32] <olamedia> All indexes on planet_osm_roads created in 13008s
[01:04:32] <olamedia> Completed planet_osm_roads
[01:04:52] <olamedia> и уже несколько часов нет больше сообщений
[01:07:46] <olamedia> все таблицы вроде как на месте и чем там еще скрипт может заниматься не представляю
[01:07:47] <olamedia> planet_osm_line 90905568
[01:07:47] <olamedia> planet_osm_nodes 0
[01:07:47] <olamedia> planet_osm_point 47232224
[01:07:47] <olamedia> planet_osm_polygon 26143762
[01:07:48] <olamedia> planet_osm_rels 2395310
[01:07:50] <olamedia> planet_osm_roads 8297453
[01:07:52] <olamedia> planet_osm_ways 305804224
[01:08:19] -!- progserega [[email protected]] has joined #osm-ru
[01:09:20] <Komzzzpa> olamedia: оно их сортирует
[01:09:48] <olamedia> уже было
[01:09:51] <Komzzzpa> olamedia: будет долго и прогресс не нарисовать, ибо постгрёй
[01:10:25] <Komzzzpa> completed для всех таблиц было?
[01:14:40] <olamedia> спасибо, натолкнул на мысль проверить список процессов в постгресе
[01:15:30] <olamedia> CREATE TABLE planet_osm_line_tmp AS SELECT * FROM planet_osm_line ORDER BY way;
[01:15:30] <olamedia> CREATE TABLE planet_osm_polygon_tmp AS SELECT * FROM planet_osm_polygon ORDER BY way;
[01:15:30] <olamedia> CREATE INDEX planet_osm_ways_nodes ON planet_osm_ways USING gin (nodes) WITH (FASTUPDATE=OFF);
[01:15:57] <olamedia> таблицы вроде как еще сортирует
[01:16:21] <olamedia> хотя и писал Sorting data and creating indexes for planet_osm_polygon
[01:16:21] <olamedia> Sorting data and creating indexes for planet_osm_line
[01:16:21] <olamedia> Sorting data and creating indexes for planet_osm_point
[01:16:21] <olamedia> node cache: stored: 2219907427(100.00%), storage efficiency: 86.82% (dense blocks: 2341002, sparse nodes: 79913980), hit rate: 100.00%
[01:16:21] <olamedia> Sorting data and creating indexes for planet_osm_roads
[01:17:46] <olamedia> ну и индекс на 300 млн записей это да, может быть долго
[01:25:26] -!- kisaa [[email protected]] has joined #osm-ru
[01:51:32] -!- old_Bibigon has quit [Ping timeout: 480 seconds]
[02:14:15] -!- _sev_ has quit [Read error: No route to host]
[02:14:29] -!- _sev [[email protected]] has joined #osm-ru
[02:27:11] -!- _sev has quit [Read error: Connection reset by peer]
[02:27:32] -!- _sev [[email protected]] has joined #osm-ru
[03:20:23] -!- CutterRus has quit [Remote host closed the connection]
[04:20:31] -!- jekhor has quit [Ping timeout: 480 seconds]
[04:24:48] -!- progserega has quit [Ping timeout: 480 seconds]
[04:28:40] -!- progserega [[email protected]] has joined #osm-ru
[05:00:16] -!- iav [[email protected]] has joined #osm-ru
[05:28:29] -!- private has quit [Read error: Connection reset by peer]
[05:34:43] -!- iav has quit [Ping timeout: 480 seconds]
[06:48:13] -!- progserega has quit [Ping timeout: 480 seconds]
[06:57:05] -!- progserega [[email protected]] has joined #osm-ru
[07:14:04] -!- karavanjo has quit [Remote host closed the connection]
[08:14:42] -!- zverik_ [[email protected]] has joined #osm-ru
[08:31:36] -!- gryphon [[email protected]] has joined #osm-ru
[08:58:46] -!- freeExec [[email protected]] has joined #osm-ru
[09:00:34] -!- karavanjo [karavanjo!~kvirc@leased-line-brest-91-149-154-34.brest.telecom.by] has joined #osm-ru
[09:04:29] -!- borism3461 [[email protected]] has joined #osm-ru
[09:15:36] -!- amak has quit [Ping timeout: 480 seconds]
[09:17:29] -!- old_Bibigon [[email protected]] has joined #osm-ru
[09:29:37] -!- Alex_[MapsWithMe] [Alex_[MapsWithMe][email protected]] has joined #osm-ru
[09:49:58] -!- zverik_ has quit [Ping timeout: 480 seconds]
[09:52:07] -!- progserega has quit [Remote host closed the connection]
[10:20:26] -!- dezhin|laptop has quit [Ping timeout: 480 seconds]
[10:27:27] -!- ErshKUS [[email protected]] has joined #osm-ru
[10:27:37] -!- Komzzzpa has quit [Read error: No route to host]
[10:28:39] -!- Komzzzpa [[email protected]] has joined #osm-ru
[10:29:07] -!- kisaa has quit [Quit: Leaving.]
[10:47:16] -!- private [[email protected]] has joined #osm-ru
[11:07:36] -!- Zverik [[email protected]] has joined #osm-ru
[11:34:33] -!- kolen [[email protected]] has joined #osm-ru
[12:07:40] -!- Alex_[MapsWithMe] has quit [Quit: Leaving.]
[12:14:27] -!- private has quit [Ping timeout: 480 seconds]
[12:26:17] -!- jekhor [[email protected]] has joined #osm-ru
[12:28:08] -!- _sev|work [_sev|[email protected]] has joined #osm-ru
[12:46:14] -!- kolen has quit [Remote host closed the connection]
[12:55:13] -!- Alex_[MapsWithMe] [Alex_[MapsWithMe][email protected]] has joined #osm-ru
[12:55:13] -!- ErshKUS has quit [Read error: Connection reset by peer]
[13:03:50] -!- runich [[email protected]] has joined #osm-ru
[13:19:18] -!- runich has quit [Ping timeout: 480 seconds]
[13:28:24] <freeExec> пеший роутинг интересен, предлагает посередь догори сойти с зебры и дойти по ней до перекрётска и там повернуть, а то видите ли по пешеходной дорожке дальше идти
[13:29:57] <Mezonin_> пеший еще наверно через лет 10 будет пригоден для использования
[13:31:49] <freeExec> гы, а оказалось, что дорога на дорогу наложилась, баг в данных :(
[13:38:40] -!- private [[email protected]] has joined #osm-ru
[14:14:37] -!- karavanjo has quit [Read error: Connection reset by peer]
[14:21:14] <Zverik> новости медленно перемешиваются в подсознании, теперь кажется, что Сочи — столица Крыма
[14:24:19] <Mezonin_> а зеленые человечки заняли весь пьедестал в биатлоне
[14:26:09] <old_Bibigon> http://gis-lab.info/forum/viewtopic.php?f=12&t=16108 или все уже знают? :)
[14:41:06] <Zverik> old_Bibigon: я уже и тезисы отправил
[14:43:58] -!- jekhor has quit [Ping timeout: 480 seconds]
[14:55:50] -!- Alex_[MapsWithMe] has quit [Quit: Leaving.]
[15:22:54] -!- Alex_[MapsWithMe] [Alex_[MapsWithMe][email protected]] has joined #osm-ru
[16:16:02] -!- dezhin|laptop has quit [Ping timeout: 480 seconds]
[16:35:57] -!- private has quit [Ping timeout: 480 seconds]
[16:53:31] -!- private [[email protected]] has joined #osm-ru
[17:07:01] -!- _sev|work has quit [Quit: This computer has gone to sleep]
[17:11:27] -!- _sev|work [_sev|[email protected]] has joined #osm-ru
[17:21:08] -!- amak [[email protected]] has joined #osm-ru
[17:29:13] -!- borism3461 has quit [Quit: http://www.kiwiirc.com/ - A hand crafted IRC client]
[17:31:29] -!- _sev|work has quit [Read error: Connection reset by peer]
[17:32:01] -!- _sev|work [_sev|[email protected]] has joined #osm-ru
[17:42:26] -!- sh4 [[email protected]] has joined #osm-ru
[17:53:02] -!- old_Bibigon has quit [Remote host closed the connection]
[17:58:25] -!- karavanjo [karavanjo!~kvirc@leased-line-brest-91-149-154-34.brest.telecom.by] has joined #osm-ru
[18:06:19] -!- karavanjo has quit [Remote host closed the connection]
[18:07:34] -!- gryphon has quit [Remote host closed the connection]
[18:11:49] -!- _sev|work has quit [Quit: This computer has gone to sleep]
[18:12:17] -!- dezhin|laptop has quit [Quit: Leaving.]
[18:18:29] -!- ErshKUS [[email protected]] has joined #osm-ru
[18:28:24] -!- freeExec has quit [Quit: Пора домой]
[18:30:37] -!- _sev|work [_sev|[email protected]] has joined #osm-ru
[18:33:15] -!- Alex_[MapsWithMe] has quit [Quit: Leaving.]
[18:33:27] -!- Alex_[MapsWithMe] [Alex_[MapsWithMe][email protected]] has joined #osm-ru
[18:41:58] -!- jekhor [[email protected]] has joined #osm-ru
[18:44:26] -!- old_Bibigon [[email protected]] has joined #osm-ru
[18:48:08] -!- _sev has quit [Read error: Connection reset by peer]
[18:48:55] -!- _sev [[email protected]] has joined #osm-ru
[18:51:22] -!- gryphon [[email protected]] has joined #osm-ru
[19:15:23] -!- jekhor has quit [Ping timeout: 480 seconds]
[19:18:57] -!- nord [[email protected]] has joined #osm-ru
[20:28:35] -!- AMDmi3 [[email protected]] has joined #osm-ru
[20:32:21] -!- gryphon has quit [Remote host closed the connection]
[20:35:59] -!- CutterRus [[email protected]] has joined #osm-ru
[20:36:18] -!- gryphon [[email protected]] has joined #osm-ru
[20:58:29] -!- zverik_ [[email protected]] has joined #osm-ru
[21:34:15] -!- _sev|work has quit [Quit: This computer has gone to sleep]
[21:49:27] -!- sh4 has quit [Remote host closed the connection]
[22:06:37] -!- unnicked152 [[email protected]] has joined #osm-ru
[22:07:39] -!- unnicked152 has quit []
[22:13:24] -!- gryphon has quit [Remote host closed the connection]
[22:55:53] -!- private has quit [Ping timeout: 480 seconds]
[23:02:13] -!- shurik has quit [Read error: Connection reset by peer]
[23:03:55] -!- Alex_[MapsWithMe] has quit [Read error: Connection reset by peer]
[23:12:12] -!- private [[email protected]] has joined #osm-ru
[23:22:47] -!- Michael_D has quit [Ping timeout: 480 seconds]
[23:22:49] -!- ErshKUS has quit [Read error: Connection reset by peer]
[23:25:44] -!- shurik [shurik!~chatzilla@broadband-178-140-135-205.nationalcablenetworks.ru] has joined #osm-ru