Re: Dept of ugly hacks: eliminating padding space in system indexes - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Dept of ugly hacks: eliminating padding space in system indexes
Date
Msg-id 1214259609.9468.791.camel@ebony.site
Whole thread Raw
In response to Dept of ugly hacks: eliminating padding space in system indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Dept of ugly hacks: eliminating padding space in system indexes  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
On Mon, 2008-06-23 at 15:52 -0400, Tom Lane wrote:
>                             CVS HEAD    w/patch    savings
> 
> pg_database_size('postgres')                4439752    4071112    8.3%
> pg_relation_size('pg_class_relname_nsp_index')        57344    40960    28%
> pg_relation_size('pg_proc_proname_args_nsp_index')  319488    204800    35%
> 
> Cutting a third off the size of a system index has got to be worth
> something, but is it worth a hack as ugly as this one?

Not doing it would be more ugly, unless there is some negative
side-effect?

-- Simon Riggs           www.2ndQuadrant.comPostgreSQL Training, Services and Support



pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: count(*) performance improvement ideas
Next
From: Bruce Momjian
Date:
Subject: Re: Lessons from commit fest