Re: Table Clustering & Time Range Queries

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.