Re: Performance

I have an application via PHP. For example, a SELECT query that must return
one and only one row, with a where clause with and index (I droped it and
created again) that took about 3 seconds (v6.5.3), now (v7.0.0) takes about
15 seconds. Really I don't lnow what is happening. Same hardware, same php
version, etc etc.

Thanks again!

Diego Schvartzman
Email: diego.schvartzman@usa.net
ICQ# 1779434
----- Original Message -----
From: Alfred Perlstein <bright@wintelcom.net>
To: Diego Schvartzman <dschvar@yahoo.com>
Cc: Lista PGSQL <pgsql-general@postgresql.org>
Sent: Monday, May 15, 2000 5:18 PM
Subject: Re: [GENERAL] Performance


> * Diego Schvartzman <dschvar@yahoo.com> [000515 12:25] wrote:
> > Hi all!
> > I've upgraded to PGSQL 7.0.0 beta 2 from 6.5.3. Unloaded and loaded my
db,
> > vacuumed it, everything ok. I'm not using foreign keys. But now I see
that
> > performance is so much slower !. Is this supposed to be? Do I have to do
> > something else?
> >
> > English is my second language. Thanks in advance !
>
> A lot of people have said that performance has increased, if you want
> any help you'll need to be more specific, give examples of what's
> worse now than before.
>
> --
> -Alfred Perlstein - [bright@wintelcom.net|alfred@freebsd.org]
> "I have the heart of a child; I keep it in a jar on my desk."
>