Re: Performance

Have you done a VACUUM ANALYZE on your database after recreating the index?

At 04:56 PM 5/15/00, Diego Schvartzman wrote:
>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(dot)schvartzman(at)usa(dot)net
>ICQ# 1779434
>----- Original Message -----
>From: Alfred Perlstein <bright(at)wintelcom(dot)net>
>To: Diego Schvartzman <dschvar(at)yahoo(dot)com>
>Cc: Lista PGSQL <pgsql-general(at)postgresql(dot)org>
>Sent: Monday, May 15, 2000 5:18 PM
>Subject: Re: [GENERAL] Performance
>
>
> > * Diego Schvartzman <dschvar(at)yahoo(dot)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(at)wintelcom(dot)net|alfred(at)freebsd(dot)org]
> > "I have the heart of a child; I keep it in a jar on my desk."
> >