pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Re: RE : Query problem
2+ messages / 2 participants
[nested] [flat]

* RE : Query problem
@ 2003-07-27 13:26 Bruno BAGUETTE <pgsql-ml@baguette.net>
  2003-07-27 12:22 ` Re: RE : Query problem pginfo <pginfo@t1.unisoftbg.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Bruno BAGUETTE @ 2003-07-27 13:26 UTC (permalink / raw)
  To: 'pginfo' <pginfo@t1.unisoftbg.com>; pgsql-performance

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@baguette.net 




^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: RE : Query problem
  2003-07-27 13:26 RE : Query problem Bruno BAGUETTE <pgsql-ml@baguette.net>
@ 2003-07-27 12:22 ` pginfo <pginfo@t1.unisoftbg.com>
  0 siblings, 0 replies; 2+ messages in thread

From: pginfo @ 2003-07-27 12:22 UTC (permalink / raw)
  To: Bruno BAGUETTE <pgsql-ml@baguette.net>; +Cc: 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@baguette.net






^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2003-07-27 13:26 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-07-27 13:26 RE : Query problem Bruno BAGUETTE <pgsql-ml@baguette.net>
2003-07-27 12:22 ` pginfo <pginfo@t1.unisoftbg.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox