Re: Why are there no inequality scans for ctid?

From: hubert depesz lubaczewski <depesz(at)depesz(dot)com>
To: Atri Sharma <atri(dot)jiit(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why are there no inequality scans for ctid?
Date: 2013-06-28 08:52:46
Message-ID: 20130628085246.GA25949@depesz.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Jun 28, 2013 at 02:21:10PM +0530, Atri Sharma wrote:
> How would this be helpful for general use cases? Querying on tids on a
> specific page doesn't seem too useful for any other case than the one
> you mentioned above, and IMHO it seems to be the job of vacuum.
> I may be missing something here though.

Vacuum doesn't move rows around (as far as I can tell by running vacuum
~ 100 times on bloated table).

And as for general case - sure. It's not really useful aside from bloat
removal, but I think that bloat removal is important enough to warrant
some help from Pg.

Best regards,

depesz

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vincent Veyron 2013-06-28 09:42:20 Re: utf8 errors
Previous Message Atri Sharma 2013-06-28 08:51:10 Re: Why are there no inequality scans for ctid?