Strong slowdown on huge tables

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: Raw Message | Whole Thread | 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

Responses

Browse pgsql-performance by date

  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