[postgis-users] long time for finding objects

[Malm Paul]

Hi I find it slow to select objects in the PostgreSQL/PostGIS db
I'm using windows XP, postgreSQL 8.3.7

I have a table "map" with the columns:
mapid: small int
scale: small int
rectangle: geometry
binary_field: bytea

The database concist of 81 "map" rows, where the binary has a avarage size of 80kb.

"SELECT * FROM map" takes about 3 seconds, while
"SELECT mapid, scale from map" takes about 14 milliseconds

Total size = 80 x 81k = 6,3 mb ( I don' t know, perhaps 3 sec isn' t slow )

Is there a way to speed this up?
I've tried to increase shared_buffers, and effective_cash_size.

Kind regards,
Paul

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-users/attachments/20090429/d0c7e3e8/attachment.html>