From: Mario Soto <mario_soto@venezolanadeavaluos.com>
To: db@zigo.dhs.org
Cc: mario_soto@venezolanadeavaluos.com
Cc: pgsql-general@postgresql.org
Subject: Re: performance very slow
Date: Wed, 26 May 2004 15:13:14 -0400 (VET)
Message-ID: <45130.200.35.66.77.1085598794.squirrel@mail.venezolanadeavaluos.com> (raw)
In-Reply-To: <Pine.LNX.4.44.0405262057370.24368-100000@zigo.dhs.org>
References: <36620.200.35.66.77.1085585190.squirrel@mail.venezolanadeavaluos.com>
<Pine.LNX.4.44.0405262057370.24368-100000@zigo.dhs.org>
OK.
i see the link and change parameters in postgresql.conf
i.e.
When excecute a insert statement the memory up to 90% to use .
it's normal ???????
Thank for yor help and sorry for my bad englis
Regards
Mario Soto
> 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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: mario_soto@venezolanadeavaluos.com, db@zigo.dhs.org, pgsql-general@postgresql.org
Subject: Re: performance very slow
In-Reply-To: <45130.200.35.66.77.1085598794.squirrel@mail.venezolanadeavaluos.com>
References: <36620.200.35.66.77.1085585190.squirrel@mail.venezolanadeavaluos.com> <Pine.LNX.4.44.0405262057370.24368-100000@zigo.dhs.org> <45130.200.35.66.77.1085598794.squirrel@mail.venezolanadeavaluos.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox