| From: | Mark Kirkwood <markir(at)paradise(dot)net(dot)nz> |
|---|---|
| To: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
| Cc: | tgl(at)sss(dot)pgh(dot)pa(dot)us, alvherre(at)commandprompt(dot)com, peter_e(at)gmx(dot)net, pgsql-hackers(at)postgresql(dot)org, pgsql-patches(at)postgresql(dot)org |
| Subject: | Re: [PATCHES] pg_freespacemap question |
| Date: | 2006-03-12 22:48:33 |
| Message-ID: | 4414A541.1080909@paradise.net.nz |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-13 00:43:11 | Re: [PATCHES] pg_freespacemap question |
| Previous Message | Josh Berkus | 2006-03-12 19:08:16 | Re: PostgreSQL Anniversary Summit, Call for |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2006-03-13 00:43:11 | Re: [PATCHES] pg_freespacemap question |
| Previous Message | Volkan YAZICI | 2006-03-12 17:59:10 | Re: psql patch: new host/port without leaving session |