Re: VARCHAR -vs- CHAR: huge performance difference? - Mailing list pgsql-admin

From C. Bensend
Subject Re: VARCHAR -vs- CHAR: huge performance difference?
Date
Msg-id 1854.134.244.169.17.1087487894.squirrel@webmail.stinkweasel.net
Whole thread Raw
In response to Re: VARCHAR -vs- CHAR: huge performance difference?  ("Scott Marlowe" <smarlowe@qwest.net>)
Responses Re: VARCHAR -vs- CHAR: huge performance difference?
List pgsql-admin
> 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"

pgsql-admin by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: VARCHAR -vs- CHAR: huge performance difference?
Next
From: "Lee Wu"
Date:
Subject: pg_restore patch