Re: Small reduction in memory usage of index relcache entries

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heikki Linnakangas <hlinnakangas(at)vmware(dot)com>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Small reduction in memory usage of index relcache entries
Date: 2013-04-12 23:38:16
Message-ID: 13923.1365809896@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Heikki Linnakangas <hlinnakangas(at)vmware(dot)com> writes:
> Looking closer at where that memory is spent, a lot of it goes into the
> FmgrInfo structs in RelationAmInfo. But some of them are outright unused
> (ambuild, ambuildempty, amcostestimate, amoptions), and a few others
> hardly are called so seldom that they hardly need to be cached
> (ambuildelete, ambacuumcleanup). Removing those fields, patch attached,
> reduces the memory usage nicely:

+1, but it would look nicer if you could encapsulate the code in some
macro analogous to GET_REL_PROCEDURE(), perhaps call it
GET_UNCACHED_REL_PROCEDURE()?

regards, tom lane

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Stephen Frost 2013-04-13 03:06:19 Re: Hash Join cost estimates
Previous Message Ants Aasma 2013-04-12 22:21:44 Re: Enabling Checksums