Re: SELECT with MANY tables

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Javier Carlos <fjcarlos(at)correo(dot)insp(dot)mx>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: SELECT with MANY tables
Date: 2003-11-26 00:45:23
Message-ID: 9938.1069807523@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Javier Carlos <fjcarlos(at)correo(dot)insp(dot)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

In response to

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Klint Gore 2003-11-26 01:46:35 Re: variable not found in subplan target list? + test case
Previous Message Tom Lane 2003-11-26 00:02:54 Re: variable not found in subplan target list? + test case