Re: [PERFORM] performance question on VACUUM FULL (Postgres 8.4.2)

2010-01-21 Thread PG User 2010
Hi Jeff, Are you running VACUUM (without FULL) regularly? And if so, is that insufficient? Unfortunately, we have not run vacuumlo as often as we would like, and that has caused a lot of garbage blobs to get generated by our application. You can always expect some degree of bloat. Can you

[PERFORM] performance question on VACUUM FULL (Postgres 8.4.2)

2010-01-19 Thread PG User 2010
Hello, We are running into some performance issues with running VACUUM FULL on the pg_largeobject table in Postgres (8.4.2 under Linux), and I'm wondering if anybody here might be able to suggest anything to help address the issue. Specifically, when running VACUUM FULL on the pg_largeobject