pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Iain <iain@mst.co.jp>
To: C. Bensend <benny@bennyvision.com>
To: pgsql-admin@postgresql.org
Subject: Re: VARCHAR -vs- CHAR: huge performance difference?
Date: Wed, 16 Jun 2004 13:56:11 +0900
Message-ID: <009601c4535e$3e8d10c0$7201a8c0@mst1x5r347kymb> (raw)
References: <51429.63.227.74.41.1087347504.squirrel@webmail.stinkweasel.net>
	<15549.1087351669@sss.pgh.pa.us>
	<50124.63.227.74.41.1087351971.squirrel@webmail.stinkweasel.net>
	<15996.1087354312@sss.pgh.pa.us>
	<58063.63.227.74.41.1087355391.squirrel@webmail.stinkweasel.net>


> Or do I just need to vacuum more often?  I _did_ try a vacuum before
> asking the list for help, but it didn't give any improvement (just a
> vacuum analyze).

"vacuum analyse" allows dead space to be re-used, but doesn't compact the
table, you need "vacuum analyse full" for that.

I'm not sure how the free space map relates to this, maybe someone can shed
some light, but if it is too small, not all dead rows can be re-used (as I
understand it). If your table (or even the DB in general) is updated alot,
the default FSM size that comes with 7.3 may not be enough to ensure the
most efficient space reclamation. Last time I looked the docs were a little
hazy on that.




view thread (18+ messages)  latest in thread

Message-ID: <009601c4535e$3e8d10c0$7201a8c0@mst1x5r347kymb>
Permalink:  ../009601c4535e$3e8d10c0$7201a8c0@mst1x5r347kymb/
Also on:    postgresql.org/message-id/009601c4535e$3e8d10c0$7201a8c0@mst1x5r347kymb

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-admin@postgresql.org
  Cc: iain@mst.co.jp, benny@bennyvision.com
  Subject: Re: VARCHAR -vs- CHAR: huge performance difference?
  In-Reply-To: <009601c4535e$3e8d10c0$7201a8c0@mst1x5r347kymb>
  References: <51429.63.227.74.41.1087347504.squirrel@webmail.stinkweasel.net> <15549.1087351669@sss.pgh.pa.us> <50124.63.227.74.41.1087351971.squirrel@webmail.stinkweasel.net> <15996.1087354312@sss.pgh.pa.us> <58063.63.227.74.41.1087355391.squirrel@webmail.stinkweasel.net> <009601c4535e$3e8d10c0$7201a8c0@mst1x5r347kymb>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox