[pgadmin-support] MACOSX Dropped Connection on Hibernate

2012-02-01 Thread Paul Morris
When my MacBook Pro (Snow Leopard w/4GB RAM) goes to sleep for any length of time while I have PGAdmin III 1.41.1 running and connected to my remote PG server, it drops the connection. And the only way to get it back is to shut down PGAdmin and restart it. Very annoying, and it only started happ

Re: [pgadmin-support] Custom Auto Vacuum factors

2012-02-01 Thread bdmyt...@eranet.pl
I tried to capture a screen shot and I changed language to en_US, then pgAdmin displayed proper values. When I changed it back to pl_PL (or default) I saw 0 again. So I think it could be related somehow with localization. TOAST autovacuum has been enabled previously, so my script enables only au

Re: [pgadmin-support] Performance of pgAdmin 14 Beta 2

2012-02-01 Thread Kieran McCusker
Sorry A slip of the mind - I'm actually using 1.14.1 - I had just checked the development log before sending to see if a fix or problem was reported in 14.2. I'm not sure what you mean by "This kind of trigger shouldn't be displayed. It's fixed in the source code, but not yet available to the gen

Re: [pgadmin-support] Performance of pgAdmin 14 Beta 2

2012-02-01 Thread Guillaume Lelarge
Hi, On Wed, 2012-02-01 at 10:28 +, Kieran McCusker wrote: > [...] > I've noticed the performance of version 14.2 is very slow when clicking > on tables. > If by 14.2, you mean 1.14 beta 2, you first need to upgrade to 1.14.1. Don't use a beta release when the stable one is released. > ~3 se

[pgadmin-support] Performance of pgAdmin 14 Beta 2

2012-02-01 Thread Kieran McCusker
Hi I've noticed the performance of version 14.2 is very slow when clicking on tables. ~3 seconds for V14.2. Looking at the logs I see the following:- SELECT pr.oid, pr.xmin, pr.*, format_type(TYP.oid, NULL) AS typname, typns.nspname AS typnsp, lanname, proargnames, pg_get_expr(proargdefaults, '

Re: [pgadmin-support] Custom Auto Vacuum factors

2012-02-01 Thread Guillaume Lelarge
On Wed, 2012-02-01 at 09:02 +0100, bdmyt...@eranet.pl wrote: > Hi, > I executed SQL like this one: > ALTER TABLE "public"."tblTest" SET ( > autovacuum_vacuum_scale_factor = 0.002, > autovacuum_analyze_scale_factor = 0.001 > ); > to set custom autovacuum parameters. pgAdmin in table property tab sho

[pgadmin-support] Custom Auto Vacuum factors

2012-02-01 Thread bdmyt...@eranet.pl
Hi, I executed SQL like this one: ALTER TABLE "public"."tblTest" SET ( autovacuum_vacuum_scale_factor = 0.002, autovacuum_analyze_scale_factor = 0.001 ); to set custom autovacuum parameters. pgAdmin in table property tab shows 0 for vacuum and analyze scale factors instead of 0.002 and 0.001. Scri