Re: [PERFORM] 9.4 -> 9.5 regression with queries through pgbouncer on RHEL 6

2016-06-09 Thread Andres Freund
Hi, On 2016-06-02 14:18:26 +0300, Антон Бушмелев wrote: > UP. repeat tests on local vm.. reults are discouraging > OSPG TPS AVG latency > Centos 7 9.5.3 23.711023 168.421 > Centos 7 9.5.3 26.609271 150.188 > Centos 7 9.5.3 25.220044

Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json

2016-06-09 Thread Merlin Moncure
On Thu, Jun 9, 2016 at 8:43 AM, Nicolas Paris wrote: > > > 2016-06-09 15:31 GMT+02:00 Merlin Moncure : >> >> On Wed, Jun 8, 2016 at 1:04 AM, Tom Lane wrote: >> > Michael Paquier writes: >> >> On Tue, Jun 7, 2016 at 10:03 PM, Josh Berkus wrote: >> >>> On 06/07/2016 08:42 AM, Nicolas Paris wrote:

Re: [PERFORM] Performance of LIKE/NOT LIKE when used in single query

2016-06-09 Thread Jeff Janes
On Tue, Jun 7, 2016 at 9:57 PM, Ed Felstein wrote: > Hello, > First time poster here. Bear with me. > Using PostgreSQL 9.5 > I have a situation where I have a LIKE and a NOT LIKE in the same query to > identify strings in a varchar field. Since I am using wildcards, I have > created a GIN index

Re: [PERFORM] slony rpm help slony1-95-2.2.2-1.rhel6.x86_64

2016-06-09 Thread Glyn Astill
> From: avi Singh >To: pgsql-performance@postgresql.org >Sent: Saturday, 4 June 2016, 0:03 >Subject: [PERFORM] slony rpm help slony1-95-2.2.2-1.rhel6.x86_64 > > > >Hi All > Can anyone please point me to location from where i can get slony > slony1-95-2.2.2-1.rhel5.x86_64 rpm. I'm upgra

Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json

2016-06-09 Thread Nicolas Paris
2016-06-09 15:31 GMT+02:00 Merlin Moncure : > On Wed, Jun 8, 2016 at 1:04 AM, Tom Lane wrote: > > Michael Paquier writes: > >> On Tue, Jun 7, 2016 at 10:03 PM, Josh Berkus wrote: > >>> On 06/07/2016 08:42 AM, Nicolas Paris wrote: > Will this 1GO restriction is supposed to increase in a nea

Re: [PERFORM] array size exceeds the maximum allowed (1073741823) when building a json

2016-06-09 Thread Merlin Moncure
On Wed, Jun 8, 2016 at 1:04 AM, Tom Lane wrote: > Michael Paquier writes: >> On Tue, Jun 7, 2016 at 10:03 PM, Josh Berkus wrote: >>> On 06/07/2016 08:42 AM, Nicolas Paris wrote: Will this 1GO restriction is supposed to increase in a near future ? > >>> Not planned, no. Thing is, that's the