From: | Jan Wieck <janwieck(at)yahoo(dot)com> |
---|---|
To: | "Jeffrey W(dot) Baker" <jwbaker(at)acm(dot)org> |
Cc: | Postgres general mailing list <pgsql-general(at)postgresql(dot)org>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Subject: | Re: more about pg_toast growth |
Date: | 2002-04-09 20:45:34 |
Message-ID: | 200204092045.g39KjYi02600@saturn.janwieck.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Jeffrey W. Baker wrote:
> On Tue, 2002-04-09 at 11:52, Jan Wieck wrote:
> > I still believe it's due to the massive amount of data pumped
> > through that table between vacuums and inappropriate settings
> > for the freespace map size for this particular case.
> >
> > Initially I suggested an FSM size of 50,000 "to start with".
> > That was meant as an introduction to play around with these
> > parameters a little, figuring out what the right settings are
> > in his case, and reporting back the result. What we got back
> > after a week or longer, was a lax "still doesn't work". It
> > seemed to me he had not spent alot of time to understand the
> > underlying concepts, nor has he ever taken a single look at
> > the code.
>
> I don't need this abuse. I'm perfectly capable of reading the source
> code for PostgreSQL. I helped diagnose a spinlock contention problem in
> the 7.2beta series and I maintain DBD::Pg. And I've contributed source
> code to several other projects which I need not list here.
Abuse of what?
I did not mean to offend you in any way. Maybe I wasn't
carefull enough in choosing my words, maybe you missed the
smiley in my earlier posting (that about doing a little
math), maybe whatever.
Anyway, seems we don't get along well enough to work
together. Thus, it's better you help someone else to
diagnose your problem. Good luck.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck(at)Yahoo(dot)com #
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2002-04-09 20:48:30 | Re: Cannot execute null query |
Previous Message | Ed Loehr | 2002-04-09 20:32:07 | Re: Hash Join vs Nested Loops in 7.2.1 ... |