Re: [PERFORM] Table Clustering & Time Range Queries

2009-10-23 Thread Kevin Buckham
I came across links to pg_reorg previously but it seemed that the project was a bit "dead". There is active development but not much information, and not much in the way of discussions. I will definitely be testing both partitioning and pg_reorg. I am curious to see if pg_reorg will be stable eno

[PERFORM] Table Clustering & Time Range Queries

2009-10-22 Thread Kevin Buckham
I am running several servers with Postgres 8.3 that are used to house location data from thousands of devices. Location updates are quite frequent, so our tables rapidly become fairly large (often about 2GB per day of growth). We've been using Postgres for close to 10 years now and have been very