Postgres Pro
Downloads
Home   >   mailing lists

Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0 - Mailing list pgsql-performance

From tim_wilson
Subject Re: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
Date
Msg-id 1400471776246-5804424.post@n5.nabble.com
Whole thread Raw
In response to autovacuum vacuum creates bad statistics for planner when it log index scans: 0  (tim_wilson <tim.wilson@telogis.com>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: tim_wilson
Date:
Subject: autovacuum vacuum creates bad statistics for planner when it log index scans: 0
Next
From: Geoff Hull
Date:
Subject: View has different query plan than select statement