Re: [PERFORM] Hardware advice for scalable warehouse db

2011-07-27 Thread Terry Schmitt
Hi Chris, A couple comments on the NetApp SAN. We use NetApp, primarily with Fiber connectivity and FC drives. All of the Postgres files are located on the SAN and this configuration works well. We have tried iSCSI, but performance his horrible. Same with SATA drives. The SAN will definitely be mo

Re: [PERFORM] UPDATEDs slowing SELECTs in a fully cached database

2011-07-27 Thread Pavan Deolasee
On Wed, Jul 13, 2011 at 10:52 AM, Merlin Moncure wrote: > On Tue, Jul 12, 2011 at 6:15 PM, lars wrote: >> Back to the first case, here's an strace from the backend doing the select >> right after the updates. >> write(13, >> "f\320\1\0\1\0\0\0\273\0\0\0\0\340\27\22`\32\0\0002833!000"..., 2400