Re: Are there performance advantages in storing bulky field in separate table? - Mailing list pgsql-general

From Sam Mason
Subject Re: Are there performance advantages in storing bulky field in separate table?
Date
Msg-id 20090408163902.GJ12225@frubble.xen.chris-lamb.co.uk
Whole thread Raw
In response to Re: Are there performance advantages in storing bulky field in separate table?  (Ian Mayo <ianmayo@tesco.net>)
Responses Re: Are there performance advantages in storing bulky field in separate table?
Re: Are there performance advantages in storing bulky field in separate table?
List pgsql-general
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/

pgsql-general by date:

Previous
From: Jennifer Trey
Date:
Subject: Re: Now I am back, next thing. Final PGS tuning.
Next
From: David Wilson
Date:
Subject: Re: Now I am back, next thing. Final PGS tuning.