Re: performance very slow

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