Two question about performance tuning issue.

From: "Kangmo, Kim" <ilvsusie(at)hahafos(dot)com>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Two question about performance tuning issue.
Date: 2002-07-25 18:43:30
Message-ID: 005b01c2340b$2bd06f00$c601a8c0@wildcat
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi, I'm a newbie to postgresql, and I have 2 questions.

1. shared memory hash key is string.
why don't we use predefined integer value?
I think it is dangerous to use string for key value,
because it can be mistyped , which might lead us to debug more and more.

2. appendStringInfoChar reallocates every bytes whenever needed,
why don't reallocate chunk for better performace?
because initStringInfo allocates only 256 bytes ,
pg_beginmessage prepared 256 bytes of StringInfo for communication buffer.

It's hard to analyze pgsql source code,
because I'm a newbie, and have no idea about postgres internals,
But I will try hard!!

Thank you.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Marc Lavergne 2002-07-25 18:56:45 Re: Oracle Decode Function
Previous Message Hannu Krosing 2002-07-25 18:17:56 creating aggregates that work on composite types (whole tuples)