lost records !

From: frank <f(dot)callaghan(at)ieee(dot)org>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: lost records !
Date: 2000-07-14 19:59:43
Message-ID: 396F712E.B8543713@ieee.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Ross J. Reedstrom 2000-07-14 20:27:37 [PATCHES] PgAccess schema-diagram cleanup
Previous Message Ross J. Reedstrom 2000-07-14 19:43:02 PgAccess diagrams (was: Re: Just committed some changes...)