Re: Strong slowdown on huge tables

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Strong slowdown on huge tables
Дата
Msg-id 14867.1338313362@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Strong slowdown on huge tables  (Job <Job@colliniconsulting.it>)
Список pgsql-performance
Job <Job@colliniconsulting.it> writes:
> i use PostgreSQL 8.4.8 on Centos 5.x and i have some table where i load with pg_bulkload webtraffic logs, every day.
> After loading new data, i delete with a query 30-days older logs.

Since the deletion pattern is so predictable, you should consider
setting this table up as a partitioned table, so that you can just drop
the oldest partition instead of having to rely on DELETE+VACUUM to
reclaim space.  See
http://www.postgresql.org/docs/8.4/static/ddl-partitioning.html

Alternatively, look into whether including a manual VACUUM in your daily
update script helps any.

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_dump and thousands of schemas
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Recover rows deleted