stack usage in toast_insert_or_update()

From: "Pavan Deolasee" <pavan(dot)deolasee(at)gmail(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: stack usage in toast_insert_or_update()
Date: 2007-01-30 10:17:59
Message-ID: 2e78013d0701300217v1a303199s5195547f518007c6@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Not sure whether its worth optimizing, but had spotted this while browsing
the code a while back. So thought would post it anyways.

The stack usage for toast_insert_or_update() may run into several KBs since
the MaxHeapAttributeNumber is set to a very large value of 1600. The usage
could anywhere between 28K to 48K depending on alignment and whether its a
32-bit or a 64-bit machine.

Is it very common to have so many attributes in a table ? If not, would it
be worth
to allocate only as much space as required ?

Thanks,
Pavan

--

EnterpriseDB http://www.enterprisedb.com

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Guido Goldstein 2007-01-30 10:43:52 Re: pgsql: Fix for plpython functions; return true/false for boolean,
Previous Message Ken Johanson 2007-01-30 06:53:51 V3 protocol; way to return table aliases?