Skip site navigation (1) Skip section navigation (2)

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

From: "Iain" <iain(at)mst(dot)co(dot)jp>
To: "C(dot) Bensend" <benny(at)bennyvision(dot)com>,<pgsql-admin(at)postgresql(dot)org>
Subject: Re: VARCHAR -vs- CHAR: huge performance difference?
Date: 2004-06-21 01:17:09
Message-ID: 012301c4572d$7a032db0$7201a8c0@mst1x5r347kymb (view raw or flat)
Thread:
Lists: pgsql-admin
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


In response to

pgsql-admin by date

Next:From: Adam SmithDate: 2004-06-21 02:50:53
Subject: Is this a "Stupid Question" ?
Previous:From: RetoDate: 2004-06-20 22:38:23
Subject: Re: Database Schemas generator

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group