Re: Are there performance advantages in storing bulky field in separate table?

On Wed, Apr 08, 2009 at 04:56:35PM +0100, Ian Mayo wrote:
> One more thing: hey, did you hear? I just got some advice from Tom Lane!

Statistically speaking; he's the person most likely to answer you by
quite a long way. Out of the ~24k emails going back to Oct 2007 I've
got from pgsql-general the most common people who wrote them are:

who num mails of total
Tom Lane 1,935 8.0%
Scott Marlowe 1,077 4.5%
Alvaro Herrera 521 2.2%
Joshua Drake 468 1.9%
Richard Huxton 432 1.8%
Craig Ringer 338 1.4%
Ivan Sergio Borgonovo 314 1.3%
Sam Mason 310 1.3%
Raymond O'Donnell 270 1.1%
Martijn van Oosterhout 264 1.1%
Greg Smith 252 1.0%

The remaining ~2000 distinct addresses were less than one percent each.

I didn't expect to see myself there; ho hum, maybe I should spend less
time on email! It's also somewhat biased as I only have archives as
long as I've posted. I just tried pulling numbers from markmail.org and
get somewhat different results. Here it knows about 161k messages and
the top twenty posters are:

Tom Lane 14,147 8.8%
Bruce Momjian 3,400 2.1%
Scott Marlowe 3,112 1.9%
Richard Huxton 2,738 1.7%
Martijn van Oosterhout 2,480 1.5%
Alvaro Herrera 1,853 1.2%
Stephan Szabo 1,783 1.1%
Joshua D. Drake 1,720 1.1%
Peter Eisentraut 1,488 0.9%
Michael Fuhr 1,328 0.8%
Bruno Wolff III 1,201 0.7%
Andrew Sullivan 985 0.6%
Doug McNaught 773 0.5%
Jan Wieck 764 0.5%
Ron Johnson 764 0.5%
Jim C. Nasby 745 0.5%
Magnus Hagander 665 0.4%
Marc G. Fournier 630 0.4%
Dennis Gearon 602 0.4%
The Hermit Hacker 601 0.4%

I've not been able to merge people where they use different email
address like with my own archive, but manually fiddled Scott Marlowe as
he appeared as "scott.marlowe" as well. I'm glad to see I drop off the
bottom now!

--
Sam http://samason.me.uk/