[PERFORM] How to find the culprit in server load spikes?

Hi everyone, I host a Postgresql server on Ubuntu 12.04 and I am facing server load spikes (if I run top, it goes up to 25-30 on a 4-core system)... In some cases, I have to restart potgresql service because users call us complaining of the slowness, but in some cases I can leave things on

Re: [SPAM] Re: [PERFORM] Architectural question

ce, so I'm quite a bit of novice in being a DBA (but a novice that when needed reads a lot of documentation :-) ) So, if some questions may sound "strange", "noobish" to you, that's the reason. On 2/11/16 12:06 PM, Moreno Andreo wrote: Now, the actual question, is: Ha

[PERFORM] Architectural question

Hi everyone, I have a question that I hope fits in this discussion group. I'm migrating my actual server into a new, more powerful architecture on Google Cloud Platform. ATM the server is a VM with 4 vCPUs (the host has 4 Xeon E2xx 3,1 GHZ, if I remember) and 32 GB RAM, just running Ubuntu

Re: [PERFORM] Architectural question

Il 23/03/2016 13:29, Mike Sofen ha scritto: -Original Message- Thomas Kellerer Wednesday, March 23, 2016 2:51 AM Jim Nasby schrieb am 11.03.2016 um 17:37: If the blob is in the database then you have nothing extra to do. It's handled just like all your other data. If it's a file in a

Re: [PERFORM] Architectural question

Il 23/03/2016 10:50, Thomas Kellerer ha scritto: Jim Nasby schrieb am 11.03.2016 um 17:37: If the blob is in the database then you have nothing extra to do. It's handled just like all your other data. If it's a file in a file system then you need to: - Have application code that knows how

Re: [SPAM] Re: [PERFORM] Architectural question

Il 23/03/2016 19:51, Jim Nasby ha scritto: On 3/23/16 4:14 AM, Moreno Andreo wrote: The main goal is to be *quick*. A doctor with a patient on the other side of his desk does not want to wait, say, 30 seconds for a clinical record to open. Let me explain what is the main problem (actually

Re: [SPAM] Re: [PERFORM] autovacuum disk IO

Il 02/03/2016 19:40, Alvaro Herrera ha scritto: Scott Marlowe wrote: On Wed, Mar 2, 2016 at 9:11 AM, Moreno Andreo <moreno.and...@evolu-s.it> wrote: ... or maybe add some more RAM to have more disk caching (if you're on *nix) this worked for me in the past... even if IMHO it'

Re: [SPAM] Re: [PERFORM] autovacuum disk IO

Il 02/03/2016 16:49, Scott Marlowe ha scritto: On Wed, Mar 2, 2016 at 8:45 AM, Scott Marlowe wrote: On Wed, Mar 2, 2016 at 8:25 AM, Artem Tomyuk wrote: Hi. I've noticed that autovac. process worked more than 10 minutes, during this zabbix

Re: [PERFORM] Big number of connections

Il 04/04/2016 15:33, Pavel Stehule ha scritto: PostgreSQL doesn't contain integrated pooler - so any connection to Postgres enforces one PostgreSQL proces. A performance benchmarks is showing maximum performance about 10x cores. With high number of connections you have to use low size of

Re: [PERFORM] Big number of connections

Il 04/04/2016 16:54, Artem Tomyuk ha scritto: 2016-04-04 17:43 GMT+03:00 Moreno Andreo <moreno.and...@evolu-s.it>: s there a way to monitor active connections, or at least to

Re: [SPAM] Re: [PERFORM] Architectural question

Il 11/03/2016 17:37, Jim Nasby ha scritto: On 2/22/16 8:40 AM, Moreno Andreo wrote: Il 18/02/2016 21:33, Jim Nasby ha scritto: Depending on your needs, could could use synchronous replication as part of that setup. You can even do that at a per-transaction level, so maybe you use sync rep most

Re: [PERFORM] Filter certain range of IP address.

Il 07/04/2017 17:56, Rick Otten ha scritto: On Fri, Apr 7, 2017 at 11:29 AM, David G. Johnston wrote: On Fri, Apr 7, 2017 at

Re: [PERFORM] Rollback table data.

Il 07/06/2017 13:33, Dinesh Chandra 12108 ha scritto: Dear Expert,   Is there any way to rollback table data in PostgreSQL? Not knowing anything else about your what you want to do and what

Re: [SPAM] [PERFORM] OS cache management

Il 06/09/2017 10:12, Soni M ha scritto: Let's say I have 10 year data, and commonly used data only the last 1 year. This data is quite big, so each table and index file is divided into several file in PGDATA/base May not be relevant to what you asked, but if you want to keep last yeat