Re: VARCHAR -vs- CHAR: huge performance difference?

From: "C(dot) Bensend" <benny(at)bennyvision(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: VARCHAR -vs- CHAR: huge performance difference?
Date: 2004-06-17 15:57:52
Message-ID: 1854.134.244.169.17.1087487894.squirrel@webmail.stinkweasel.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> The problem here isn't pg_autovacuum, but too small of settings for
> fsm. I've run multi-day tests where autovacuum kept the size of the
> database pretty much the same with 200+ updates a second going on.

Hi Scott,

Could you explain the fsm a little more? I have done _no_ tuning on
my database simply because I don't know how, but I would be interested
to hear your recommendations for the fsm settings.

Thanks!

Benny

--
"Oh, the Jedis are going to feel this one!" -- Professor Farnsworth,
"Futurama"

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Lee Wu 2004-06-17 20:46:33 pg_restore patch
Previous Message Scott Marlowe 2004-06-17 15:37:36 Re: VARCHAR -vs- CHAR: huge performance difference?