frank <f.callaghan@ieee.org> writes:
> I have a five table join that should return 1 record but, 0 comes back
> this was working before running vacuum last night - as a simple test
> I set enable_seqscan=off and hay-presstoe it came back !
> I guess there is an optimizer problem, so I have two questions
> 1) Is there some known bad problems outstanding ?
No, at least not in 7.0.*.
> 2) How do I get the output from explain to a file & would you like it ?
Cut and paste from a shell window is close enough ... explain would be
good, also the full schema for your tables and indexes thereon
(pg_dump -s is a good way to extract the schema info).
Don't forget the text of the query, too ;-)
regards, tom lane