[postgis-tickets] [PostGIS] #3716: Gist index irrational growth

[PostGIS]

#3716: Gist index irrational growth
--------------------------------+---------------------
  Reporter:  Marcin Piotrowski  |      Owner:  pramsey
      Type:  defect             |     Status:  new
  Priority:  medium             |  Milestone:
 Component:  postgis            |    Version:  2.1.x
Resolution:                     |   Keywords:
--------------------------------+---------------------

Comment (by Marcin Piotrowski):

 Sorry the description got truncated somehow. Here's how it should begin

 If you create a GiST index on a geometry(Polygon,4267) column and do
 updates
 on the table, the index size grows enormously even if the indexed column
 contains only nulls. This is a big problem  that caused index to grow to
 tens of gigabytes for a table with just about 10000 rows, where indexed
 column contained only nulls, but was updated on a minutely basis (but not
 on
 the geometry column).
 The size was not shrinked during autovacuum, only full vacuum was able to
 free the disk space.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3716#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.