Re: [PERFORM] PostgreSQL insights: does it use DMA?

2011-09-10 Thread Antonio Rodriges
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

[PERFORM] PostgreSQL insights: does it use DMA?

2011-09-09 Thread Antonio Rodriges
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

Re: [PERFORM] PostgreSQL insights: does it use DMA?

2011-09-09 Thread Scott Marlowe
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

Re: [PERFORM] PostgreSQL insights: does it use DMA?

2011-09-09 Thread Antonio Rodriges
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

Re: [PERFORM] PostgreSQL insights: does it use DMA?

2011-09-09 Thread pasman pasmaƄski
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

Re: [PERFORM] PostgreSQL insights: does it use DMA?

2011-09-09 Thread Kevin Grittner
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

Re: [PERFORM] PostgreSQL insights: does it use DMA?

2011-09-09 Thread Craig Ringer
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