> -----Original Message-----
> From: Mario Soto [mailto:mario_soto@venezolanadeavaluos.com]
> Sent: Wednesday, May 26, 2004 8:27 AM
> To: pgsql-general@postgresql.org
> Subject: [GENERAL] performance very slow
> Importance: High
>
>
> Hi. i hava a postresql 7.4.2 in a production server.
>
> tha machine is a Pentium IV 2,6 GHZ AND 1 GB IN RAM with lINUX RH 9.0.
[snip]
> BUT THE PERFORMANCE IT´S VERY SLOW
>
> what can do ?????
What are the queries that are slow, along with the schema for the associated tables?
What is the user load on the machine?
What is the disk subsystem in use?
When you say "very slow" what do you mean? 10 seconds to complete a query? One minute? One hour?
Probably, the biggest boost can be found by examination of the queries themselves.