| From: | veejar <veejar(dot)net(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | LargeObjects Total Size |
| Date: | 2007-01-04 13:47:37 |
| Message-ID: | a4c4d7e50701040547m57aa9fb9r690bdd86c7e70d3a@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
My pg_largeobject table filenode is 16404:
(select relfilenode from pg_class where relname='pg_largeobject')
Pages (record) count in table pg_largeobject: 73574 -> 144 MB (73574 * 2Kb)
(select count(loid) from pg_largeobject)
Relation pages count (in table pg_class) for table pg_largeobject:
23713 -> 185 MB (23713 * 8 Kb)
(select relpages from pg_class where relname='pg_largeobject')
Total:
144 MB - data in table pg_largeobject
186 MB - size on disk for table pg_largeobject
Question:
185 MB - 144MB = 41 MB - what is in this memory on disk?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | henry akagbusi | 2007-01-04 13:57:03 | I will hold your copy for 24 hours |
| Previous Message | Martijn van Oosterhout | 2007-01-04 12:07:53 | Re: Tabbed data in tab-separated output |