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

There is some information on www.varlena.com I think it may have been Scott
who wrote the article that I'm thinking about. There is other information
about, your best bet may be google.

Regards
Iain
----- Original Message -----
From: "C. Bensend" <benny(at)bennyvision(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Sent: Friday, June 18, 2004 12:57 AM
Subject: Re: [ADMIN] VARCHAR -vs- CHAR: huge performance difference?

>
> > 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"
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: don't forget to increase your free space map settings