On 18/02/2016 9:34 am, "Tom Smith" <tomsmith1989sk@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.