On 10.03.2018 11:31, Max Fomichev wrote:
> Hello!
> I have the following table and index with about 15 billion records.
tb: Maybe try to use the partition - (CONSTRAINT ... CHECK) smaller
tables are searched.
ps. Also use the primary key - eg pg_repack requires it.
--
Best regards, Tomasz Barszczewski - tb(at)nop(dot)com(dot)pl