overhead for stats_row_level

Started by AI Rummanabout 16 years ago2 messagesgeneral
Jump to latest
#1AI Rumman
rummandba@gmail.com

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.

#2John R Pierce
pierce@hogranch.com
In reply to: AI Rumman (#1)
Re: overhead for stats_row_level

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.