From: | Hannu Krosing <hannu(at)tm(dot)ee> |
---|---|
To: | Mark kirkwood <markir(at)slingshot(dot)co(dot)nz> |
Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Unbounded (Possibly) Database Size Increase - Test |
Date: | 2002-05-10 20:43:22 |
Message-ID: | 1021063402.1891.33.camel@rh72.home.ee |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Thu, 2002-05-09 at 14:21, Mark kirkwood wrote:
> On Wed, 2002-05-08 at 01:45, Tom Lane wrote:
>
> > Which files grew exactly? (Main table, indexes, toast table, toast index?)
>
> Here a listing (from another run - I dumped and reloaded before getting
> any of that info last time...)
>
>
> [:/data1/pgdata/7.2/base/23424803]$ du -sk .
> 4900806 .
>
> -rw------- 1 postgres dba 1073741824 May 9 21:20 23424806.3
> -rw------- 1 postgres dba 1073741824 May 9 21:19 23424806.2
> -rw------- 1 postgres dba 1073741824 May 9 21:18 23424806.1
> -rw------- 1 postgres dba 1073741824 May 9 21:16 23424806
> -rw------- 1 postgres dba 124444672 May 9 21:16 23424808
> -rw------- 1 postgres dba 587505664 May 9 21:14 23424806.4
> -rw------- 1 postgres dba 5914624 May 9 21:05 23424804
> -rw------- 1 postgres dba 2441216 May 9 21:05 23424809
>
> These files are for :
>
> grow=# select relname,oid
> grow-# from pg_class where oid in
> ('23424806','23424808','23424804','23424809'); relname |
> oid
> -----------------------+----------
> pg_toast_23424804_idx | 23424808
> pg_toast_23424804 | 23424806
> grow_pk | 23424809
> grow | 23424804
> (4 rows)
>
> so the big guy is the toast table and index
> - BTW the table design is
> CREATE TABLE grow (id integer,body text,CONSTRAINT grow_pk PRIMARY KEY
> (id))
Was it not the case that lazy vacuum had problems freeing tuples that
have toasted fields ?
> The row length is big ~ 14K. I am wondering if this behaviour will "go
> away" if I use recompile with a 32K page size (also seem to recall I can
> tell Pg not to toast certain column types)
----------
Hannu
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2002-05-10 21:24:40 | Re: internal voting |
Previous Message | Daniel H. F. e Silva | 2002-05-10 20:42:21 | Monitoring backend activities |