Chad <chadrosen@xxxxxxxxx> writes: > export: > pg_dump forums --data-only --no-owner -t foo > <output file> > The load step seems really slow. Don't use --data-only. Or if you must, look into dropping and recreating indexes and foreign keys. See http://www.postgresql.org/docs/8.3/static/populate.html (or the corresponding page for whatever PG version you are using). regards, tom lane