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
_______________________________________________ postgis-users mailing list [email protected] http://postgis.refractions.net/mailman/listinfo/postgis-users
