NotificationsYou must be signed in to change notification settings
Fork5
Star26

Commit32ad0fc

committed

Clamp last_anl_tuples to n_live_tuples, in case we vacuum a table without

analyzing, so that future analyze threshold calculations don't get confused.Also, make sure we correctly track the decrease of live tuples cause bydeletes.Per report from Dylan Hansen, patches by Tom Lane and me.

1 parentdc2c25f commit32ad0fcCopy full SHA for 32ad0fc

File tree

1 file changed

-2

lines changed

src/backend/postmaster
- pgstat.c

1 file changed

-2

lines changed

`‎src/backend/postmaster/pgstat.c`

Lines changed: 9 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -13,7 +13,7 @@`
`13`	`13`	`*`
`14`	`14`	`*Copyright (c) 2001-2006, PostgreSQL Global Development Group`
`15`	`15`	`*`
`16`		`- *$PostgreSQL: pgsql/src/backend/postmaster/pgstat.c,v 1.130 2006/06/20 22:52:00 tgl Exp $`
	`16`	`+ *$PostgreSQL: pgsql/src/backend/postmaster/pgstat.c,v 1.131 2006/06/27 03:45:16 alvherre Exp $`
`17`	`17`	`* ----------`
`18`	`18`	`*/`
`19`	`19`	`#include"postgres.h"`
`@@ -2635,7 +2635,8 @@ pgstat_recv_tabstat(PgStat_MsgTabstat *msg, int len)`
`2635`	`2635`	`tabentry->tuples_updated+=tabmsg[i].t_tuples_updated;`
`2636`	`2636`	`tabentry->tuples_deleted+=tabmsg[i].t_tuples_deleted;`
`2637`	`2637`
`2638`		`-tabentry->n_live_tuples+=tabmsg[i].t_tuples_inserted;`
	`2638`	`+tabentry->n_live_tuples+=tabmsg[i].t_tuples_inserted-`
	`2639`	`+tabmsg[i].t_tuples_deleted;`
`2639`	`2640`	`tabentry->n_dead_tuples+=tabmsg[i].t_tuples_updated+`
`2640`	`2641`	`tabmsg[i].t_tuples_deleted;`
`2641`	`2642`
`@@ -2830,6 +2831,12 @@ pgstat_recv_vacuum(PgStat_MsgVacuum *msg, int len)`
`2830`	`2831`	`else`
`2831`	`2832`	`tabentry->analyze_timestamp=msg->m_vacuumtime;`
`2832`	`2833`	`}`
	`2834`	`+else`
	`2835`	`+{`
	`2836`	`+/* last_anl_tuples must never exceed n_live_tuples */`
	`2837`	`+tabentry->last_anl_tuples=Min(tabentry->last_anl_tuples,`
	`2838`	`+msg->m_tuples);`
	`2839`	`+}`
`2833`	`2840`	`}`
`2834`	`2841`
`2835`	`2842`	`/* ----------`

0 commit comments

Comments

(0)

Movatterモバイル変換

Navigation Menu

Search code, repositories, users, issues, pull requests...

Provide feedback

Saved searches

Use saved searches to filter your results more quickly

Uh oh!

Commit32ad0fc

File tree

1 file changed

1 file changed

`‎src/backend/postmaster/pgstat.c`

0 commit comments