Postgres Pro
Downloads
Home   >   mailing lists

Re: Extreme bloating of intarray GiST indexes - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Re: Extreme bloating of intarray GiST indexes
Date
Msg-id BANLkTi=TfiuwVnXiEvGiXMbpdc6brt1uPA@mail.gmail.com
Whole thread Raw
In response to Re: Extreme bloating of intarray GiST indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Extreme bloating of intarray GiST indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tree view
I have another hypothesis about index bloat cause. AFAIK, vaccum procedure on GiST don't have any storage utilization guarantee. For example, if only one live item is in some page, then only one item will be left in this page. I.e. there is no index reroganization during vacuum. If there wouldn't be many inserts into such pages in future then they will be stay bloat.

----
With best regards,
Alexander Korotkov.

pgsql-hackers by date:

Previous
From: Зотов Роман
Date:
Subject: Re: Prefered Types
Next
From: Hitoshi Harada
Date:
Subject: Pull up aggregate subquery