Tuning PostgreSQL for bulk imports

Kirk Strauser kirk at strauser.com
Mon Jan 8 12:51:03 UTC 2007

On Monday 08 January 2007 1:51 am, Abdullah Al-Marrie wrote:

> Why did you choose PostgreSQL over MySQL 5.0.x?

We value our data, ruling out MyISAM.  PostgreSQL is much faster than InnoDB 
for many concurrent reads and complex queries.

> Is the latest PostgreSQL release performance much better than MySQL
> 5.0.x in RELENG_6 with SMP and 2 GB of ram now?

This has been true for our workload for several years.
Kirk Strauser
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 155 bytes
Desc: not available
Url : http://lists.freebsd.org/pipermail/freebsd-questions/attachments/20070108/448dac47/attachment.pgp

More information about the freebsd-questions mailing list