On Mon, 29 Nov 1999 [EMAIL PROTECTED] wrote:
> When postgres will use posix threads or support pool of backends (like apache)?
> I guess it will increase speed very fast.
I am pretty sure it wouldn't. Postgres is slow (I think you compare it
to MySQL) because it has all moder features MySQL lacks - transactions,
triggers and rules.
If you look into mysql's docs you'll find there a note in TODO: mysql
will never implement triggers/rules as it slows down the system
considerably - triggers conditions must be checked on every query, for all
queries.
Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ [EMAIL PROTECTED]
Programmers don't die, they just GOSUB without RETURN.
************