2012/3/20 Guillaume Lelarge
> On Tue, 2012-03-20 at 09:02 +0100, Bartosz Dmytrak wrote:
> > Hi,
> > it is possible to set autovacuum_analyze_threshold
> > and autovacuum_analyze_scale_factor for TOAST tables using pgAdmin.
> > Script generated is like this:
> >
> > ALTER TABLE "MySchema"."MyTable
On Tue, 2012-03-20 at 09:02 +0100, Bartosz Dmytrak wrote:
> Hi,
> it is possible to set autovacuum_analyze_threshold
> and autovacuum_analyze_scale_factor for TOAST tables using pgAdmin.
> Script generated is like this:
>
> ALTER TABLE "MySchema"."MyTable" SET (
> toast.autovacuum_analyze_thresh
On Tue, 2012-03-20 at 12:53 -0700, MattK wrote:
> With reduced logging, I still get regular periods of unresponsiveness, even
> when Don't Refresh is set in the monitor window.
>
> Does PgAdmin look at all logs in pg_log, or only the current one?
>
Only the selected one in the combobox.
> Is t
With reduced logging, I still get regular periods of unresponsiveness, even
when Don't Refresh is set in the monitor window.
Does PgAdmin look at all logs in pg_log, or only the current one?
Is there a way to disable log monitoring, as a test for the cause of this issue?
>__
Very likely. I had some large log files (>1GB). Setting the log rotation size
to 100MB seems to have brought my the server status monitor back to life.
Thanks!
>
> From: Dave Page
>To: MattK
>Cc: "pgadmin-support@postgresql.org"
>Sent: Tuesday, March 20, 20
On Mon, Mar 19, 2012 at 7:26 PM, MattK wrote:
> I can reproduce the issue in v1.14.0 and v1.14.1 as well. This does not
> happen on all of my Postgres instances, the one I am trying to actively
> monitor that exhibits the problem is through the ssh port forward.
>
> Running ssh -v -L 5433::5432 @
2012/3/18 Guillaume Lelarge
> Le 14/03/2012 21:43, Bartosz Dmytrak a écrit :
>
> As I wrote, SQL Workbench is good benchmark - it is not possible to
>> select columns without named table, again, there is even possibility to
>> filter list of available elements (tables, views, columns,...).
>> In
Hi,
it is possible to set autovacuum_analyze_threshold
and autovacuum_analyze_scale_factor for TOAST tables using pgAdmin.
Script generated is like this:
ALTER TABLE "MySchema"."MyTable" SET (
toast.autovacuum_analyze_threshold = 50,
toast.autovacuum_analyze_scale_factor = 0.1
);
according to
