Postgres Pro
Downloads
Home   >   mailing lists

Re: Optimizing away second VACUUM heap scan when only BRIN indexes on table - Mailing list pgsql-hackers

From Peter Geoghegan
Subject Re: Optimizing away second VACUUM heap scan when only BRIN indexes on table
Date
Msg-id CAM3SWZQQZSc6AopshMGEKJ2r7Q3zin+L2UOPD9VfxD6RM4W8og@mail.gmail.com
Whole thread Raw
In response to Re: Optimizing away second VACUUM heap scan when only BRIN indexes on table  (Alvaro Herrera <alvherre@2ndquadrant.com>)
List pgsql-hackers
Tree view 
On Sun, Dec 20, 2015 at 6:14 PM, Alvaro Herrera
<alvherre@2ndquadrant.com> wrote:
> Since BRIN indexes cannot be primary keys nor unique keys, it's hard to
> be convinced that the use case of a table with only BRIN indexes is
> terribly interesting.

I'm not convinced of that.

-- 
Peter Geoghegan

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Optimizing away second VACUUM heap scan when only BRIN indexes on table
Next
From: David Fetter
Date:
Subject: Re: Optimizing away second VACUUM heap scan when only BRIN indexes on table