| From: | Job <Job(at)colliniconsulting(dot)it> |
|---|---|
| To: | "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Strong slowdown on huge tables |
| Date: | 2012-05-29 14:54:18 |
| Message-ID: | 88EF58F000EC4B4684700C2AA3A73D7AA8B1042B83@W2008DC01.ColliniConsulting.lan |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Hello,
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.
Autovacuum is on.
In some systems, i experience a very huge slowdown of this table in queries, expecially update and delete; the database size grows up a lots.
I tried to rebuild indexes and make a manual vacuum; database size reduces, but slowdown problems remains.
Are there particular things to know after using pg_bulkload?
In this case, is preferred to set autovacuum off and launch one time a week, as example, the autovacuum full manually?
Thank you!
Francesco
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2012-05-29 15:52:22 | Re: pg_dump and thousands of schemas |
| Previous Message | Tatsuo Ishii | 2012-05-29 09:51:49 | Re: pg_dump and thousands of schemas |