Re: [ADMIN] postgres optimization (effective_cache_size)

2005-08-22 Thread Scott Marlowe
On Fri, 2005-08-12 at 17:48, [EMAIL PROTECTED] wrote: > Hello, > > I followed this advice for picking a good effective_cache_size value > (below) from Scott Marlowe, and run into a bit of trouble: > > I looked at the `top' output and saw "721380k cached". > So I calculated the effective cache siz

Re: [ADMIN] postgres optimization (effective_cache_size)

2005-08-12 Thread ogjunk-pgjedan
Hello, I followed this advice for picking a good effective_cache_size value (below) from Scott Marlowe, and run into a bit of trouble: I looked at the `top' output and saw "721380k cached". So I calculated the effective cache size using Scott's formula: 721380/8 = 90172 Then I changed my effe