Thank you a lot, Craig, that's really insightful and exhaustively
complete explanation I've expected!
2011/9/10 Craig Ringer ring...@ringerc.id.au:
On 10/09/2011 1:55 AM, Antonio Rodriges wrote:
Hello,
Does anyone know whether PostgreSQL uses DMA (Direct Memory Access) in
certain cases to
Hello,
Does anyone know whether PostgreSQL uses DMA (Direct Memory Access) in
certain cases to improve networking IO performance?
I mean simple query is which doesn't require any CPU processing, for ex
SELECT column_a FROM table_b WHERE date = 2001-10-05
I need this to devise the best logic for
On Fri, Sep 9, 2011 at 11:55 AM, Antonio Rodriges antonio@gmail.com wrote:
Hello,
Does anyone know whether PostgreSQL uses DMA (Direct Memory Access) in
certain cases to improve networking IO performance?
I mean simple query is which doesn't require any CPU processing, for ex
SELECT
Scott, regardless of operating system support for DMA, an application
may not benefit from it if it doesn't use appropriate system calls.
PostgreSQL is implemented mostly in C, so I do not know whether it
needs to use special procedure calls, however this is true, for
example, for Java
Look at developer faq.
2011/9/9, Antonio Rodriges antonio@gmail.com:
Hello,
Does anyone know whether PostgreSQL uses DMA (Direct Memory Access) in
certain cases to improve networking IO performance?
I mean simple query is which doesn't require any CPU processing, for ex
SELECT column_a
Antonio Rodriges antonio@gmail.com wrote:
PostgreSQL is implemented mostly in C, so I do not know whether it
needs to use special procedure calls, however this is true, for
example, for Java
http://www.ibm.com/developerworks/library/j-zerocopy/
After scanning that I'm inclined to think
On 10/09/2011 1:55 AM, Antonio Rodriges wrote:
Hello,
Does anyone know whether PostgreSQL uses DMA (Direct Memory Access) in
certain cases to improve networking IO performance?
From what you described in your message it sounds like what you really
want is not DMA, but use of something like