Postgres Pro
Downloads
Home   >   mailing lists

pg_freespacemap question - Mailing list pgsql-hackers

From Tatsuo Ishii
Subject pg_freespacemap question
Date
Msg-id 20060307.230956.50341924.t-ishii@sraoss.co.jp
Whole thread Raw
Responses Re: pg_freespacemap question  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Coverity Open Source Defect Scan of PostgreSQL
Next
From: Peter Eisentraut
Date:
Subject: Re: pg_freespacemap question