Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0

From: tim_wilson <tim(dot)wilson(at)telogis(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
Date: 2014-05-19 03:56:16
Message-ID: 1400471776246-5804424.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Just to add a little more detail about my busy_table
1) there are no rows deleted
2) 98% of updates are HOT
3) there are two DB's on this postgres instance both with the same table,
both seeing the same issue

--
View this message in context: http://postgresql.1045698.n5.nabble.com/autovacuum-vacuum-creates-bad-statistics-for-planner-when-it-log-index-scans-0-tp5804416p5804424.html
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Geoff Hull 2014-05-19 04:47:14 View has different query plan than select statement
Previous Message tim_wilson 2014-05-19 00:35:29 autovacuum vacuum creates bad statistics for planner when it log index scans: 0