Skip site navigation (1) Skip section navigation (2)

BUG #7591: Large query string has limit

From: pking(at)nrcan(dot)gc(dot)ca
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #7591: Large query string has limit
Date: 2012-10-09 15:24:23
Message-ID: E1TLbfT-00063H-Si@wrigleys.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged on the website:

Bug reference:      7591
Logged by:          Pat King
Email address:      pking(at)nrcan(dot)gc(dot)ca
PostgreSQL version: 9.1.3
Operating system:   RedHat Linux 6.2
Description:        

Hi :

I am dealing with the open source program called "Geonetwork". It is passing
the following  query to postgres/postgis :

SELECT "fid", asText("the_geom") FROM "public"."spatialindex" WHERE ("fid" =
'10') OR ("fid" = '100') OR ("fid" = '1000') OR ("fid" = '10001') OR ("fid"
= '10005') ..........

Unfortunately, the query has > 50,000 OR clauses, and the query hangs.

I tried the query for < 50,000 OR clauses with success.

The spatialindex table is :

geonetwork=# \d spatialindex
          Table "public.spatialindex"
  Column  |          Type          | Modifiers
----------+------------------------+-----------
 fid      | integer                | not null
 id       | character varying(250) |
 the_geom | geometry               |
Indexes:
    "spatialindex_pkey" PRIMARY KEY, btree (fid)
    "spatialindexndx1" btree (id)
    "spatialindexndx2" gist (the_geom)
Check constraints:
    "enforce_dims_the_geom" CHECK (st_ndims(the_geom) = 2)
    "enforce_geotype_the_geom" CHECK (geometrytype(the_geom) =
'MULTIPOLYGON'::text OR the_geom IS NULL)
    "enforce_srid_the_geom" CHECK (st_srid(the_geom) = 4326)






Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2012-10-09 18:28:48
Subject: Re: BUG #7589: Canceled "CREATE UNIQUE INDEX CONCURRENTLY" leave not-fully-build index existing
Previous:From: hrtlikDate: 2012-10-09 14:20:40
Subject: BUG #7590: Data corruption using pg_dump only with -Z parameter

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group