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 enough for us to use or not. Thanks to everyone who provided answers for great and quick responses! Wow, it makes me really want to keep Postgres around. :) -Kevin On Thu, 2009-10-22 at 14:33 -0700, Scott Carey wrote: > > Partitioning by time should help a lot here as Kevin says. > > Also, you might want to experiment with things like pg_reorg: > http://reorg.projects.postgresql.org/ > http://pgfoundry.org/projects/reorg/ > http://reorg.projects.postgresql.org/pg_reorg.html > > Which is basically an online, optimized cluster or vacuum full. However it > has several caveats. I have not used it in production myself, just > experiments with it. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
