Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECT with MANY tables - Mailing list pgsql-bugs

From Tom Lane
Subject Re: SELECT with MANY tables
Date
Msg-id 9938.1069807523@sss.pgh.pa.us
Whole thread Raw
In response to SELECT with MANY tables  (Javier Carlos <fjcarlos@correo.insp.mx>)
Responses Re: SELECT with MANY tables  (Javier Carlos <fjcarlos@correo.insp.mx>)
List pgsql-bugs
Tree view 
Javier Carlos <fjcarlos@correo.insp.mx> writes:
>    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.

Hm.  Are you using the default GEQO settings, or something custom?

            regards, tom lane

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: variable not found in subplan target list? + test case
Next
From: Klint Gore
Date:
Subject: Re: variable not found in subplan target list? + test case