Re: [GENERAL] explain analyze buffer

2011-04-27 Thread Rob Sargent
On 04/27/2011 12:45 PM, SUBHAM ROY wrote: I am using postgres 8.4.8. |EXPLAIN (ANALYZE,BUFFERS)| is not working. So is there any patch available for it? If so, kindly specify from where to get it and how to install it. -- Thank You, Subham Roy, CSE IIT Bombay. Have you tried just plain exp

Re: [GENERAL] explain analyze buffer

2011-04-27 Thread Magnus Hagander
On Wed, Apr 27, 2011 at 20:45, SUBHAM ROY wrote: > I am using postgres 8.4.8. > EXPLAIN (ANALYZE,BUFFERS) is not working. So is there any patch available > for it? If so, kindly specify from where to get it and how to install it. This functionality is new in PostgreSQL 9.0. You need to upgrade to

[GENERAL] explain analyze buffer

2011-04-27 Thread SUBHAM ROY
I am using postgres 8.4.8. EXPLAIN (ANALYZE,BUFFERS) is not working. So is there any patch available for it? If so, kindly specify from where to get it and how to install it. -- Thank You, Subham Roy, CSE IIT Bombay.