| 01:13:04 | strk: | Good morning ! |
| 01:13:38 | strk: | isnt' it 2am there pramsey ? : ) |
| 03:12:55 | nudge: | G'day All, |
| 03:12:57 | nudge: | I am doing something that postgresql should be good at, however the responside time seems less than snappy. Firstly is |
| 03:12:59 | nudge: | SET enable_seqscan TO 'off'; |
| 03:13:00 | nudge: | the correct syntax? |
| 03:22:08 | nudge: | Long story is that we have a table and index as follows |
| 03:22:10 | nudge: | Table "public.lga08aaust" |
| 03:22:12 | nudge: | Column | Type | Modifiers |
| 03:22:13 | nudge: | ------------+---------------+----------- |
| 03:22:15 | nudge: | state_code | character( 1 ) | |
| 03:22:16 | nudge: | lga_code | character( 5 ) | |
| 03:22:18 | nudge: | lga_name | character( 50 ) | |
| 03:22:19 | nudge: | boundary | polygon | |
| 03:22:21 | nudge: | Indexes: |
| 03:22:22 | nudge: | "lga08aaust_boundary" gist ( boundary ) |
| 03:22:24 | nudge: | And a table |
| 03:22:25 | nudge: | Table "public.work" |
| 03:22:27 | nudge: | Column | Type | Modifiers |
| 03:22:28 | nudge: | ---------+-------+----------- |
| 03:22:30 | nudge: | geocode | point | |
| 03:22:31 | nudge: | Both tables contain about 500 rows. |
| 03:22:33 | nudge: | Note that the boundary polygon is very complicated.( ~ 2000 points+ ) |
| 03:22:34 | nudge: | The following query takes way to long to run. ( 4m19s ) |
| 03:22:36 | nudge: | SELECT |
| 03:22:37 | nudge: | w.geocode, |
| 03:22:39 | nudge: | g.state_code, |
| 03:22:40 | nudge: | g.lga_code, |
| 03:22:42 | nudge: | g.lga_name |
| 03:22:44 | nudge: | FROM |
| 03:22:46 | nudge: | work AS w, |
| 03:22:48 | nudge: | lga08aaust AS g |
| 03:22:50 | nudge: | WHERE |
| 03:22:52 | nudge: | g.boundary ~ w.geocode; |
| 03:22:54 | nudge: | EXPLAIN indicates that it will just do a nested loop sequential scan. |
| 03:22:56 | nudge: | Any clues? |
| 11:16:54 | IchVerstehs: | hi |
| 11:19:19 | IchVerstehs: | got one problem: when using "osm2pgsql -U postgres -d routing data.osm > data2.sql" .. the data2.sql file that is created is 0Byte, that means nothing is inside |
| 11:20:06 | IchVerstehs: | ..after tiping osm2pgql -u .. it prompts some stuff and at the end "Writing way( 0k )" |
| 11:21:10 | IchVerstehs: | anyone knows what im doing wrong? |