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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-general by date

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