Skip site navigation (1) Skip section navigation (2)

Re: Needs Suggestion

From: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
To: SUBHAM ROY <subham(dot)iem(at)gmail(dot)com>
Cc: Magnus Hagander <magnus(at)hagander(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: Needs Suggestion
Date: 2011-05-02 23:26:22
Message-ID: 4DBF3D9E.3050002@postnewspapers.com.au (view raw or flat)
Thread:
Lists: pgsql-general
On 04/28/2011 02:11 AM, SUBHAM ROY wrote:
> I am using postgres 8.4.8, the above command explain(analyze,buffers) is
> not working. Is there a way to do that.

Nope, the (BUFFERS) syntax was added in 9.0. Try the other suggestions 
about using table stats to determine what you want to know.

--
Craig Ringer


In response to

pgsql-general by date

Next:From: Jeff DavisDate: 2011-05-03 00:25:10
Subject: Re: pervasiveness of surrogate (also called synthetic) keys
Previous:From: Scott MarloweDate: 2011-05-02 20:28:58
Subject: Re: wnat ot edit pg_hba.conf file from command prompt

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group