2009/11/20 Jonathan Foy <the...@gmail.com>: > Shy of just throwing a trigger in the > table to actually populate a second table with the same data solely for > reporting purposes,
That's what I would do in your situation, FWIW. Query optimization is a hard problem even under the best of circumstances; getting the planner to DTRT with a crazy schema is - well, really hard. ...Robert -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
