Job 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 pa
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
