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

Re: Beta 2 logging

From: Dave Page <dpage(at)pgadmin(dot)org>
To: Kieran McCusker <kieran(dot)mccusker(at)kwest(dot)info>
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: Beta 2 logging
Date: 2009-04-02 09:32:09
Message-ID: 937d27e10904020232y58c26c9p2f2d193c894e81ad@mail.gmail.com (view raw or flat)
Thread:
Lists: pgadmin-support
On Wed, Apr 1, 2009 at 3:55 PM, Kieran McCusker
<kieran(dot)mccusker(at)kwest(dot)info> wrote:
> Hi again
>
> I was going to look at the SQL that produces the view or table when you
> click on it in the UI as it seems a little sluggish in our (admittedly large
> 5000+ views and tables) database. Enabling logging I got the following (at
> least for views and tables). The query (I've marked in bold) appears to be
> cut off mid-sentence....

There's a 1K buffer in some of the logging functions. I've increased that to 8K.

Thanks!

-- 
Dave Page
EnterpriseDB UK:   http://www.enterprisedb.com

In response to

pgadmin-support by date

Next:From: Dave PageDate: 2009-04-02 10:06:42
Subject: Re: 1.10 b2
Previous:From: Steve MartinDate: 2009-04-01 22:06:11
Subject: Re: [pgadmin-support] Goodbye

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