"Josh Berkus" <[EMAIL PROTECTED]> writes:
> I tried re-arranging the JOINS as you suggested. There was no impact on
> gross performance (still 42 seconds to return the first row). And yes,
> it is the classic "star" database.
> What follows is the query plan.
Hm. The query plan looks very rea
"Josh Berkus" <[EMAIL PROTECTED]> writes:
> I can't figure out how to get Explain to output to a file instead of the
> screen. Embarassing, I know, but the command seems to subbornly resist
> all command-line re-direction.
I think that in psql, EXPLAIN results (and notices in general) come out
v
"Josh Berkus" <[EMAIL PROTECTED]> writes:
> I created a view to support comprehensive reporting on one of the
> databases I work with. Unfortunately, due to the structure of the
> database, which includes 25 reference tables, this requires 3 regular
> joins and about 40 LEFT OUTER JOINS, outputti
