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

Re: RE : Query problem

From: pginfo <pginfo(at)t1(dot)unisoftbg(dot)com>
To: Bruno BAGUETTE <pgsql-ml(at)baguette(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: RE : Query problem
Date: 2003-07-27 12:22:48
Message-ID: 3F23C418.5CC6D754@t1.unisoftbg.com (view raw or flat)
Thread:
Lists: pgsql-performance
Hi Bruno,
I think I have tunet it.
Pg is working for most of my selects, but I have problem with this one.

regards,
ivan

Bruno BAGUETTE wrote:

> Hello,
>
> > One of my selects is working much slower as in oracle.
> > In this example I am using not many rows in tables.
> > For all the joins I have indexes.
> > All IDS or IDS_xxx are name.
> >
> > Pls if it is possible poit me how to fix this problem.
> >
> > I send the query and the explai analyze.
> > I have ran vacuum analyze full on db.
>
> Have you tuned your postgresql.conf settings ?
>
> The PostgreSQL default settings are very low in order to allow
> PostgreSQL to RUN on old machines and new machines. If you need
> PERFORMANCE (which is quite logic), you must setup the postgresql.conf
> file.
>
> Here's a nice article about the postgresql.conf file tuning :
> http://www.varlena.com/varlena/GeneralBits/Tidbits/perf.html
>
> Hope this help ! :-)
>
> Cheers,
>
> ---------------------------------------
> Bruno BAGUETTE - pgsql-ml(at)baguette(dot)net




In response to

pgsql-performance by date

Next:From: Bruno BAGUETTEDate: 2003-07-27 13:26:03
Subject: RE : Query problem
Previous:From: pginfoDate: 2003-07-27 11:49:45
Subject: Query problem

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