Wednesday, July 16, 2008

Re: [GENERAL] Default fill factor for tables?

> 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/

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

No comments: