[PERFORM] "VACUUM FULL ANALYZE" vs. Autovacuum Contention

2011-07-10 Thread D C
Hello, (Apologies if this is an obvious question. I have gone through the archives without seeing something that directly ties to this.) We are running Postgresql on a 64b RHEL5.2 64b server. "Uname -a": --Linux xxx 2.6.18-92.el5 #1 SMP Tue Apr 29 13:16:15 EDT 2008 x86_64 x86_64

Re: [PERFORM] "VACUUM FULL ANALYZE" vs. Autovacuum Contention

2011-07-08 Thread D C
can be purged entirely each day) rather than "delete froms", then there truly would not be any reason to use "vacuum full". Does that sound plausible? Thanks again, Daniel On Thu, Jul 7, 2011 at 5:30 PM, Greg Smith wrote: > On 07/07/2011 04:30 PM, D C wrote: &

[PERFORM] "VACUUM FULL ANALYZE" vs. Autovacuum Contention

2011-07-07 Thread D C
Hello, (Apologies for any possible duplication of this email.) (Also, apologies if this is an obvious question. I have gone through the archives without seeing something that directly ties to this.) We are running Postgresql on a 64b RHEL5.2 64b server. "Uname -a": --Linux xx