Re: [GENERAL] JSONB performance enhancement for 9.6

Hello: I'd like to bring this JSONB performance issue again. Below is a link of MySQL way of storing/retrieving Json key/value https://dev.mysql.com/doc/refman/5.7/en/json.html Instead of providing column indexing(like GIN for JSONB in Postgresql). it provides only internal data structure level

Re: [GENERAL] intermittent issue with windows 7 service manager not able to correctly determine or control postgresql 9.4

I have the same problem routinely on Windows 10. The postgresql-x64-9.5 service shows up in Task Manager as Stopped, but is actually running just fine. BTW pg_ctl does nothing – silently. The only way to restart the server is to kill off a process or two. Regards David M Bennett

Re: [GENERAL] Skip trigger?

On 2016-04-30 02:08, wolfg...@alle-noten.de wrote: > Hi, > > I have a table with a row update trigger that is quite slow. > The trigger finction basically sets some bits in a "changed" column > depending on which values really changed. > For some bulk updates it can be determined in advance that

Re: [GENERAL] Vacuum of large tables causing replication delays to hot standby

9.2.12 Sent from my iPhone > On Apr 30, 2016, at 12:37 PM, Tom Lane wrote: > > Jeff Mcdowell writes: >> 95% of the time, the delay is only microseconds. But we have discovered that >> whenever the master does an auto vacuum of a large table,

Re: [GENERAL] Vacuum of large tables causing replication delays to hot standby

Tom Lane wrote: > Jeff Mcdowell writes: > > 95% of the time, the delay is only microseconds. But we have discovered > > that whenever the master does an auto vacuum of a large table, the > > transaction replay delay can climb is high as 1 hour. These delays don�t

Re: [GENERAL] Vacuum of large tables causing replication delays to hot standby

Jeff Mcdowell writes: > 95% of the time, the delay is only microseconds. But we have discovered that > whenever the master does an auto vacuum of a large table, the transaction > replay delay can climb is high as 1 hour. These delays don’t seem to > correlate

[GENERAL] Vacuum of large tables causing replication delays to hot standby

Hello All, In an attempt to offload some of the pressure off our master postgres node, We recently decided to start running reports off of our hot-standby. There is a desire for these reports to return fairly current data, so we have been monitoring the replication delay between the master ->

Re: [GENERAL] Why don't custom GUCs show in pg_settings?

On Sat, Apr 30, 2016 at 9:39 AM, Tom Lane wrote: > "David G. Johnston" writes: > > I've seen and can work with various work-arounds but it seems odd that > > pg_settings doesn't show these custom GUCs. > > Because we don't know what type they

Re: [GENERAL] Why don't custom GUCs show in pg_settings?

"David G. Johnston" writes: > I've seen and can work with various work-arounds but it seems odd that > pg_settings doesn't show these custom GUCs. Because we don't know what type they should be. If we're ever to support custom GUCs properly, rather than as a hack

[GENERAL] Why don't custom GUCs show in pg_settings?

Version - 9.5 O/S - not applicable SELECT set_config('davidj.testvar', 'value'); SELECT current_setting('davidj.testvar') --value SELECT * FROM pg_settings WHERE name ~ 'testvar' --or ~davidj... either way nothing shows and: SELECT current_setting('davidj.testvar2') -- unrecognized

Re: [GENERAL] Skip trigger?

On Sat, Apr 30, 2016 at 1:38 AM, wrote: > I have a table with a row update trigger that is quite slow. > The trigger finction basically sets some bits in a "changed" column > depending on which values really changed. > For some bulk updates it can be determined in advance

Re: [GENERAL] Skip trigger?

If your other inserts can wait you could maybe combine DISABLE TRIGGER with LOCK TABLE? http://www.postgresql.org/docs/current/static/sql-lock.html Someone else may know a better solution... -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] Why are data files stored in /var/lib

W dniu 30.04.2016 o 05:45, Manuel Gómez pisze: > On Fri, Apr 29, 2016 at 11:00 PM, Charles Clavadetscher > wrote: >> I had a discussion yesterday with some friends, who are sysadmins about the >> location of database files. In a default installation >> from a

[GENERAL] Skip trigger?

Hi, I have a table with a row update trigger that is quite slow. The trigger finction basically sets some bits in a "changed" column depending on which values really changed. For some bulk updates it can be determined in advance that the trigger function will not have any effect. Is there any way

Re: [GENERAL] Why are data files stored in /var/lib

On 4/29/2016 8:30 PM, Charles Clavadetscher wrote: I had a discussion yesterday with some friends, who are sysadmins about the location of database files. In a default installation from a distribution (apt-get install) PostgreSQL creates a cluster unter/var/lib/. According to my colleagues