I were unable to query a postgis table using queryByFeatures. That table is big (18000 records), but it is indexed with GIST. It hasn't oid field, but it has a gid field (integer) as primary key.
Quering another table with less records(7) returns records as expected. Another post to the list points that issue (http://mapserver.gis.umn.edu/data2/wilma/mapserver-users/0310/msg00320.html) EXPLAIN ANALYSE SELECT the_geom,gid FROM problematiclayer Seq Scan on problematiclayer (cost=0.00..2390.95 rows=18895 width=3407) (actual time=0.225..195.622 rows=18895 loops=1) 2 rows fetched (297 ms) DEBUG: StartTransactionCommand DEBUG: StartTransaction DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 187638/1/0, nestlvl: 1, children: <> DEBUG: ProcessUtility DEBUG: CommitTransactionCommand DEBUG: CommitTransaction DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 187638/1/0, nestlvl: 1, children: <> DEBUG: StartTransactionCommand DEBUG: StartTransaction DEBUG: name: unnamed; blockState: DEFAULT; state: INPROGR, xid/subid/cid: 187639/1/0, nestlvl: 1, children: <> DEBUG: ProcessUtility DEBUG: CommitTransactionCommand DEBUG: CommitTransaction DEBUG: name: unnamed; blockState: STARTED; state: INPROGR, xid/subid/cid: 187639/1/1, nestlvl: 1, children: <> Software: PostgreSQL 8.2.1 POSTGIS="1.2.1" GEOS="2.2.3-CAPI-1.1.1" PROJ="Rel. 4.5.0, 22 Oct 2006" USE_STATS FIST 2.2.1 __________________________________________________ Correo Yahoo! Espacio para todos tus mensajes, antivirus y antispam ¡gratis! Regístrate ya - http://correo.espanol.yahoo.com/
