adama_prod=# SHOW shared_buffers;
shared_buffers
64GB
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Wednesday, October 21, 2015 12:26 PM
To: Jamie Koceniak
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Recursive query performance issue
2015-10-21 20:5
Ok
df -h /dev/shm
Filesystem Size Used Avail Use% Mounted on
tmpfs 406G 0 406G 0% /run/shm
Ok I will try lowering it.
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Wednesday, October 21, 2015 11:24 AM
To: Jamie Koceniak
Cc: pgsql-performance@postgresql.org
Sub
Hi,
We just had the performance problem again today.
Here is some of the top output. Unfortunately, we don't have perf top installed.
top - 16:22:16 up 29 days, 13:00, 2 users, load average: 164.63, 158.62,
148.52
Tasks: 1369 total, 181 running, 1188 sleeping, 0 stopped, 0 zombie
%Cpu(s):
Hi Pavel,
Or were you referring to SHMMAX?
Thanks
From: Jamie Koceniak
Sent: Wednesday, October 21, 2015 11:40 AM
To: 'Pavel Stehule'
Cc: pgsql-performance@postgresql.org
Subject: RE: [PERFORM] Recursive query performance issue
Ok
df -h /dev/shm
Filesystem Size Used Avail Use% Mounted on
Hi Pavel,
Thanks for the reply.
1. The queries aren’t waiting on any locks.
The query has a recursive join that uses a table with only 80k records and that
table is not updated often.
2. The I/O load was not high. CPU utilization was very high and load was very
high.
We have a large effective_
