Re: [GENERAL] interesting PHP/MySQL thread

From: nolan(at)celery(dot)tssi(dot)com
To: sean(at)chittenden(dot)org (Sean Chittenden)
Cc: JanWieck(at)Yahoo(dot)com (Jan Wieck), pgman(at)candle(dot)pha(dot)pa(dot)us (Bruce Momjian), josh(at)agliodbs(dot)com (Josh Berkus), mail(at)joeconway(dot)com (Joe Conway), pgsql-advocacy(at)postgresql(dot)org (\"\"Advocacy PostgreSQL\"\"), pgsql-general(at)postgresql(dot)org (PostgreSQL-general)
Subject: Re: [GENERAL] interesting PHP/MySQL thread
Date: 2003-06-23 03:55:00
Message-ID: 20030623035501.251.qmail@celery.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-advocacy pgsql-docs pgsql-general

> 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

In response to

Responses

Browse pgsql-advocacy by date

  From Date Subject
Next Message Tom Lane 2003-06-23 03:57:10 Re: [GENERAL] interesting PHP/MySQL thread
Previous Message nolan 2003-06-23 03:29:29 Re: [GENERAL] interesting PHP/MySQL thread

Browse pgsql-docs by date

  From Date Subject
Next Message Tom Lane 2003-06-23 03:57:10 Re: [GENERAL] interesting PHP/MySQL thread
Previous Message nolan 2003-06-23 03:29:29 Re: [GENERAL] interesting PHP/MySQL thread

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2003-06-23 03:56:38 Re: [GENERAL] Bug in metaphone (contrib/fuzzystrmatch)
Previous Message nolan 2003-06-23 03:29:29 Re: [GENERAL] interesting PHP/MySQL thread