Re: Default fill factor for tables?

From: Chris <dmagick(at)gmail(dot)com>
To: "Roberts, Jon" <Jon(dot)Roberts(at)asurion(dot)com>
Cc: Pgsql General list <pgsql-general(at)postgresql(dot)org>
Subject: Re: Default fill factor for tables?
Date: 2008-07-17 03:20:11
Message-ID: 487EBA6B.90004@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> I'm using 8.3.1 on Solaris and I just tried this:
> CREATE TABLE test (a int) WITH (hot_update='true');
>
> It fails with:
> ERROR: unrecognized parameter "hot_update"
>
> Is a hot update automatic in 8.3.x and that is why there isn't any
> formal documentation other than what is in the source code?

It's always on (you can't turn it off).

If you want to look at the tech side of things check out:

http://people.planetpostgresql.org/devrim/index.php?/archives/117-Looking-for-a-presentation-regarding-HOT.html

--
Postgresql & php tutorials
http://www.designmagick.com/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Pavel Stehule 2008-07-17 07:59:12 Re:
Previous Message Oleg Bartunov 2008-07-16 23:28:54 Re: [GENERAL] Fragments in tsearch2 headline