Re: overhead for stats_row_level

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: overhead for stats_row_level
Date: 2010-02-08 06:33:58
Message-ID: 4B6FB056.6030808@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

AI Rumman wrote:
> Could any one please tell me what the overhead will be on the database
> server and instance if I set
> stats_row_level = on
> at Postgesql 8.1.

4.3% !

seriously, though, that would be very hard to quantify for a random set
of operations, and would be heavily dependent on what you're doing.
you probably should test your app with it off and on to see what the
overhead is for you.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Ma, Dong (Vincent@BAS-BECOM-BJ) 2010-02-08 08:18:07 Problem about export/import postgresql tables use pg_dump/pg_restore
Previous Message AI Rumman 2010-02-08 06:21:50 overhead for stats_row_level