[postgis-users] Extent on multiple tables

[Mark Cave-Ayland]

Hi strk,

> -----Original Message-----
> From: postgis-users-bounces at postgis.refractions.net 
> [mailto:postgis-users-bounces at postgis.refractions.net] On 
> Behalf Of strk at refractions.net
> Sent: 21 October 2005 12:38
> To: 'PostGIS Users Discussion'
> Subject: Re: [postgis-users] Extent on multiple tables

(cut)

> Are you sure inspected geometries will be kept in memory 
> after state function feed ?

I'm fairly certain they would for the extent() case, because PostgreSQL will
load the tuples from disk (and hence into shared buffers) during the
aggregate calculation. Of course this would not be the case for
estimated_extent() ;)


Kind regards,

Mark.

------------------------
WebBased Ltd
17 Research Way
Plymouth
PL6 8BT

T: +44 (0)1752 797131
F: +44 (0)1752 791023

http://www.webbased.co.uk   
http://www.infomapper.com 
http://www.swtc.co.uk  

This email and any attachments are confidential to the intended recipient
and may also be privileged. If you are not the intended recipient please
delete it from your system and notify the sender. You should not copy it or
use it for any purpose nor disclose or distribute its contents to any other
person.