On the new system the bulk loads are extremely slower than on the
previous
machine and so are the more complex queries. The smaller transactional
queries seem comparable but i had expected an improvement. Performing a
db
import via psql -d databas -f dbfile illustrates this problem.
If you use psql (not pg_restore) and your file contains no BEGIN/COMMIT
statements, you're probably doing 1 transaction per SQL command. As the
others say, if the old box lied about fsync, and the new one doesn't,
performance will suffer greatly. If this is the case, remember to do your
imports the proper way : either use pg_restore, or group inserts in a
transaction, and build indexes in parallel.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
