Re: FUNC_MAX_ARGS benchmarks
Joe Conway <mail@joeconway.com>
From: Joe Conway <mail@joeconway.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Bruce Momjian <pgman@candle.pha.pa.us>, Thomas Lockhart <lockhart@fourpalms.org>, Neil Conway <nconway@klamath.dyndns.org>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2002-08-05T15:18:38Z
Lists: pgsql-hackers
Tom Lane wrote: > The bloat would scale with the size of your schema, not with the amount > of data in your tables (unless you have "name" columns in your user > tables, which is something we've always discouraged). template1 is > clearly a worst-case scenario, percentagewise, for NAMEDATALEN. > > I'm quite prepared to believe that the net cost is "a couple megs per > database" more or less independent of how much data you store. Maybe > that's negligible these days, or maybe it isn't ... Seems to me it's negligible for the vast majority of applications. I *know* it is for any appplication that I have. We can always tell people who are doing embedded application work to bump *down* NAMEDATALEN. Joe