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@bennyvision.com>
To: <pgsql-admin@postgresql.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