Re: Subject: bool / vacuum full bug followup part 2 - Mailing list pgsql-general

From Tom Lane
Subject Re: Subject: bool / vacuum full bug followup part 2
Date
Msg-id 29140.1021048796@sss.pgh.pa.us
Whole thread Raw
In response to Re: Subject: bool / vacuum full bug followup part 2  ("Marin Dimitrov" <marin.dimitrov@sirma.bg>)
List pgsql-general
"Marin Dimitrov" <marin.dimitrov@sirma.bg> writes:
> the idea of ALTER INDEX ...REBUILD/COALESCE is that the index is optimised
> without accessing the table, so it should be faster

If you feel a compelling need to have a variant of REINDEX that works
that way, feel free to write it.  It seems like an extremely
low-priority concern to me, though.  (No, I'm not convinced there's
much performance gain to be had there, either...)

            regards, tom lane

pgsql-general by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: trouble with (lack of) indexing
Next
From: Tom Lane
Date:
Subject: Re: trouble with (lack of) indexing