On 18/02/2016 9:34 am, "Tom Smith" <tomsmith198...@gmail.com> wrote: > > Hi: > > I feel it is a stupid question. > > Can BRIN index enforce uniqueness? > My issue is > the column I'd like to apply BRIN index also needs to be unique > (think of timestamp as primary key).
Only btree supports unique. Is there a special reason not to use btree? I'm also finding it hard to imagine a case where a timestamp primary key is a good idea.