A question about pages. Still not clear

From: tmorelli(at)tmorelli(dot)com(dot)br
To: pgsql-novice(at)postgresql(dot)org
Subject: A question about pages. Still not clear
Date: 2006-01-12 12:27:58
Message-ID: 20060112122758.C593EB7EA8@smtpi03.infolink.com.br
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Tom,

I've done more tests. After re-creating a table with just one field
(char(8000)), I inserted 26 records. Look at this:

teste=# select relname, oid, relpages, reltuples from pg_class where oid >=
169982690;
relname | oid | relpages | reltuples
--------------------------+-----------+----------+-----------
pg_toast_169982690_index | 169982694 | 1 | 0
pg_toast_169982690 | 169982692 | 0 | 0
ix | 169982695 | 2 | 26
t | 169982690 | 1 | 26
(4 rows)

Every insert was like this:

insert into t values (repeat('a',8000));

Obviously, there must be some kind of compression (the toast table is empty!).
The main question is:

Is there any way of knowing exactly WHEN there will be a new page allocation?
Is it configurable? How could I inspect compression stuff?

VACUUM FULL VERBOSE did not make any difference.

And, finally, what does it mean: "contrib/pgstattuple/ " (from your last answer)

Best regards,

Eduardo Morelli

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message mushroom2 2006-01-12 13:37:46 trigger / to_char()-function / extract()-function
Previous Message Brendan Duddridge 2006-01-12 04:50:07 Re: Comparing databases