Hello
I am testing vacuum changes, and I found some strange behave:
autovacuum off
[pa...@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
Pavel Stehule pavel.steh...@gmail.com wrote:
I am testing vacuum changes, and I found some strange behave:
Did you need SET (fillfactor=100) before vACUUM FULL?
=# select * from pgstattuple('pgbench_accounts');
-[ RECORD 1 ]--+---
table_len | 1365336064
tuple_count
2010/1/8 Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp:
Pavel Stehule pavel.steh...@gmail.com wrote:
I am testing vacuum changes, and I found some strange behave:
Did you need SET (fillfactor=100) before vACUUM FULL?
no, I tested it and with FILLFACTOR 100 VACUUM FULL is successful.
Pavel Stehule pavel.steh...@gmail.com wrote:
Personally I thing, so this behave is bad. Or there is wrong default
fillfactor 0.
No, you used fillfactor=10 here:
[pa...@nemesis src]$ /usr/local/pgsql/bin/pgbench -i -F 10 -s 10 test
~
2010/1/8 Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp:
Pavel Stehule pavel.steh...@gmail.com wrote:
Personally I thing, so this behave is bad. Or there is wrong default
fillfactor 0.
No, you used fillfactor=10 here:
[pa...@nemesis src]$ /usr/local/pgsql/bin/pgbench -i -F 10 -s 10 test