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

[PostGIS]

#3716: Gist index irrational growth
--------------------------------+---------------------------
  Reporter:  Marcin Piotrowski  |      Owner:  pramsey
      Type:  defect             |     Status:  closed
  Priority:  critical           |  Milestone:  PostGIS 2.2.7
 Component:  postgis            |    Version:  2.1.x
Resolution:  wontfix            |   Keywords:
--------------------------------+---------------------------
Changes (by pramsey):

 * status:  new => closed
 * resolution:   => wontfix


Comment:

 While this is no doubt an operationally awful problem to deal with, it's a
 PostgreSQL issue, not a PostGIS one. See the same behavior with a GIST
 index on the native 'box' type:
 {{{
 create table table_with_gist_box (id integer, status text, g box);
 create index box_gx on table_with_gist_box using gist (g);
 select pg_size_pretty(pg_relation_size('box_gx'::regclass));
 update table_with_gist set status = 'bar';^C
 insert into table_with_gist_box (status) select 'foo' as status from
 generate_series(1,100000);
 select pg_size_pretty(pg_relation_size('box_gx'::regclass));
 update table_with_gist_box set status = 'bar';
 select pg_size_pretty(pg_relation_size('box_gx'::regclass));
 update table_with_gist_box set status = 'bar';
 select pg_size_pretty(pg_relation_size('box_gx'::regclass));
 vacuum table_with_gist_box;
 select pg_size_pretty(pg_relation_size('box_gx'::regclass));
 update table_with_gist_box set status = 'bar';
 vacuum table_with_gist_box;
 select pg_size_pretty(pg_relation_size('box_gx'::regclass));
 update table_with_gist_box set status = 'bar';
 vacuum table_with_gist_box;
 select pg_size_pretty(pg_relation_size('box_gx'::regclass));
 update table_with_gist_box set status = 'bar';
 vacuum full table_with_gist_box;
 select pg_size_pretty(pg_relation_size('box_gx'::regclass));
 }}}
 I'm sure the folks at https://postgrespro.ru/ would be happy to work on
 improving the situation for future PgSQL releases.

--
Ticket URL: <https://trac.osgeo.org/postgis/ticket/3716#comment:5>
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.