lost records ! - Mailing list pgsql-hackers

From frank
Subject lost records !
Date
Msg-id 396F712E.B8543713@ieee.org
Whole thread Raw
Responses Re: lost records !
List pgsql-hackers
Hi All,

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 ?

2) How do I get the output from explain to a file & would you like it ?


TIA,           Frank.



pgsql-hackers by date:

Previous
From: "Ross J. Reedstrom"
Date:
Subject: PgAccess diagrams (was: Re: Just committed some changes...)
Next
From: Tom Lane
Date:
Subject: Re: lost records !