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/ ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
