I suspect there is something wrong because it takes 73s to delete a single line
from a table whith 140 lines. So I tried to reindex the database:
bash-2.05b$ postgres -P -O -D /var/lib/pgsql/data KakaoStats
LOG: database system was shut down at 2004-04-11 19:55:10 BRT
LOG: checkpoint record is at 7/9505D650
LOG: redo record is at 7/9505D650; undo record is at 0/0; shutdown TRUE
LOG: next transaction id: 24438; next oid: 1850892
LOG: database system is ready
POSTGRES backend interactive interface
1.307.2.1 2003/01/01 21:57:18
backend> reindex database KakaoStats
ERROR: REINDEX DATABASE: Can be executed only on the currently open database.
backend>
______________________________________________________________________
Yahoo! Messenger - Fale com seus amigos online. Instale agora!
http://br.download.yahoo.com/messenger/