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

Re: gah! sudden slowdown??

From: "Steinar H(dot) Gunderson" <sgunderson(at)bigfoot(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: gah! sudden slowdown??
Date: 2005-02-25 11:19:55
Message-ID: 20050225111955.GC11045@uio.no (view raw or flat)
Thread:
Lists: pgsql-performance
On Fri, Feb 25, 2005 at 03:41:58PM +0800, SpaceBallOne wrote:
> Our dual opteron has been performing well for many weeks now (after some
> simple tuning) when all of a sudden the queries have slowed right down!

Are you running regular VACUUMs? Looks like you have a lot of dead rows or
something.

/* Steinar */
-- 
Homepage: http://www.sesse.net/

In response to

pgsql-performance by date

Next:From: JeffDate: 2005-02-25 13:49:23
Subject: Possible interesting extra information for explain analyze?
Previous:From: Vig, Sandor (G/FI-2)Date: 2005-02-25 11:19:19
Subject: Re: Peformance Tuning Opterons/ Hard Disk Layout

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