spatial index
От | James Reid |
---|---|
Тема | spatial index |
Дата | |
Msg-id | 4.3.2.7.2.20011129101503.00a9edc0@129.215.16.14 обсуждение исходный текст |
Ответы |
Re: spatial index
Re: spatial index |
Список | pgsql-novice |
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/ ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸¸,ø¤º°`°º¤ø,¸ +------------------------------------------------------------------------------------------+
В списке pgsql-novice по дате отправления: