Skip site navigation (1) Skip section navigation (2)

Re: namedatalen part 2 (cont'd)

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: Neil Conway <nconway(at)klamath(dot)dyndns(dot)org>,Rod Taylor <rbt(at)zort(dot)ca>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: namedatalen part 2 (cont'd)
Date: 2002-04-24 14:20:50
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-hackers
Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> Yes, 64 looked like the appropriate value too.  Actually, I was
> surprised to see as much of a slowdown as we did.

I was too.  pgbench runs the same backend(s) throughout the test,
so it shouldn't be paying anything meaningful in disk I/O for the
larger catalog size.  After the first set of queries all the relevant
catalog rows will be cached in syscache.  So where's the performance
hit coming from?

It'd be interesting to redo these runs with profiling turned on
and compare the profiles at, say, 32 and 512 to see where the time
is going for larger NAMEDATALEN.  Might be something that's easy
to fix once we identify it.

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Thomas LockhartDate: 2002-04-24 14:23:27
Subject: Re: Vote on SET in aborted transaction
Previous:From: Bruce MomjianDate: 2002-04-24 14:08:49
Subject: Re: Sequential Scan Read-Ahead

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group