|
8 | 8 | * |
9 | 9 | * |
10 | 10 | * IDENTIFICATION |
11 | | - * $PostgreSQL: pgsql/src/backend/tcop/postgres.c,v 1.437 2004/11/14 19:35:31 tgl Exp $ |
| 11 | + * $PostgreSQL: pgsql/src/backend/tcop/postgres.c,v 1.438 2004/11/20 00:48:58 tgl Exp $ |
12 | 12 | * |
13 | 13 | * NOTES |
14 | 14 | * this is the "main" module of the postgres backend and |
@@ -2904,19 +2904,20 @@ PostgresMain(int argc, char *argv[], const char *username) |
2904 | 2904 | * This is also a good time to send collected statistics to the |
2905 | 2905 | * collector, and to update the PS stats display. We avoid doing |
2906 | 2906 | * those every time through the message loop because it'd slow |
2907 | | - * down processing of batched messages. |
| 2907 | + * down processing of batched messages, and because we don't want |
| 2908 | + * to report uncommitted updates (that confuses autovacuum). |
2908 | 2909 | */ |
2909 | 2910 | if (send_rfq) |
2910 | 2911 | { |
2911 | | -pgstat_report_tabstat(); |
2912 | | - |
2913 | 2912 | if (IsTransactionOrTransactionBlock()) |
2914 | 2913 | { |
2915 | 2914 | set_ps_display("idle in transaction"); |
2916 | 2915 | pgstat_report_activity("<IDLE> in transaction"); |
2917 | 2916 | } |
2918 | 2917 | else |
2919 | 2918 | { |
| 2919 | +pgstat_report_tabstat(); |
| 2920 | + |
2920 | 2921 | set_ps_display("idle"); |
2921 | 2922 | pgstat_report_activity("<IDLE>"); |
2922 | 2923 | } |
|