I've added one record to the table;
SELECT count(*) from bigtbl; returns 1 (< 1sec.).

Next, I've added 500.000.000 records inside a transaction and after
that, I rolled back the transaction (database file is now at 5gb).

count(*) needs now a long time (I've canceled after ~30min).

Is there a way to speed this up (automatically all night)?



Daniel

--
web: http://daniel.vogelbacher.name
irc: cytrinox @ (freenode|ircnet|quakenet)