Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem [(AUTO-RE)SOLVED...]

Il 14/04/2017 21:15, Igor Neyman ha scritto:   From: Moreno Andreo [mailto:moreno.and...@evolu-s.it] Sent: Friday, April 14, 2017 3:11 PM

Re: [GENERAL] Error During PostGIS Build From Source on Linux

Hi Adrian, I installed Proj from source and I can confirm that the file libproj.so.12 is in its lib folder. I have not been able to confirm if it is linked to postgis-2.3.so as I am away for Easter holiday. Just in case, how do I do the linking of libproj.so.12 to postgis-2.3.so as I believe

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

From: Moreno Andreo [mailto:moreno.and...@evolu-s.it] Sent: Friday, April 14, 2017 3:11 PM To: Igor Neyman ; Melvin Davidson Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Service outage: each postgres process use the exact amount of the

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Il 14/04/2017 21:06, Igor Neyman ha scritto:   From: Moreno Andreo [mailto:moreno.and...@evolu-s.it] Sent: Friday, April 14, 2017 3:00 PM

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

From: Moreno Andreo [mailto:moreno.and...@evolu-s.it] Sent: Friday, April 14, 2017 3:00 PM To: Igor Neyman ; Melvin Davidson Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Service outage: each postgres process use the exact amount of the

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Il 14/04/2017 20:55, Melvin Davidson ha scritto: On Fri, Apr 14, 2017 at 2:42 PM, Chris Mair wrote: you should increase shared_memory to 40GB. General

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Il 14/04/2017 20:40, Igor Neyman ha scritto:   E. How many users were connected when the problem occurred? About 350 connections

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

On Fri, Apr 14, 2017 at 2:42 PM, Chris Mair wrote: > you should increase shared_memory to 40GB. General philosphy is to >> allocate 80% of system memory to shared_memory >> > > Uhm... > > 80% is too much, likely: > >

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

you should increase shared_memory to 40GB. General philosphy is to allocate 80% of system memory to shared_memory Uhm... 80% is too much, likely: https://www.postgresql.org/docs/9.5/static/runtime-config-resource.html Bye, Chris. -- Sent via pgsql-general mailing list

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

E. How many users were connected when the problem occurred? About 350 connections Thanks __ Probably that is your problem, if you don’t have connection pooler. I’d recommend to start with PgBouncer, very

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

On Fri, Apr 14, 2017 at 2:28 PM, Moreno Andreo wrote: > Melvin, > Sorry for top-posting. > I'm going ahead in troubleshooting. As Jeff said, there's probably nothing > wrong with my values (at the end of the message you can find minimal info > you requested). > I

Re: [GENERAL] dynamic schema modeling and performance

Some example queries are: give me all attributes for entity1 where entity1.attribute1 > 1000 and entity1.attribute15 = "someValue" give me all attributes for entity1 where entity1.parentId = 1 give me all attributes for entity1 & parent_entity where entity1.attribute2 = "this" ​Nothing too

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Melvin,     Sorry for top-posting.    I'm going ahead in troubleshooting. As Jeff said, there's probably nothing wrong with my values (at the end of the message you can find minimal info you requested). I tried running some queries against psql server and

Re: [GENERAL] dynamic schema modeling and performance

Op 14/04/2017 om 19:03 schreef Rj Ewing: We do know where we want to end up. We've had the application running for a while using a triple store db. We're looking to move away from the triple store due to performance issues. Our core concept is that each project can define a set of entities

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Sorry, my mistake (I'm a bit nervous...) that's not work_mem, but shared_buffers Hi. The resident set size of the worker processes includes all shared memory blocks they touched. So it's not that each of those workers allocated their own 3GB... (in Linux at least) Bye, Chris. --

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

On Fri, Apr 14, 2017 at 10:12 AM, Moreno Andreo wrote: > Hi all, > About 2 hours and half ago, suddenly (and on the late afternoon of the > Easter Friday), customers reported failing connections to our server, or > even very slow. > After a bit of checking (that also

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

On Fri, Apr 14, 2017 at 1:50 PM, Moreno Andreo wrote: > Sorry, > my mistake (I'm a bit nervous...) > > that's not work_mem, but shared_buffers > > Thanks > > > Il 14/04/2017 19:33, Melvin Davidson ha scritto: > > > > On Fri, Apr 14, 2017 at 1:12 PM, Moreno Andreo

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Sorry,  my mistake (I'm a bit nervous...) that's not work_mem, but shared_buffers Thanks Il 14/04/2017 19:33, Melvin Davidson ha scritto: On Fri, Apr 14, 2017 at 1:12 PM, Moreno Andreo

Re: [GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

On Fri, Apr 14, 2017 at 1:12 PM, Moreno Andreo wrote: > Hi all, > About 2 hours and half ago, suddenly (and on the late afternoon of the > Easter Friday), customers reported failing connections to our server, or > even very slow. > After a bit of checking (that also

[GENERAL] Service outage: each postgres process use the exact amount of the configured work_mem

Hi all, About 2 hours and half ago, suddenly (and on the late afternoon of the Easter Friday), customers reported failing connections to our server, or even very slow. After a bit of checking (that also involved server reboot) I noticed (using top) that every process

Re: [GENERAL] dynamic schema modeling and performance

We do know where we want to end up. We've had the application running for a while using a triple store db. We're looking to move away from the triple store due to performance issues. Our core concept is that each project can define a set of entities and their relations. Each entity has a set of