I think I have tunet it.
Pg is working for most of my selects, but I have problem with this one.
Bruno BAGUETTE wrote:
> > 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
> Here's a nice article about the postgresql.conf file tuning :
> Hope this help ! :-)
> Bruno BAGUETTE - pgsql-ml(at)baguette(dot)net
In response to
pgsql-performance by date
|Next:||From: Bruno BAGUETTE||Date: 2003-07-27 13:26:03|
|Subject: RE : Query problem|
|Previous:||From: pginfo||Date: 2003-07-27 11:49:45|
|Subject: Query problem|