Re: [PERFORM] CPU bound

2011-01-03 Thread Mladen Gogala
Jim Nasby wrote: On Dec 20, 2010, at 12:47 AM, Mladen Gogala wrote: Good time accounting is the most compelling reason for having a wait event interface, like Oracle. Without the wait event interface, one cannot really tell where the time is spent, at least not without profiling the

[PERFORM] Question: BlockSize 8192 with FusionIO

2011-01-03 Thread Strange, John W
Has anyone had a chance to recompile and try larger a larger blocksize than 8192 with pSQL 8.4.x? I'm finally getting around to tuning some FusionIO drives that we are setting up. We are looking to setup 4 fusionIO drives per server, and then use pgpooler to scale them to 3 servers so that we

Re: [PERFORM] Question: BlockSize 8192 with FusionIO

2011-01-03 Thread Greg Smith
Strange, John W wrote: Has anyone had a chance to recompile and try larger a larger blocksize than 8192 with pSQL 8.4.x? While I haven't done the actual experiment you're asking about, the problem working against you here is how WAL data is used to protect against partial database writes.

Re: [PERFORM] Performance of PostgreSQL over NFS

2011-01-03 Thread Greg Smith
Mladen Gogala wrote: Rich wrote: I am wondering why anyone would do that? Too much overhead and no reliable enough. Apparently, NetApp thinks that it is reliable. They're selling that stuff for years. I know that Oracle works with NetApp, they even have their own user mode NFS client