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

Re: performance very slow

From: Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org>
To: Mario Soto <mario_soto(at)venezolanadeavaluos(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: performance very slow
Date: 2004-05-26 19:03:56
Message-ID: Pine.LNX.4.44.0405262057370.24368-100000@zigo.dhs.org (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
On Wed, 26 May 2004, Mario Soto wrote:

> tha machine is a Pentium IV 2,6 GHZ AND 1 GB IN RAM with lINUX RH 9.0.
> 
> BUT THE PERFORMANCE IT´S VERY SLOW

How often do you run VACUUM ANALYZE? You might want to do that every night 
or every hour (depending on how much updates you have).

Some of your config values could and should be tuned, read something like

http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html

Still, if it's very slow it's probably not just a little tweaking of these
variables that solves everything.

If that is the case you need to find a slow query, run EXPLAIN ANALYZE on
it and try to figure out why it is slow. There is a list to help with
performance issues called pgsql-performance that you might want to post to
(and read its archive).

But before anything else, make sure you run VACUUM ANALYZE regulary.

-- 
/Dennis Björklund


In response to

Responses

pgsql-performance by date

Next:From: Mario SotoDate: 2004-05-26 19:13:14
Subject: Re: performance very slow
Previous:From: Vitaly BelmanDate: 2004-05-26 18:00:34
Subject: Re: PostgreSQL caching

pgsql-general by date

Next:From: Mario SotoDate: 2004-05-26 19:13:14
Subject: Re: performance very slow
Previous:From: Bruce MomjianDate: 2004-05-26 18:46:01
Subject: Re: Postgresql Logging

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