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