Re: Performance in subconsult

From: Justin Clift <justin(at)postgresql(dot)org>
To: Sonia Sanchez Diaz <sonny(at)piaget(dot)dgsca(dot)unam(dot)mx>
Cc: PostgreSQL General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: Re: Performance in subconsult
Date: 2002-03-26 17:34:46
Message-ID: 3CA0B136.D7E78D8B@postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Sonia,

Have you tuned the PostgreSQL memory configuration, or is it still at
it's defaults?

The default memory allocation is really, really, really small, and is
only that way just in case someone loads PostgreSQL onto a server with
almost no memory (like 32MB or something).

The memory configuration is controlled by the postgresql.conf
configuration file, and I think you'll find Bruce Momjian's guide on
PostgreSQL tuning to be very useful :

http://www.ca.postgresql.org/docs/momjian/hw_performance/

:-)

Regards and best wishes,

Justin Clift

Sonia Sanchez Diaz wrote:
>
> Hello there!
>
> I have the next query:
>
> psql# select * from table1 t1 where not exists (select * from table2 t2
> where t2.id = t1.id);
>
> The execution of this uses more than 90% of my CPU performance and the
> answer is slow...
>
> Is there any wrong on my query?
>
> Thanks for the posible answers.
>
> ******************************************************************************
> Direccion General de Servicios de Computo Academico
> Productos Interactivos
> Sonia Sanchez Diaz
> e-mail: sonny(at)piaget(dot)dgsca(dot)unam(dot)mx
> tel: (5)6-22-81-13
> ICQ: 127002683
> ******************************************************************************
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster

--
"My grandfather once told me that there are two kinds of people: those
who work and those who take the credit. He told me to try to be in the
first group; there was less competition there."
- Indira Gandhi

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Jeroen T. Vermeulen 2002-03-26 18:14:53 Re: libpqxx has HTML docs
Previous Message postgresql 2002-03-26 17:30:08 Re: Performance in subconsult