Re: [PERFORM] Optimization

2003-07-29 Thread Shridhar Daithankar
On 28 Jul 2003 at 12:27, Josh Berkus wrote: Unless you're running PostgreSQL 7.1 or earlier, you should be VACUUMing every 10-15 minutes, not every 2-3 hours. Regular VACUUM does not lock your database. You will also want to increase your FSM_relations so that VACUUM is more

Re: [PERFORM] Optimization

2003-07-29 Thread Peter Childs
On Tue, 29 Jul 2003, Shridhar Daithankar wrote: On 28 Jul 2003 at 12:27, Josh Berkus wrote: Unless you're running PostgreSQL 7.1 or earlier, you should be VACUUMing every 10-15 minutes, not every 2-3 hours. Regular VACUUM does not lock your database. You will also want to increase

Re: [PERFORM] Tuning PostgreSQL

2003-07-29 Thread Ron Johnson
On Tue, 2003-07-29 at 10:14, Vivek Khera wrote: GS == Greg Stark [EMAIL PROTECTED] writes: GS scott.marlowe [EMAIL PROTECTED] writes: GS But you have to actually test your setup in practice to see if it GS hurts. A big data warehousing system will be faster under RAID5 GS than under

Re: [PERFORM] Tuning PostgreSQL

2003-07-29 Thread Will LaShell
On Tue, 2003-07-29 at 08:14, Vivek Khera wrote: GS == Greg Stark [EMAIL PROTECTED] writes: GS scott.marlowe [EMAIL PROTECTED] writes: GS But you have to actually test your setup in practice to see if it GS hurts. A big data warehousing system will be faster under RAID5 GS than under