回复：Re: Performance Issue when using gin index

From: 谭忠涛 <zhongtao(dot)tan(at)seaboxdata(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-bugs <pgsql-bugs(at)lists(dot)postgresql(dot)org>
Subject: 回复：Re: Performance Issue when using gin index
Date: 2025-01-21 06:25:06
Message-ID: tencent_4804F2BE463D60454F8BA22C@qq.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

I'm sorry I was too hasty and didn't read the manual carefully.

Regards

Tom Lane<tgl(at)sss(dot)pgh(dot)pa(dot)us&gt;&nbsp;在 2025年1月21日 周二 11:01 写道：

"=?utf-8?B?6LCt5b+g5rab?=" <zhongtao(dot)tan(at)seaboxdata(dot)com&gt; writes:
&gt; The performance of creating a gin index before inserting data is different from that of inserting data after creating a gin index.

This isn't terribly surprising.&nbsp; 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

Browse pgsql-bugs by date

  From Date Subject
Next Message Michael Paquier 2025-01-21 07:45:58 Re: reltuples kept decreasing with each autovacuum run Re: BUG #18773: オートバキュームのリトライ時にreltuplesの値が減少する
Previous Message Tom Lane 2025-01-21 03:01:40 Re: Performance Issue when using gin index