spatial index

From: James Reid <james(dot)reid(at)ed(dot)ac(dot)uk>
To: pgsql-novice(at)postgresql(dot)org
Subject: spatial index
Date: 2001-11-29 10:20:41
Message-ID: 4.3.2.7.2.20011129101503.00a9edc0@129.215.16.14
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

hi - a very simple question from a newbie. Im tyring to outdo my colleagues Perl code (running on the same machine) for spatial operations (point-in-poly) but on a vanilla install of postgres 7.1 his perl is 20 times faster!! Ive no spatial index built on the polygon but I cant get one built as it complains of a tuple_row error which i assume relates to the use of the default 8Kb block size - my question is - how do I rebuild with a bigger block size so as I can build an rtree on 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/thoughts appreciated)

+----------------------------------------------------------------------------------------+
ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸

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(dot)Reid(at)ed(dot)ac(dot)uk
Scotland. Internet: edina.ed.ac.uk/ukborders/

ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸
+------------------------------------------------------------------------------------------+

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message Leonid V. Kovalev 2001-11-29 10:31:08 problem with case-sensitivity of database name
Previous Message Vincent.Gaboriau 2001-11-29 09:01:45 Re: [HACKERS] upper and lower doesn't work with german