Re: BUG #14537: Gist index irrational growth

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: mcinp(at)o2(dot)pl
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #14537: Gist index irrational growth
Date: 2017-02-09 17:43:43
Message-ID: 18823.1486662223@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

mcinp(at)o2(dot)pl writes:
> 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.

I don't see any comparable misbehavior when testing a GIST index on a
plain polygon column full of nulls, so I would say this is specific to the
geometry opclass. Which means you need to tell the PostGIS folk about it,
not us.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message schendel.chris 2017-02-09 18:37:23 BUG #14539: Error Stack Builder 4.0.0 Couldn't access URL
Previous Message vodevsh 2017-02-09 13:58:08 BUG #14538: streaming replication same wal missing