-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Gregory Stark wrote: > "Evan Carroll" <lists@xxxxxxxxxxxxxxx> writes: > > "Evan Carroll" <lists@xxxxxxxxxxxxxxx> writes: > >> Dearest dragon hunters and mortal wanna-bes, >> >> I recently upgraded a system from Apache2/mod_perl2 to >> Lighttpd/fastcgi. The upgrade went about as rough as can be. While in >> the midst of a bad day, I decided to make it worse, and upgrade Pg 8.1 >> to 8.2. Most people I talk to seem to think 8.1 was a lemon release; >> not I. It worked excellent for me for the longest time, and I had no >> good reason to upgrade it, other than to just have done so. > > I assume you mean 8.1.9 and 8.2.4? > >> The following material is provided for your assisting-me-pleasure: the >> original SQL; the \ds for all pertinent views and tables; the output >> of Explain Analyze; and the original query. > > While I do in fact enjoy analyzing query plans I have to say that 75-line > plans push the bounds of my assisting-you-pleasure. Have you experimented with > simplifying this query? Although simplifying the query is probably in order, doesn't it stand to reason that there may be a problem here. 10x difference (in the worse) from a lower version to a higher, is likely wrong :) Joshua D. Drake > - -- === The PostgreSQL Company: Command Prompt, Inc. === Sales/Support: +1.503.667.4564 24x7/Emergency: +1.800.492.2240 PostgreSQL solutions since 1997 http://www.commandprompt.com/ UNIQUE NOT NULL Donate to the PostgreSQL Project: http://www.postgresql.org/about/donate PostgreSQL Replication: http://www.commandprompt.com/products/ -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (GNU/Linux) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQFG1EqYATb/zqfZUUQRAighAJ9g+Py+CRwsW7f5QWuA4uZ5G26a9gCcCXG2 0Le2KBGpdhDZyu4ZT30y8RA= =MfQw -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match