From: | Michael Reifenberger <root(at)nihil(dot)plaut(dot)de> |
---|---|
To: | PostgreSQL Hackers <hackers(at)postgreSQL(dot)org> |
Subject: | Problem with complexer join still persists sometimes |
Date: | 1999-03-31 09:37:08 |
Message-ID: | Pine.BSF.4.10.9903311123460.1338-300000@nihil.plaut.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
Attachment | Content-Type | Size |
---|---|---|
a.txt | text/plain | 442 bytes |
b.txt | text/plain | 444 bytes |
From | Date | Subject | |
---|---|---|---|
Next Message | Oliver Smith | 1999-03-31 10:54:02 | Date operations |
Previous Message | Billy G. Allie | 1999-03-31 08:06:41 | Bug Report - Compile errors in vacuum.c and shmem.c |