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

Re: performance very slow

From: "Mario Soto" <mario_soto(at)venezolanadeavaluos(dot)com>
To: <db(at)zigo(dot)dhs(dot)org>
Cc: <mario_soto(at)venezolanadeavaluos(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: performance very slow
Date: 2004-05-26 19:13:14
Message-ID: 45130.200.35.66.77.1085598794.squirrel@mail.venezolanadeavaluos.com (view raw or flat)
Thread:
Lists: pgsql-generalpgsql-performance
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




In response to

pgsql-performance by date

Next:From: Matthew NuzumDate: 2004-05-27 13:56:00
Subject: Re: PostgreSQL caching
Previous:From: Dennis BjorklundDate: 2004-05-26 19:03:56
Subject: Re: performance very slow

pgsql-general by date

Next:From: Dann CorbitDate: 2004-05-26 19:16:40
Subject: Re: performance very slow
Previous:From: Dennis BjorklundDate: 2004-05-26 19:03:56
Subject: Re: performance very slow

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