On Sat, Jun 18, 2011 at 6:12 PM, Dave Thompson <dthomp...@gmail.com> wrote: > Hi, > > I have a table that will be updated frequently. Each row will be > updated at least once during it's lifetime, and most rows will be > updated ~10 times in their first 2 weeks of existence, and then > relatively rarely after that. The rows are being updated by a prepared > statement that gets executed with ~100 - ~600 different parameter > sets, each one updating a single row. What should my initial > best-guess fill-factor for the table be? Most of the updates don't > touch an indexed column, so I'm hoping to take advantage of the HOT > update feature. Will EXPLAIN tell me if an UPDATE uses HOT?
No but you can monitor pg_stat_user_tables to see how many updates were HOT updates. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
