new full vacuum doesn't work

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: new full vacuum doesn't work
Date: 2010-01-08 09:35:03
Message-ID: 162867791001080135g9dc4e7dtae4d562c441efc63@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello

I am testing vacuum changes, and I found some strange behave:

autovacuum off

[pavel(at)nemesis src]$ /usr/local/pgsql/bin/pgbench -i -F 10 -s 10 test
NOTICE: table "pgbench_branches" does not exist, skipping
NOTICE: table "pgbench_tellers" does not exist, skipping
NOTICE: table "pgbench_accounts" does not exist, skipping
NOTICE: table "pgbench_history" does not exist, skipping

test=# \dt+
List of relations
Schema | Name | Type | Owner | Size | Description
--------+------------------+-------+-------+------------+-------------
public | pgbench_accounts | table | pavel | 1302 MB |
public | pgbench_branches | table | pavel | 8192 bytes |
public | pgbench_history | table | pavel | 0 bytes |
public | pgbench_tellers | table | pavel | 48 kB |
(4 rows)

test=# \x
Expanded display is on.
test=# select * from pgstattuple('pgbench_accounts');
-[ RECORD 1 ]------+-----------
table_len | 1365336064
tuple_count | 1000000
tuple_len | 121000000
tuple_percent | 8.86
dead_tuple_count | 0
dead_tuple_len | 0
dead_tuple_percent | 0
free_space | 1228669388
free_percent | 89.99

test=# vacuum full pgbench_accounts;
VACUUM

test=# \dt+
List of relations
Schema | Name | Type | Owner | Size | Description
--------+------------------+-------+-------+------------+-------------
public | pgbench_accounts | table | pavel | 1302 MB |
public | pgbench_branches | table | pavel | 8192 bytes |
public | pgbench_history | table | pavel | 0 bytes |
public | pgbench_tellers | table | pavel | 48 kB |
(4 rows)

test=# select * from pgstattuple('pgbench_accounts');
-[ RECORD 1 ]------+-----------
table_len | 1365336064
tuple_count | 1000000
tuple_len | 128000000
tuple_percent | 9.37
dead_tuple_count | 0
dead_tuple_len | 0
dead_tuple_percent | 0
free_space | 1228669388
free_percent | 89.99

Regards
Pavel

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Dave Page 2010-01-08 09:35:40 Re: RFC: PostgreSQL Add-On Network
Previous Message Dimitri Fontaine 2010-01-08 09:25:25 Re: damage control mode