From: | Dustin Sallings <dustin(at)spy(dot)net> |
---|---|
To: | Charles Tassell <ctassell(at)isn(dot)net> |
Cc: | Diego Schvartzman <dschvar(at)yahoo(dot)com>, Lista PGSQL <pgsql-general(at)postgresql(dot)org>, Alfred Perlstein <bright(at)wintelcom(dot)net> |
Subject: | Re: Performance |
Date: | 2000-05-16 08:41:48 |
Message-ID: | Pine.NEB.4.10.10005160140520.416-100000@foo.west.spy.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Mon, 15 May 2000, Charles Tassell wrote:
I ran into this exact problem, and it was *very* significant on a
15M row table I have. :) It didn't seem to want to use the index, even
freshly created, without a vacuum analyze.
# 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."
# > >
#
#
--
dustin sallings The world is watching America,
http://2852210114/~dustin/ and America is watching TV.
From | Date | Subject | |
---|---|---|---|
Next Message | Marcos Barreto de Castro | 2000-05-16 12:02:52 | Queries using the C API |
Previous Message | Tom Lane | 2000-05-16 04:56:17 | Re: Best way to "add" columns |