On Mon, 24 Nov 2003, Javier Carlos wrote:
>
> Please enter a FULL description of your problem:
> -------------------------------------------------
> When I make a SELECT with many tables (more than 12), postgresql eats all my
> %CPU and I've waited more than 1 hour and stays the same. The weird thing is
> that with 10 tables the same select with the same joins only takes about 5
> seconds. First I thought that It was a problem related with one specific table,
> but I've changed in the SELECT the tables and while the number of tables remains
> less than 12 all is ok.
As a question, does the query work if you SET geqo=off; or SET
geqo_threshold=<some higher number, say 20>?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
