On Mon, 29 Nov 1999, Oleg Broytmann wrote:

> 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.

Ummmm...careful about the generalization...I can write queries in
PostgreSQL that give the same results as MySQL, in half the time *shrug*
PostgreSQL supports sub-selects, where MySQL doesn't, which means that one
can do in one query what MySQL might take two or three...

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: [EMAIL PROTECTED]           secondary: scrappy@{freebsd|postgresql}.org 


************

Reply via email to