Re: lost records !

frank <f(dot)callaghan(at)ieee(dot)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