Job <Job@xxxxxxxxxxxxxxxxxxxx> 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 -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
