| From: | ncm(at)zembu(dot)com (Nathan Myers) |
|---|---|
| To: | pgsql-hackers(at)postgreSQL(dot)org |
| Subject: | storage density |
| Date: | 2001-05-18 08:19:22 |
| Message-ID: | 20010518011922.B424@store.zembu.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
When organizing available free storage for re-use, we will probably have
a choice whether to favor using space in (mostly-) empty blocks, or in
mostly-full blocks. Empty and mostly-empty blocks are quicker -- you
can put lots of rows in them before they fill up and you have to choose
another. Preferring mostly-full blocks improves active-storage and
cache density because a table tends to occupy fewer total blocks.
Does anybody know of papers that analyze the tradeoffs involved?
Nathan Myers
ncm(at)zembu(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Zeugswetter Andreas SB | 2001-05-18 10:13:55 | AW: Plans for solving the VACUUM problem |
| Previous Message | Tom Lane | 2001-05-18 07:18:56 | Re: Re: Plans for solving the VACUUM problem |