From: | "Pierre C" <lists(at)peufeu(dot)com> |
---|---|
To: | "Ryan Wexler" <ryan(at)iridiumsuite(dot)com>, pgsql-performance(at)postgresql(dot)org |
Subject: | Re: performance on new linux box |
Date: | 2010-07-08 08:56:02 |
Message-ID: | op.vfiofo1leorkce@apollo13 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
> 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.
From | Date | Subject | |
---|---|---|---|
Next Message | Eliot Gable | 2010-07-08 13:45:45 | Re: performance on new linux box |
Previous Message | Andy Colson | 2010-07-08 02:07:08 | Re: performance on new linux box |