Re: slow database - Mailing list pgsql-performance

From Tom Lane
Subject Re: slow database
Date
Msg-id 22126.1076518828@sss.pgh.pa.us
Whole thread Raw
In response to Re: slow database  (alemon@tiago.hazor.com.br)
Responses Re: slow database  (alemon@tiago.hazor.com.br)
List pgsql-performance
alemon@tiago.hazor.com.br writes:
> the normal queries do not present problems, but all the ones
> that join has are very slow.

No surprise, as you've disabled all but the stupidest join algorithm...

As others already pointed out, you'd be a lot better off with the
default configuration settings than with this set.

            regards, tom lane

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: update performance
Next
From: "scott.marlowe"
Date:
Subject: Re: slow database