Back
[00:10:13] -!- jekhor [jekhor!~jek@134.17.132.55] has joined #osm-ru
[00:27:21] -!- Mezonin_ [Mezonin_!~den2@31.23.121.165] 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 [progserega!~Serega@82.162.163.148] 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 [kisaa!~user26@5.8.193.138] 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 [_sev!~sev@109.87.123.170] has joined #osm-ru
[02:27:11] -!- _sev has quit [Read error: Connection reset by peer]
[02:27:32] -!- _sev [_sev!~sev@109.87.123.170] 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 [progserega!~Serega@82.162.163.148] has joined #osm-ru
[05:00:16] -!- iav [iav!~iav@customer-193.33.livas.lv] 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 [progserega!~Serega@82.162.163.148] has joined #osm-ru
[07:14:04] -!- karavanjo has quit [Remote host closed the connection]
[08:14:42] -!- zverik_ [zverik_!~zverik@178.70.71.199] has joined #osm-ru
[08:31:36] -!- gryphon [gryphon!~kvirc@82.140.120.164] has joined #osm-ru
[08:58:46] -!- freeExec [freeExec!~freeExec@109.197.193.170] 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 [borism3461!borism3461@d.clients.kiwiirc.com] has joined #osm-ru
[09:15:36] -!- amak has quit [Ping timeout: 480 seconds]
[09:17:29] -!- old_Bibigon [old_Bibigon!~bibigon@77.72.138.17] has joined #osm-ru
[09:29:37] -!- Alex_[MapsWithMe] [Alex_[MapsWithMe]!~AlexZolot@93.84.11.196] 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 [ErshKUS!~ErshKUS@ppp178-210-13-199.tis-dialog.ru] has joined #osm-ru
[10:27:37] -!- Komzzzpa has quit [Read error: No route to host]
[10:28:39] -!- Komzzzpa [Komzzzpa!~kom@5.149.156.131] has joined #osm-ru
[10:29:07] -!- kisaa has quit [Quit: Leaving.]
[10:47:16] -!- private [private!~mike@89-178-93-148.broadband.corbina.ru] has joined #osm-ru
[11:07:36] -!- Zverik [Zverik!~JOSM@spb.ant-inform.ru] has joined #osm-ru
[11:34:33] -!- kolen [kolen!~Thunderbi@cl3-170-119-212.cl.metrocom.ru] 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 [jekhor!~jek@134.17.132.55] has joined #osm-ru
[12:28:08] -!- _sev|work [_sev|work!~sev@188.230.122.226] has joined #osm-ru
[12:46:14] -!- kolen has quit [Remote host closed the connection]
[12:55:13] -!- Alex_[MapsWithMe] [Alex_[MapsWithMe]!~AlexZolot@port-23-adslby-pool47.infonet.by] has joined #osm-ru
[12:55:13] -!- ErshKUS has quit [Read error: Connection reset by peer]
[13:03:50] -!- runich [runich!~runich@188.226.107.80] 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 [private!~mike@89-178-93-148.broadband.corbina.ru] 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]!~AlexZolot@port-23-adslby-pool47.infonet.by] 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 [private!~mike@89-178-93-148.broadband.corbina.ru] has joined #osm-ru
[17:07:01] -!- _sev|work has quit [Quit: This computer has gone to sleep]
[17:11:27] -!- _sev|work [_sev|work!~sev@188.230.122.226] has joined #osm-ru
[17:21:08] -!- amak [amak!~amak@n44.jabber.d6.hsdnsrv.net] 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|work!~sev@188.230.122.226] has joined #osm-ru
[17:42:26] -!- sh4 [sh4!kldfkdlsf@178-45-30-206.saransk.ru] 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 [ErshKUS!~ErshKUS@ppp178-210-13-199.tis-dialog.ru] has joined #osm-ru
[18:28:24] -!- freeExec has quit [Quit: Пора домой]
[18:30:37] -!- _sev|work [_sev|work!~sev@188.230.122.226] has joined #osm-ru
[18:33:15] -!- Alex_[MapsWithMe] has quit [Quit: Leaving.]
[18:33:27] -!- Alex_[MapsWithMe] [Alex_[MapsWithMe]!~AlexZolot@port-23-adslby-pool47.infonet.by] has joined #osm-ru
[18:41:58] -!- jekhor [jekhor!~jek@46.216.245.2] has joined #osm-ru
[18:44:26] -!- old_Bibigon [old_Bibigon!~bibigon@static-92-39-68-20.kirov.comstar-r.ru] has joined #osm-ru
[18:48:08] -!- _sev has quit [Read error: Connection reset by peer]
[18:48:55] -!- _sev [_sev!~sev@109.87.123.170] has joined #osm-ru
[18:51:22] -!- gryphon [gryphon!~gryphon@net03113209750.pskovline.ru] has joined #osm-ru
[19:15:23] -!- jekhor has quit [Ping timeout: 480 seconds]
[19:18:57] -!- nord [nord!~hjkfdug@pppoe.178-65-158-173.dynamic.avangarddsl.ru] has joined #osm-ru
[20:28:35] -!- AMDmi3 [AMDmi3!~AMDmi3@95.108.175.19-red.dhcp.yndx.net] has joined #osm-ru
[20:32:21] -!- gryphon has quit [Remote host closed the connection]
[20:35:59] -!- CutterRus [CutterRus!~CutterRus@178.76.242.163] has joined #osm-ru
[20:36:18] -!- gryphon [gryphon!~gryphon@net03113209750.pskovline.ru] has joined #osm-ru
[20:58:29] -!- zverik_ [zverik_!~zverik@178.70.71.199] 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 [unnicked152!~b28a22b1@208.94.232.249] 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 [private!~mike@89-178-93-148.broadband.corbina.ru] 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