Heap Only Update - Mailing list pgsql-admin

From Ali Mumcu
Subject Heap Only Update
Date
Msg-id CAByegeLBV=bLHy9jV0whnU=qSmVsqTCp0yp23FPqPHCDcaeZWA@mail.gmail.com
Whole thread Raw
Responses Re: Heap Only Update
List pgsql-admin
Hello Friends,
I am trying to find tables which Heap only update ratio less then 1 . Then i will decrease fillfactor on these tables  for more speedly update queries.


I am using this query to find hot ratio. For you , this method true or false ?

select relname  from pg_stat_user_tables where  n_tup_upd>0 and n_tup_hot_upd > 0 and n_tup_hot_upd/n_tup_upd::float < 1;


Thanks .
Best Regards.

pgsql-admin by date:

Previous
From: Rajesh Ramachandran
Date:
Subject: remove from list
Next
From: Ben Primrose
Date:
Subject: Re: Issue on restore / recover