X-Original-To: pgsql-advocacy-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 8B9C630F586; Mon, 23 Jun 2003 04:23:12 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 64907-08; Mon, 23 Jun 2003 01:23:01 -0300 (ADT) Received: from perrin.int.nxad.com (internal.ext.nxad.com [69.1.70.251]) by svr1.postgresql.org (Postfix) with ESMTP id 0AEB330F50C; Mon, 23 Jun 2003 01:23:01 -0300 (ADT) Received: by perrin.int.nxad.com (Postfix, from userid 1001) id 827792105E; Sun, 22 Jun 2003 21:22:59 -0700 (PDT) Date: Sun, 22 Jun 2003 21:22:59 -0700 From: Sean Chittenden To: nolan@celery.tssi.com Cc: Advocacy PostgreSQL , PostgreSQL-general Subject: Re: [GENERAL] interesting PHP/MySQL thread Message-ID: <20030623042259.GQ97131@perrin.int.nxad.com> References: <20030623030702.GM97131@perrin.int.nxad.com> <20030623035501.251.qmail@celery.tssi.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <20030623035501.251.qmail@celery.tssi.com> X-PGP-Key: finger seanc@FreeBSD.org X-PGP-Fingerprint: 3849 3760 1AFE 7B17 11A0 83A6 DD99 E31F BC84 B341 X-Web-Homepage: http://sean.chittenden.org/ User-Agent: Mutt/1.5.4i X-Archive-Number: 200306/168 X-Sequence-Number: 1380 > > 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? Definitely performance@. -sc -- Sean Chittenden