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: (view raw or whole 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-2015 The PostgreSQL Global Development Group