Tatsuo Ishii wrote:
BTW, I noticed difference of outputs from pg_freespacemap and pgstattuple.I ran pgbench and inspected "accounts" table by using these tools. pg_freespacemap: sum of bytes: 250712 pgstattuple: free_space: 354880 Shouldn't they be identical?
I would have thought so - unless there are not enough pages left in the FSM...
pg_freespacemap is reporting on what gets into the FSM - so provided I haven't put a bug in there somewhere (!) - we need to look at how VACUUM reports free space to the FSM....
cheers Mark ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
