Re: Simple postgresql.conf wizard

"Kevin Grittner" <Kevin.Grittner@wicourts.gov> writes:

> There are some very big tables in that query which contain some
> confidential data.  

oh well.

> I'll attach the query and plan.  You'll note that the query looks a
> little odd, especially all the (1=1) tests.  

That is interesting. I seem to recall Tom is resistant to trying to optimize
such queries but actually I've written lots of queries like that myself so I
find them interesting.

I'll look at the query and see if I can write a similar one using dbt3.

--  Gregory Stark EnterpriseDB          http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication
support!