: GenuineIntel
cpu family : 6
model : 62
model name : Intel(R) Xeon(R) CPU E7-4880 v2 @ 2.50GHz
-Original Message-
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Monday, October 26, 2015 8:04 AM
To: Jamie Koceniak
Cc: Pavel Stehule; pgsql-performance
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
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
tgres: user1
db 0.0.0.3(36638) SELECT
-Original Message-
From: Merlin Moncure [mailto:mmonc...@gmail.com]
Sent: Wednesday, October 21, 2015 12:50 PM
To: Pavel Stehule
Cc: Jamie Koceniak; pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Recursive query performance issue
On Wed, O
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 Us
effective_cache_size = 512GB (25% of total memory)
Thanks,
Jamie
From: Pavel Stehule [mailto:pavel.steh...@gmail.com]
Sent: Wednesday, October 21, 2015 12:04 AM
To: Jamie Koceniak
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Recursive query performance issue
Hi
2015-10-20 19:34 GMT+02:00
Version:
---
PostgreSQL 9.1.14 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.7.2-5)
4.7.2, 64-bit
Query Plan
http://explain.depesz.com/s/4s37
Normally, this query takes around 200-300 ms to execu
