[HACKERS] pg_freespacemap question

[Tatsuo Ishii]

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

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend