Re: [SPAM] Re: [GENERAL] Question about locking and pg_locks

2016-09-12 Thread Adrian Klaver
On 09/12/2016 12:47 AM, Moreno Andreo wrote: Ccing list. Il 08/09/2016 15:26, Adrian Klaver ha scritto: so, I should be able to manage 800*64 = 5120 locks, right? OMG, time to go back to school... 800*64 = 51200 ! ! ! Now my pg_locks table has more than 6200 rows, but if I reorder them by

Re: [GENERAL] Question about locking and pg_locks

2016-09-12 Thread Moreno Andreo
Il 10/09/2016 23:07, Jeff Janes ha scritto: On Thu, Sep 8, 2016 at 4:30 AM, Moreno Andreo wrote: Hi folks! :-) This morning I was woken up by a call of a

Re: [GENERAL] Question about locking and pg_locks

2016-09-10 Thread Jeff Janes
On Thu, Sep 8, 2016 at 4:30 AM, Moreno Andreo wrote: > Hi folks! :-) > > This morning I was woken up by a call of a coworker screaming "Help, our > Postgres server is throwing strange errors!" > Not the best way to start your day... > > OK, to the serious part. > > "Strange errors" were (in postg

Re: [GENERAL] Question about locking and pg_locks

2016-09-08 Thread Adrian Klaver
On 09/08/2016 04:30 AM, Moreno Andreo wrote: Hi folks! :-) This morning I was woken up by a call of a coworker screaming "Help, our Postgres server is throwing strange errors!" Not the best way to start your day... OK, to the serious part. "Strange errors" were (in postgresql-9.1-main.log) WAR

[GENERAL] Question about locking and pg_locks

2016-09-08 Thread Moreno Andreo
Hi folks! :-) This morning I was woken up by a call of a coworker screaming "Help, our Postgres server is throwing strange errors!" Not the best way to start your day... OK, to the serious part. "Strange errors" were (in postgresql-9.1-main.log) WARNING: out of shared memory ERROR: out of sha