Skip site navigation (1) Skip section navigation (2)

Re: Profiling

From: Cory 'G' Watson <gphat(at)cafes(dot)net>
To: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Profiling
Date: 2002-12-17 13:43:28
Message-ID: 861F40A0-11C5-11D7-8929-0003939CCA58@cafes.net (view raw or flat)
Thread:
Lists: 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


In response to

Responses

pgsql-performance by date

Next:From: Shridhar DaithankarDate: 2002-12-17 13:49:33
Subject: Re: Profiling
Previous:From: Shridhar DaithankarDate: 2002-12-17 13:35:41
Subject: Re: Profiling

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group