[postgis-users] value of spatial index on 300, 000, 000 point geometries

[pcreso at pcreso.com]

Hi,

I'm currently working with a table storing around 300,000,000 point geometries. No, it's not particularly fast :-)

I'm unsure of the value in creating a spatial index effectively comprising a BBOX on these, as the index then requires twice as many coordinates as the actual data.

Can anyone advise on the merits of spatial indexes on points?

Thanks,

   Brent Wood