Re: [PERFORM] How can retrieve total query run-time with out using explain

2011-07-03 Thread Craig Ringer
On 3/07/2011 12:13 PM, Radhya sahal wrote: Dear all, How can retrieve total query run-time when i run any query with out using explain EXPLAIN doesn't tell you the query runtime. EXPLAIN ANALYZE does, but it doesn't return the query results, returning plan and timing information instead.

Re: [PERFORM] Infinite Cache

2011-07-03 Thread Magnus Hagander
On Sat, Jul 2, 2011 at 00:37, Jim Nasby j...@nasby.net wrote: On Jul 1, 2011, at 9:43 AM, Anthony Presley wrote: Was curious if there was some sort of Open Source version of Infinite Cache, and/or a memcache layer that can be dropped in front of PostgreSQL without application changes (which

Re: [PERFORM] Infinite Cache

2011-07-03 Thread Greg Smith
On 07/01/2011 06:37 PM, Jim Nasby wrote: BTW, thanks to the compression feature of IC I've heard it can actually be beneficial to run it on the same server. Sure, its implementation works in a way that helps improve performance on the database server. My point was that I'd be shocked if it