Re: [osmosis-dev] Bad PostgreSQL plans with pgsnapshot

2013-04-16 Thread Brett Henderson
Hi Paul, Thanks for the info. I ran into similar issues when implementing the Osmosis tasks. Osmosis contains the following code that runs prior to querying for a bounding box (ie. --dataset-bounding-box). // PostgreSQL sometimes incorrectly chooses to perform full table scans, these options //

[osmosis-dev] Bad PostgreSQL plans with pgsnapshot

2013-04-16 Thread Paul Norman
I ran across a PostgreSQL query planner bug today when benchmarking pgsnapshot. This may affect others so I'm documenting it. A common task is to extract a bounding box or polygon from the database, equivalent to a map? call. The way I was benchmarking was a multi-step process, but there's two th