Re: join over 12 tables takes 3 secs to plan

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Hilmar Lapp <hlapp(at)gmx(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: join over 12 tables takes 3 secs to plan
Date: 2003-01-02 20:24:20
Message-ID: 3559.1041539060@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc pgsql-performance

Hilmar Lapp <hlapp(at)gmx(dot)net> writes:
> I have a query generated by an application (not mine, but there's
> nothing I can find that looks bad about the query itself) that takes an
> excessive amount of time to return even though there are almost no rows
> in the schema yet.

Read
http://www.ca.postgresql.org/users-lounge/docs/7.3/postgres/explicit-joins.html

regards, tom lane

In response to

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message Neil Conway 2003-01-02 20:41:24 Re: join over 12 tables takes 3 secs to plan
Previous Message Dave Cramer 2003-01-02 19:50:15 Re: Help + Postgresql 7.22

Browse pgsql-performance by date

  From Date Subject
Next Message Neil Conway 2003-01-02 20:41:24 Re: join over 12 tables takes 3 secs to plan
Previous Message Tom Lane 2003-01-02 19:57:34 Re: Question on hardware & server capacity