Skip site navigation (1) Skip section navigation (2)

Re: Question about indexes

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Greg Stark <gsstark(at)mit(dot)edu>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Question about indexes
Date: 2004-01-27 22:51:56
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Greg Stark <gsstark(at)mit(dot)edu> writes:
> How feasible would it be to have a btree index on ctid?

Why would you want one?  Direct access by ctid beats out an index lookup
every time.  In any case, vacuum and friends would break such an index

			regards, tom lane

In response to


pgsql-hackers by date

Next:From: Greg StarkDate: 2004-01-27 23:11:31
Subject: Re: Question about indexes
Previous:From: Tom LaneDate: 2004-01-27 22:30:48
Subject: Re: Another optimizer question

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group