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

From: "C(dot) Bensend" <benny(at)bennyvision(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: VARCHAR -vs- CHAR: huge performance difference?
Date: 2004-06-16 14:37:58
Message-ID: 1185.134.244.169.17.1087396700.squirrel@webmail.stinkweasel.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> You might want to look into the autovacuum daemon, and / or increasing
> fsm settings to be large enough to hold all the spare tuples released by
> vacuuming.

IIRC, the autovacuum stuff was added in 7.4, which I'm not running (yet).
An upgrade to 7.4.3 might be prudent for me, while the database is still
small.

Benny

--
"Oh, the Jedis are going to feel this one!" -- Professor Farnsworth,
"Futurama"

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Rajesh Kumar Mallah 2004-06-16 15:00:38 Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.
Previous Message Tom Lane 2004-06-16 13:55:09 Re: weired behavior... after pg_resetxlog-> dump->initdb-->reload.