Re: Query plan for very large number of joins

From: PFC <lists(at)boutiquenumerique(dot)com>
To: philb(at)vodafone(dot)ie, pgsql-performance(at)postgresql(dot)org
Subject: Re: Query plan for very large number of joins
Date: 2005-06-02 20:15:36
Message-ID: op.srrekazoth1vuj@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> I am using PostgreSQL (7.4) with a schema that was generated
> automatically (using hibernate).
> The schema consists of about 650 relations. One particular query (also
> generated
> automatically) consists of left joining approximately 350 tables. At this

Just out of curiosity, what application is this ?
And what are the reasons for so many tables ...and especially such a
query ?
Not criticizing, but curious.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message mudfoot 2005-06-02 21:02:03 Re: Adaptec/LSI/?? RAID (what about JBOD?)
Previous Message Vivek Khera 2005-06-02 17:47:49 Re: Adaptec/LSI/?? RAID