Re^3: Perl/PostgreSQL niche

Speed: how many concurrent connections are we talking about here? Given equal hardware, PG supports a greater number of concurrent connections without bogging down; and with the 8.0 release, speed is on-par with MySQL in most areas. Look for speed improvements in 8.1.

Security:
"By default, PostgreSQL is probably the most security-aware database available ..."
Database Hacker's Handbook
Lithcfield et. al.
Wiley
Wiley

Comment on Re^3: Perl/PostgreSQL niche

Replies are listed 'Best First'.
Re^4: Perl/PostgreSQL niche by perrin (Chancellor) on Sep 06, 2005 at 16:18 UTC
I think your information is outdated. Using the older MyISAM tables, concurrent updates do not scale well on MySQL. The newer InnoDB tables scale very well, and have the same sort of locking system that PostgreSQL has.	[reply]