Hello Forum,
I would appreciate it if you could recommend settings to use
auto-vacuum in my version 7.4 database. I am uploading several thousands
records in the database at a rate of ~1 second per record (the data is
uploading from a different server). I have noticed that the performance
More important than sleep value is the vacuum threshold. If for example
you are expecting to import 5000 rows of data, you can tell
pg_autovacuum to vacuum after every 5000 changes with like
pg_autovacuum -v 5000 -V 0
Matthew
On Wed, 2004-05-19 at 17:09, Carlos wrote:
Hello Forum,
I