| From: | Madison Kelly <linux(at)alteeve(dot)com> |
|---|---|
| To: | Luke Lonergan <LLonergan(at)greenplum(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: MySQL is faster than PgSQL but a large margin in |
| Date: | 2005-12-22 07:02:47 |
| Message-ID: | 43AA4F97.40201@alteeve.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
Luke Lonergan wrote:
> What version of postgres?
>
> Copy has been substantially improved in bizgres and also in 8.1.
> - Luke
Currently 7.4 (what comes with Debian Sarge). I have run my program on
8.0 but not since I have added MySQL support. I should run the tests on
the newer versions of both DBs (using v4.1 for MySQL which is also
mature at this point).
As others mentioned though, so far the most likely explanation is the
'fsync' being enabled on PostgreSQL.
Thanks for the reply!
Madison
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
Madison Kelly (Digimer)
TLE-BU; The Linux Experience, Back Up
Main Project Page: http://tle-bu.org
Community Forum: http://forum.tle-bu.org
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luke Lonergan | 2005-12-22 07:07:22 | Re: MySQL is faster than PgSQL but a large margin in |
| Previous Message | Madison Kelly | 2005-12-22 06:58:51 | Re: MySQL is faster than PgSQL but a large margin in my |