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

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 (view raw or flat)
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

pgsql-performance by date

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

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