Re: GIN, pg_trgm and large table

From: Tomasz Barszczewski <tb(at)nop(dot)com(dot)pl>
To: pgsql-novice(at)lists(dot)postgresql(dot)org, max(dot)fomitchev(at)gmail(dot)com
Subject: Re: GIN, pg_trgm and large table
Date: 2018-03-10 20:12:09
Message-ID: 0d038505-af7d-cb37-8b90-eab9862298c0@nop.com.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

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

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Dale Schmitz 2018-03-11 16:46:05 Error handling
Previous Message Max Fomichev 2018-03-10 17:44:21 Re: GIN, pg_trgm and large table