Re: How to prevent POSTGRES killing linux system from accepting too much inserts?

THE TRUTH CANNOT BE HIDDEN **Explosion in my car. https://www.docdroid.net/s11XHOS/the-truth-cannot-be-hidden.pdf On Wed, 18 Dec 2019, 10:54 James(王旭), wrote: > Hello, >> >> I encountered into this kernel message, and I cannot login into the Linux >> system anymore: > > >> >> Dec 17 23:01:50

Re: How to prevent POSTGRES killing linux system from accepting too much inserts?

On Wed, Dec 18, 2019 at 4:53 AM James(王旭) wrote: > Hello, >> >> I encountered into this kernel message, and I cannot login into the Linux >> system anymore: > > >> >> Dec 17 23:01:50 hq-pg kernel: sh (6563): drop_caches: 1 >> >> Dec 17 23:02:30 hq-pg kernel: INFO: task sync:6573 blocked for more

Re: How to prevent POSTGRES killing linux system from accepting too much inserts?

On Wed, Dec 18, 2019 at 3:53 AM James(王旭) wrote: > > Hello, >> >> I encountered into this kernel message, and I cannot login into the Linux >> system anymore: >> >> >> >>> Dec 17 23:01:50 hq-pg kernel: sh (6563): drop_caches: 1 >>> >>> Dec 17 23:02:30 hq-pg kernel: INFO: task sync:6573 blocked fo

Re: Consecutive Query Executions with Increasing Execution Time

Laurenz Albe writes: > On Tue, 2019-12-17 at 11:11 -0500, Jeff Janes wrote: >> If it is doing a seq scan (I don't know if it is) they intentionally use a >> small ring buffer to, so they evict their own recently used blocks, rather >> than evicting other people's blocks. So these blocks won't bui

Re: Consecutive Query Executions with Increasing Execution Time

On Tue, 2019-12-17 at 11:11 -0500, Jeff Janes wrote: > On Tue, Dec 17, 2019 at 8:08 AM Laurenz Albe wrote: > > On Mon, 2019-12-16 at 15:50 -0500, Tom Lane wrote: > > > Peter Geoghegan writes: > > > > Why do the first and the twentieth executions of the query have almost > > > > identical "buffers

Re: shared memory size during upgrade pgsql with partitions (max_locks_per_transaction)

>> On Tue, Dec 17, 2019 at 08:03:41PM +, Piotr Włodarczyk wrote: >> Currently we're working on PSQL 11.5 and we're trying upgrade to 12.1. >> >> During that we have a problem: >> >> command: "/usr/pgsql-12/bin/pg_dump" --host /cluster/postgresql --port 50432 >> --username postgres --schema-on

How to prevent POSTGRES killing linux system from accepting too much inserts?

Hello,I encountered into this kernel message, and I cannot login into the Linux system anymore: Dec 17 23:01:50 hq-pg kernel: sh (6563): drop_caches: 1Dec 17 23:02:30 hq-pg kernel: INFO: task sync:6573 blocked for more than 120 seconds.Dec 17 23:02:30 hq-pg kernel: "echo 0 > /proc/sys/kernel/hu