Postgres Pro
Downloads
Home   >   mailing lists

Problem with complexer join still persists sometimes - Mailing list pgsql-hackers

From Michael Reifenberger
Subject Problem with complexer join still persists sometimes
Date
Msg-id Pine.BSF.4.10.9903311123460.1338-300000@nihil.plaut.de
Whole thread Raw
Responses Re: [HACKERS] Problem with complexer join still persists sometimes
List pgsql-hackers
Tree view 
Hi,
I still have a problem with one query not returning all matching queries.
But it get's better than a few weeks before :-)
The symptom now:
As long as I do NOT create statisics wit 'VACUUM ANALYZE' I get all matching
queries. After the first 'VACCUM ANALYZE' the query malfunctions.

As a attachment: a.txt a EXPLAIN SELECT before the VACUUM, b.txt a EXPLAIN SELECT after the VACUUM.

For the used queries please search my last mail to hackers..

Bye!
----
Michael Reifenberger
Plaut Software GmbH, R/3 Basis

pgsql-hackers by date:

Previous
From: "Jackson, DeJuan"
Date:
Subject: RE: [HACKERS] [OT] Timezones and Daylight savings.
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] libpq++