Re: [PERFORM] Performance issues

2015-03-14 Thread Gavin Flower
On 14/03/15 13:12, Tomas Vondra wrote: On 14.3.2015 00:28, Vivekanand Joshi wrote: Hi Guys, So here is the full information attached as well as in the link provided below: http://pgsql.privatepaste.com/41207bea45 I can provide new information as well. Thanks. We still don't have EXPLAIN

Re: [PERFORM] Performance issues

2015-03-14 Thread Varadharajan Mukundan
Hi Gavin, Vivekanand is his first mail itself mentioned the below configuration of postgresql.conf. It looks good enough to me. Total Memory : 8 GB shared_buffers = 2GB work_mem = 64MB maintenance_work_mem = 700MB effective_cache_size = 4GB On Sat, Mar 14, 2015 at 10:06 PM, Gavin Flower

Re: [PERFORM] Performance issues

2015-03-14 Thread Gavin Flower
On 15/03/15 10:23, Varadharajan Mukundan wrote: Hi Gavin, Vivekanand is his first mail itself mentioned the below configuration of postgresql.conf. It looks good enough to me. Total Memory : 8 GB shared_buffers = 2GB work_mem = 64MB maintenance_work_mem = 700MB effective_cache_size = 4GB

Re: [PERFORM] Anyone have experience using PG on a NetApp All-Flash FAS8000?

2015-03-14 Thread Varadharajan Mukundan
Hi Mel, I don't have any experience in NetApp storage systems, but if compression / deduplication is the only point for which you're consider NetApp, then do consider FS like ZFS or btrfs which can do deduplication as well as compression on normal disks. Here are few reports of running Postgres