| 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: | Whole Thread | Raw Message | 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 |