[postgis] Indexing....ack!

Paul Ramsey pramsey at refractions.net
Wed Aug 15 09:21:20 PDT 2001


> The default estimate was, I think, 0.5%.  The new one is, I think,
> 0.005%.  Its kinda of silly to use a constant number, but to actually
> compute an actual estimate would probably take longer than to do the
> actual query.

How do the BTree indexes do this? Do they not use some information
gathered by VACUUM to do a "guess" about the extent of the query? Would
it be possible for us to do similar things?

To unsubscribe from this group, send an email to:
postgis-unsubscribe at yahoogroups.com

 

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/ 





More information about the postgis-users mailing list