Problem with complexer join still persists sometimes
Michael Reifenberger <root@nihil.plaut.de>
From: Michael Reifenberger <root@nihil.plaut.de>
To: PostgreSQL Hackers <hackers@postgreSQL.org>
Date: 1999-03-31T09:37:08Z
Lists: pgsql-hackers
Attachments
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