[postgis-users] debug_level options?

[Mike Leahy]

Okay...checked that file, and the debug_level there is 0 (out of a range
of 0 to 16).  I think there must be another debug_level option somewhere
else that I need to change...but I haven't found it in that folder...

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Paul
Ramsey
Sent: June 5, 2003 6:06 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] debug_level options?

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
      \_


_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users