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 whole thread)
Lists: pgsql-admin
There is some information on 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.

----- 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-2015 The PostgreSQL Global Development Group