From: Bruno Wolff III <bruno@wolff.to>
To: Dave E Martin XXIII <postgresql-to.dave@dave.to>
Cc: pgsql-bugs@postgresql.org
Subject: Re: Index speeds up one row table (why)?
Date: Sun, 1 Jun 2003 00:33:39 -0500
Message-ID: <20030601053339.GB16259@wolff.to> (raw)
In-Reply-To: <3ED93338.80806@dave.to>
References: <3ED93338.80806@dave.to>
On Sat, May 31, 2003 at 16:56:56 -0600,
Dave E Martin XXIII <postgresql-to.dave@dave.to> wrote:
>
> (ok, experimented a bit more just now)
> Hm, it appears that degredation occurs with the index as well, I guess
> at the time I created the index, it just initially did better because it
> got to skip all the already dead rows at creation time: but this is
> disturbing, I do a vacuum, and the access times are better, but still
> horrible:
You really don't want to use an index, so this probably doesn't matter
for the current application. The problem is that when data is inserted
into an index that just increases (or decreases) in value space from
deleted entries doesn't get reused. I believe this is fixed in 7.4.
This case would apply to indexes based on counters, dates or times
where new values are added and old values get deleted.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: bruno@wolff.to, postgresql-to.dave@dave.to, pgsql-bugs@postgresql.org
Subject: Re: Index speeds up one row table (why)?
In-Reply-To: <20030601053339.GB16259@wolff.to>
References: <3ED93338.80806@dave.to> <20030601053339.GB16259@wolff.to>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox