Home > mailing lists

Re: Performance Issue when using gin index - Mailing list pgsql-bugs

From	Tom Lane
Subject	Re: Performance Issue when using gin index
Date	January 21 06:01:40
Msg-id	3265439.1737428500@sss.pgh.pa.us Whole thread Raw
List	pgsql-bugs

Tree view

"=?utf-8?B?6LCt5b+g5rab?=" <zhongtao.tan@seaboxdata.com> writes:
> The performance of creating a gin index before inserting data is different from that of inserting data after creating
agin index. 

This isn't terribly surprising.  Read

https://www.postgresql.org/docs/current/gin.html#GIN-FAST-UPDATE

There's also useful info in

https://www.postgresql.org/docs/current/gin.html#GIN-TIPS

            regards, tom lane

pgsql-bugs by date:

From: 勇次安藤
Date: 21 January, 05:13:05
Subject: Re: reltuples kept decreasing with each autovacuum run Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する

From: "谭忠涛"
Date: 21 January, 09:25:06
Subject: 回复：Re: Performance Issue when using gin index

Re: Performance Issue when using gin index - Mailing list pgsql-bugs

Previous

Next