"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? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
