Home > mailing lists

Re: GIN, pg_trgm and large table - Mailing list pgsql-novice

From	Tomasz Barszczewski
Subject	Re: GIN, pg_trgm and large table
Date	March 11, 2018 02:12:09
Msg-id	0d038505-af7d-cb37-8b90-eab9862298c0@nop.com.pl Whole thread Raw
In response to	GIN, pg_trgm and large table (Max Fomichev <max.fomitchev@gmail.com>)
List	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@nop.com.pl

From: Max Fomichev
Date: 10 March 2018, 23:44:21
Subject: Re: GIN, pg_trgm and large table

From: "Dale Schmitz"
Date: 11 March 2018, 22:46:05
Subject: Error handling