Re: Profiling - Mailing list pgsql-performance

From Cory 'G' Watson
Subject Re: Profiling
Date
Msg-id 861F40A0-11C5-11D7-8929-0003939CCA58@cafes.net
Whole thread Raw
In response to Re: Profiling  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
Responses Re: Profiling  (Shridhar Daithankar <shridhar_daithankar@persistent.co.in>)
List pgsql-performance
On Tuesday, December 17, 2002, at 07:35 AM, Shridhar Daithankar wrote:

> On Tuesday 17 December 2002 06:59 pm, you wrote:
>> shared_buffers = 98304
>> sort_mem = 1600
>> fsync = false
>>
>> Everything else is default, recommendations welcome. ;)
>
> What is the vacuum frequency?

Every morning.  This db is almost exclusively INSERT and SELECT.  Well,
I take that back, a single table gets UPDATEs rather frequently.
Otherwise, INSERT only.

Cory 'G' Watson


pgsql-performance by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: Profiling
Next
From: Shridhar Daithankar
Date:
Subject: Re: Profiling