[PERFORM] Insert slow down on empty database

2005-06-03 Thread Morgan
=). I can work around this problem, and I am sure somebody is working on fixing this, but I thought it might be good to reaffirm the problem. Thanks, Morgan Kita ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

[PERFORM] Big question on insert performance/using COPY FROM

2005-08-31 Thread Morgan Kita
is why for bulkloads is VACUUM useful? I understand that it frees up dead rows as a result of UPDATE and such, but where are the dead rows created from plain INSERTS? Thanks, Morgan ---(end of broadcast)--- TIP 6: explain analyze is your friend