Re: Open 7.3 items
От | Bruce Momjian |
---|---|
Тема | Re: Open 7.3 items |
Дата | |
Msg-id | 200207311930.g6VJUUR07783@candle.pha.pa.us обсуждение исходный текст |
Ответ на | Re: Open 7.3 items (Tom Lane <tgl@sss.pgh.pa.us>) |
Ответы |
Re: Open 7.3 items
Re: Open 7.3 items |
Список | pgsql-hackers |
Tom Lane wrote: > > NAMEDATALEN - disk/performance penalty for increase, 64, 128? > > FUNC_MAX_ARGS - disk/performance penalty for increase, 24, 32? > > At the moment I don't see a lot of solid evidence that increasing > NAMEDATALEN has any performance penalty. Someone reported about > a 10% slowdown on pgbench with NAMEDATALEN=128 ... but Neil Conway > tried to reproduce the result, and got about a 10% *speedup*. > Personally I think 10% is well within the noise spectrum for > pgbench, and so it's difficult to claim that we have established > any performance difference at all. I have not tried to measure > FUNC_MAX_ARGS differences. Yes, we need someone to benchmark both the NAMEDATALEN and FUNC_MAX_ARGS to prove we are not causing performance problems. Once that is done, the default limits can be easily increased. I was thinking 64 for NAMEDATALEN and 32 for FUNC_MAX_ARGS, effectively doubling both. -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania19026
В списке pgsql-hackers по дате отправления: