Postgres Pro
Downloads
Home   >   mailing lists

Re: Query plan for very large number of joins - Mailing list pgsql-performance

From PFC
Subject Re: Query plan for very large number of joins
Date
Msg-id op.srrekazoth1vuj@localhost
Whole thread Raw
In response to Query plan for very large number of joins  (<philb@vodafone.ie>)
List pgsql-performance
Tree view 

> 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.

pgsql-performance by date:

Previous
From: Vivek Khera
Date:
Subject: Re: Adaptec/LSI/?? RAID
Next
From: mudfoot@rawbw.com
Date:
Subject: Re: Adaptec/LSI/?? RAID (what about JBOD?)