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

2011-07-02 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. f

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

2011-07-02 Thread Radhya sahal
Dear all, How can retrieve total query run-time  when i run any query with out using explain for example when i run any query  such  as select * from  tablel1; Total query runtime: 443 ms.  i want a function can return "runtime: 443 ms" with out using explain i want this command to call it from

Re: [PERFORM] Infinite Cache

2011-07-02 Thread Dave Page
On Fri, Jul 1, 2011 at 11:37 PM, Jim Nasby 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 see