Re: increasing collapse_limits? - Mailing list pgsql-hackers

From Greg Stark
Subject Re: increasing collapse_limits?
Date
Msg-id BANLkTikP66KizPDXsvqCtibYLCfXxS7yBw@mail.gmail.com
Whole thread Raw
In response to Re: increasing collapse_limits?  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: increasing collapse_limits?  (Mark Kirkwood <mark.kirkwood@catalyst.net.nz>)
List pgsql-hackers
On Sat, Apr 30, 2011 at 9:21 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
> - it would require a query in which
> every relation is linked to every other relation by a join clause.
> But that *can* happen (remember that clauses generated by transitive
> equality do count).

It sounds like you're describing precisely a "star schema" join which
isn't an uncommon design pattern at all.

-- 
greg


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Proposed patch: Smooth replication during VACUUM FULL
Next
From: Mark Kirkwood
Date:
Subject: Re: increasing collapse_limits?