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
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
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.
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