Re: Profiling

From: Shridhar Daithankar <shridhar_daithankar(at)persistent(dot)co(dot)in>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: Profiling
Date: 2002-12-17 13:49:33
Message-ID: 200212171919.33174.shridhar_daithankar@persistent.co.in
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Tuesday 17 December 2002 07:13 pm, you wrote:
> On Tuesday, December 17, 2002, at 07:35 AM, Shridhar Daithankar wrote:
> > 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.

i recommend a vacuum analyze per 1000/2000 records for the table that gets
updated. It should boost the performance like anything..

Shridhar

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Cory 'G' Watson 2002-12-17 14:20:21 Re: Profiling
Previous Message Cory 'G' Watson 2002-12-17 13:43:28 Re: Profiling