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

Re: performance very slow

From: "Dann Corbit" <DCorbit(at)connx(dot)com>
To: "Mario Soto" <mario_soto(at)venezolanadeavaluos(dot)com>,<pgsql-general(at)postgresql(dot)org>
Subject: Re: performance very slow
Date: 2004-05-26 19:16:40
Message-ID: D90A5A6C612A39408103E6ECDD77B8299CAB0E@voyager.corporate.connx.com (view raw or flat)
Thread:
Lists: pgsql-general
> -----Original Message-----
> From: Mario Soto [mailto:mario_soto(at)venezolanadeavaluos(dot)com] 
> Sent: Wednesday, May 26, 2004 8:27 AM
> To: pgsql-general(at)postgresql(dot)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.


pgsql-general by date

Next:From: mack paulDate: 2004-05-26 19:23:24
Subject: temas del comando COPY
Previous:From: Mario SotoDate: 2004-05-26 19:13:14
Subject: Re: performance very slow

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