[postgis-users] debug_level options?

[Paul Ramsey]

If I recall correctly, you are using a precompiled binary. Check in the 
postgresql.conf file and see if the debugging is cranked up in there to 
some non-default value.
P.

Mike Leahy wrote:
> Hello all again.
> 
> I have what I hope is a fairly simple question.when I do a query on a
> map using layers from a PostGIS database, string of results will scroll
> by in the Postmaster command window.  Most of it looks like super long
> series of TARGETENTRY statements (below).
> 
> This is also followed by a series of NOTICE messages before the query
> finishes.  The whole thing overall is working fine, but it can sometimes
> be a fairly lengthy wait if there are multiple layers and lots of small
> polygons.  I expect it would be significantly faster if I could have the
> postmaster work in a quiet mode of some type, either with the window
> hidden or by turning off message reporting.  I experimented with passing
> a debug_level parameter (-d 1) with the pg_ctl command (i.e., pg_ctl
> start -o "-i -d 1"), but that didn't really change anything.  Does
> anybody have any suggestions?
> 
> BTW: We are volunteering for an NGO in Peru to build an education
> information system based on spatial data, and have relatively little
> access to any development support network.  As a result, we have been
> relying heavily on email discussion lists.  We appreciate all of the
> help that has been offered by the participants of this list.
> 
> Kind regards,
> Mike
> __________________________________________
> 
> { TARGETENTRY
> :resdom
>    { RESDOM
>    :resno 66
>    :restype 23
>    :restypmod -1
>    :resname a_gra07gm
>    :reskey 0
>    :reskeyop 0
>    :ressortgroupref 0
>    :resjunk false
>    }
> 
> :expr
>    { VAR
>    :varno 1
>    :varattno 66
>    :vartype 23
>    :vartypmod -1
>    :varlevelsup 0
>    :varnoold 1
>    :varoattno 66
>    }
> }
> 
> 
> 
> _______________________________________________
> postgis-users mailing list
> postgis-users at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users


-- 
       __
      /
      | Paul Ramsey
      | Refractions Research
      | Email: pramsey at refractions.net
      | Phone: (250) 885-0632
      \_