Hello,

I am using Ubuntu 9.10 Server and I have Postgres 8.4 in it. I set my server to automatically install updates. After updating, I observed my Postgres eats a lot of memory. When I look at the PG Logs, one file almost has the size of 2G. When I open the file I got the below contents:

2010-01-12 14:18:49 PHT STATEMENT: SELECT attnotnull FROM pg_catalog.pg_attribute WHERE attrelid = $1 AND attnum = $2
2010-01-12 14:18:49 PHT LOG: EXECUTOR STATISTICS
2010-01-12 14:18:49 PHT DETAIL: ! system usage stats:
! 0.000014 elapsed 0.000000 user 0.000000 system sec
! [205.584848 user 4.132258 sys total]
! 0/0 [16/133736] filesystem blocks in/out
! 0/0 [0/4000] page faults/reclaims, 0 [0] swaps
! 0 [0] signals rcvd, 0/0 [0/0] messages rcvd/sent
! 0/0 [93445/12926] voluntary/involuntary context switches
! buffer usage stats:
! Shared blocks: 0 read, 0 written, buffer hit rate = 100.00%
! Local blocks: 0 read, 0 written, buffer hit rate = 0.00%
! Direct blocks: 0 read, 0 written

I have not accessed Postgres recently so it should be idle. The thing that really bump me out is what process triggers postgres these events?

Any idea?
Thanks.