Josh Berkus wrote:
Shane Ambler wrote:
Mark Mielke wrote:
Not that I disagree with your change, but < 5 Mbytes in 4 Gbytes of
RAM for my main PostgreSQL system that I manage seems like a drop in
the bucket. Even if 40% of pg_class_relname and pg_proc_proname
indices was saved - we're talking about 154 Kbytes saved on both
those indices combined. Minor? Major? I bet I wouldn't notice unless
my database requirements used up all RAM, and even then I'm
suspecting it wouldn't matter except for border line cases (like all
pages required for everything else happened to equal 4 Gbytes near
exactly).
Guess the mileage will vary depending on the complexity of the db
structure. Shorter names will also benefit more than longer ones.
There are PostgreSQL users out there with more than 100,000 tables per
server instance. This will make more of a difference to them.
More than I think people realize.
Joshua D. Drake
--Josh
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
