Re: fdatasync performance problem with large number of DB files

On 2021-02-22 5:43 p.m., Tom Lane wrote: > Michael Brown writes: >> * is there a knob missing we can configure? > > No. The trouble with sync() is that per POSIX, it only schedules the > writes; there's no way to tell when the work has been done. I see > that Linux offers stronger promises in t

Re: fdatasync performance problem with large number of DB files

Michael Brown writes: > I presume the reason postgres doesn't blindly run a sync() is that we > don't know what other I/O is on the system and it'd be rude to affect > other services. That makes sense, except for our environment the work > done by the recursive fsync is orders of magnitude more di

fdatasync performance problem with large number of DB files

We've encountered a production performance problem with pg13 related to how it fsyncs the whole data directory in certain scenarios, related to what Paul (bcc'ed) described in a post to pgsql-hackers [1]. Background: We've observed the full recursive fsync is triggered when

Re: Performance Problem

om/Y8ybSxq4 > > I have performance problem with postgresql.What is wrong ? I can not find > what is problem. >

Re: Performance Problem

on > is N-Tier Architecture & 40 online user . My postgresql.conf here: > > https://pastebin.com/Y8ybSxq4 > > I have performance problem with postgresql.What is wrong ? I can not find > what is problem. > Not really sure how anyone else would be able to either. Here are s

Performance Problem

here: https://pastebin.com/Y8ybSxq4 I have performance problem with postgresql.What is wrong ? I can not find what is problem.

Re: Performance problem postgresql 9.5

Guys, indeed I had an intruder, with the recent migration I installed a remote mirror that had a vulnerability. Thank you very much for your fast response. My best regards Libre de virus

Re: Performance problem postgresql 9.5

Am 08.06.2018 um 22:09 schrieb Alvaro Herrera: On 2018-Jun-08, Miguel Angel Sanchez Sandoval wrote: Hi guys, migrate from 8.4 to 9.5, all OK except that 2-3 days pass and the database experiences slowness, I execute the linux top command and it shows me a postgres user process executing a st

Re: Performance problem postgresql 9.5

On 06/08/2018 03:56 PM, Miguel Angel Sanchez Sandoval wrote: > I see the querys active and encounter > select fun ('./ 2yhdgrfrt63788') Would it be possible (observing appropriate precautions for a compromised server) to report here the language and definition of any function(s) named 'fun' in th

Re: Performance problem postgresql 9.5

> On Jun 8, 2018, at 1:09 PM, Alvaro Herrera wrote: > > On 2018-Jun-08, Miguel Angel Sanchez Sandoval wrote: > >> Hi guys, migrate from 8.4 to 9.5, all OK except that 2-3 days pass and the >> database experiences slowness, I execute the linux top command and it shows >> me a postgres user proc

Re: Performance problem postgresql 9.5

On 2018-Jun-08, Miguel Angel Sanchez Sandoval wrote: > Hi guys, migrate from 8.4 to 9.5, all OK except that 2-3 days pass and the > database experiences slowness, I execute the linux top command and it shows > me a postgres user process executing a strange command (2yhdgrfrt63788) > that I consume

Re: Performance problem postgresql 9.5

Could you please give more briefing about the queries executed. Let me know whether they are dml or ddl. Provide information like how long and from what time the queries are in running state, so that we can find a way to find the exact pain area. What is the size of the database?? When were the s

Performance problem postgresql 9.5

Hi guys, migrate from 8.4 to 9.5, all OK except that 2-3 days pass and the database experiences slowness, I execute the linux top command and it shows me a postgres user process executing a strange command (2yhdgrfrt63788) that I consume a lot of CPU, I see the querys active and encounter select fu