Re: Performance - Mailing list pgsql-general

From Dustin Sallings
Subject Re: Performance
Date
Msg-id Pine.NEB.4.10.10005190134140.543-100000@foo.west.spy.net
Whole thread Raw
In response to Re: Performance  (Alfred Perlstein <bright@wintelcom.net>)
List pgsql-general
On Tue, 16 May 2000, Alfred Perlstein wrote:

    This was not a bug report.  I simply said that I had the same
problem where a large table should have been using an index and was not,
so I vacuumed the table, and it used the index.

    Are you a developer?  Did this really read as a bug report?  Is
anyone out there creating largish tables, adding an index to them, and
having the index used without a vacuum?  Is it really that much of a
problem?

# >     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.
#
# grrrr....
#
# FOR THE LAST TIME, THESE BUG REPORTS ARE PRETTY MUCH **USELESS**
# TO THE DEVELOPERS UNLESS YOU GIVE:
#
# THE TABLE STRUCTURE,
# THE QUERY, AND
# THE OUTPUT OF 'EXPLAIN'
#
# Just because someone is a database guru doesn't mean they are also
# clairvoyant. :)
#
# thanks,
# -Alfred
#
#

--
dustin sallings                            The world is watching America,
http://2852210114/~dustin/                 and America is watching TV.


pgsql-general by date:

Previous
From: Lincoln Yeoh
Date:
Subject: Re: ODBC Question for 7.0
Next
From: Lincoln Yeoh
Date:
Subject: Does Order by support case?