| From: | Tatsuo Ishii <ishii(at)sraoss(dot)co(dot)jp> |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | pg_freespacemap question |
| Date: | 2006-03-07 14:09:56 |
| Message-ID: | 20060307.230956.50341924.t-ishii@sraoss.co.jp |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-patches |
Hi,
I tried pg_freespacemap and found strange result:
test=# select * from pg_freespacemap where blockfreebytes = 0;
blockid | relfilenode | reltablespace | reldatabase | relblocknumber | blockfreebytes
---------+-------------+---------------+-------------+----------------+----------------
25 | 2619 | 1663 | 16403 | 0 | 0
63 | 2619 | 1663 | 16384 | 10 | 0
(2 rows)
Is it possible that a free space map entry has 0 blockfreebytes?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2006-03-07 14:29:58 | Re: pg_freespacemap question |
| Previous Message | Alvaro Herrera | 2006-03-07 13:28:30 | Re: Coverity Open Source Defect Scan of PostgreSQL |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2006-03-07 14:29:58 | Re: pg_freespacemap question |
| Previous Message | Hans-Jürgen Schönig | 2006-03-07 10:41:52 | Re: CREATE SYNONYM ... |