Re: [PERFORM] NFS, file system cache and shared_buffers

2014-05-30 Thread Albe Laurenz
I wrote: >Jeff Janes wrote: All that said, there has always been a recommendation of caution around using NFS as a backing store for PG, or any RDBMS.. >>> >>> I know that Oracle recommends it - they even built an NFS client >>> into their database server to make the most of it. >

[PERFORM] SELECT outage in semop

2014-05-30 Thread Сурен Арустамян
Hi all, I'm using postgresql 9.3.4 on Red Hat Enterprise Linux Server release 6.5 (Santiago)  Linux 193-45-142-74 2.6.32-431.17.1.el6.x86_64 #1 SMP Fri Apr 11 17:27:00 EDT 2014 x86_64 x86_64 x86_64 GNU/Linux Server specs: 4x Intel(R) Xeon(R) CPU E7- 4870  @ 2.40GHz (40 physical cores in total)

[PERFORM] Re: SELECT outage in semop

2014-05-30 Thread Сурен Арустамян
Excuse me last e-mail was not full. Here is the rest: Once more trace where problem is seen: 41733 20:15:09.682258 lseek(43, 0, SEEK_END) = 8192 <0.07> 41733 20:15:09.682290 lseek(44, 0, SEEK_END) = 16384 <0.07> 41733 20:15:09.682365 brk(0x1a79000) = 0x1a79000 <0.10> 41733 20:15:09.68

Re: [PERFORM] SELECT outage in semop

2014-05-30 Thread Albe Laurenz
Сурен Арустамян wrote: > I'm using postgresql 9.3.4 on Red Hat Enterprise Linux Server release 6.5 > (Santiago) > > Linux 193-45-142-74 2.6.32-431.17.1.el6.x86_64 #1 SMP Fri Apr 11 17:27:00 EDT > 2014 x86_64 x86_64 > x86_64 GNU/Linux > > Server specs: > 4x Intel(R) Xeon(R) CPU E7- 4870 @ 2.40