Message-ID: <20030623035501.251.qmail@celery.tssi.com>
From: nolan@celery.tssi.com
Subject: Re: [GENERAL] interesting PHP/MySQL thread
To: sean@chittenden.org (Sean Chittenden)
Date: Sun, 22 Jun 2003 22:55:00 -0500 (CDT)
Cc: JanWieck@Yahoo.com (Jan Wieck), pgman@candle.pha.pa.us (Bruce Momjian),
	josh@agliodbs.com (Josh Berkus), mail@joeconway.com (Joe Conway),
	pgsql-advocacy@postgresql.org (\"\"Advocacy PostgreSQL\"\"),
	pgsql-general@postgresql.org (PostgreSQL-general)
In-Reply-To: <20030623030702.GM97131@perrin.int.nxad.com> from "Sean
	Chittenden" at Jun 22, 2003 08:07:02 PM
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit

> Whoa, something's not right.  Could you please send along an EXPLAIN
> ANALYZE after doing a VACUUM ANALYZE of your query that's taking 3-4x
> longer?  

As luck would have it, I just finished the latest 'emergency' part of 
the project, so I may have a day or so to play with this before the
CIO figures out I'm done.  :-)

I'm hoping this turns out to be a tuning issue, as I'm still very much
of a rookie at tuning PostgreSQL.

I'll see if I can work something up.  Should this go to the general
list or somewhere else?
--
Mike Nolan