"PFC" <[EMAIL PROTECTED]> writes: > I have this "poll results" table with just 3 integer fields, which is > never updated, only inserted/deleted... > Did the Devs consider an option to have VACUUM reduce the row header > sizes for tuples that are long commited and are currently visible to all > transactions ? (even if this makes the tuples non-updateable, as long as they > can be deleted, it would be OK for this type of tables).
It wouldn't actually speed up anything unless the space it frees up was then used by something. That would mean loading one of your polls into the small bits of space freed up in every page. For most tables like this you want to do large bulk loads and want your loads stored quickly in contiguous space so it can be accessed quickly, not spread throughout the table. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
