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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Adam Smith | 2004-06-21 02:50:53 | Is this a "Stupid Question" ? |
Previous Message | Reto | 2004-06-20 22:38:23 | Re: Database Schemas generator |