pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Josh Berkus <josh@agliodbs.com>
Cc: Oleg Lebedev <olebedev@waterford.org>
Cc: Postgres SQL Mailing List <pgsql-sql@postgresql.org>
Subject: Re: won't drop the view
Date: Mon, 17 Dec 2001 20:21:20 -0500
Message-ID: <8922.1008638480@sss.pgh.pa.us> (raw)
In-Reply-To: <web-530735@davinci.ethosmedia.com>
References: <web-530735@davinci.ethosmedia.com>

"Josh Berkus" <josh@agliodbs.com> writes:
> Damn.  I can only really help with the obvious things, and you've
> covered most of those.  That view should take a long time, given the
> complexity ... but a long time is 30-60 seconds, not 10 minutes.

I'm guessing it's ye olde stupid-choice-of-plan kind of problem.
Unless I missed it, we have not been shown the plan currently being
used (no, the first four lines don't do it for me...)

You could probably get back to the previous, not-so-slow plan choice
by doing "DELETE FROM pg_statistic" to remove the data collected by
VACUUM ANALYZE.  A comparison of the EXPLAIN output in that state
vs. the EXPLAIN output in the analyzed state might be enlightening.

			regards, tom lane



view thread (12+ messages)  latest in thread

Message-ID: <8922.1008638480@sss.pgh.pa.us>
Permalink:  ../8922.1008638480@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/8922.1008638480@sss.pgh.pa.us

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: tgl@sss.pgh.pa.us, josh@agliodbs.com, olebedev@waterford.org
  Subject: Re: won't drop the view
  In-Reply-To: <8922.1008638480@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox