hi - a very simple question from a newbie. Im tyring to outdo my colleagues Perl code (running on the same machine) for
spatialoperations (point-in-poly) but on a vanilla install of postgres 7.1 his perl is 20 times faster!! Ive no spatial
indexbuilt on the polygon but I cant get one built as it complains of a tuple_row error which i assume relates to the
useof the default 8Kb block size - my question is - how do I rebuild with a bigger block size so as I can build an
rtreeon the poly? (or can someone give me some idea of how postgres spatial operations perform relative to other
solutions- Id like to employ postgres for a gazetteer service but I need to get the speed of response up....any
ideas/thoughtsappreciated)
+----------------------------------------------------------------------------------------+
ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸
James S Reid,
National Service Coordinator UKBORDERS
EDINA , Tel: +44 0131 651 1383
Data Library, Fax: +44 0131 650 3308
Main Library,
Edinburgh University,
Edinburgh EH8 9LJ, E-mail: James.Reid@ed.ac.uk
Scotland. Internet: edina.ed.ac.uk/ukborders/
ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸
+------------------------------------------------------------------------------------------+