Re: Table Clustering & Time Range Queries

Поиск
Список
Период
Сортировка
От Kevin Buckham
Тема Re: Table Clustering & Time Range Queries
Дата
Msg-id 1256324981.6056.2974.camel@typhon
обсуждение исходный текст
Ответ на Re: Table Clustering & Time Range Queries  (Scott Carey <scott@richrelevance.com>)
Ответы Re: Table Clustering & Time Range Queries  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-performance
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.



В списке pgsql-performance по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Calculating selectivity for the query-planner on ts_vector colums.
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Queryplan within FTS/GIN index -search.