Note however that Oracle offeres full transactionality and does in place row updates. There is more than one way to do it.
Cheers
Dave
On Mar 21, 2010 5:43 PM, "Merlin Moncure" <mmoncure@xxxxxxxxx> wrote:On Sat, Mar 20, 2010 at 11:47 PM, Andy Colson <andy@xxxxxxxxxxxxxxx> wrote:
for non trivial selects (myisam has no transaction overhead so can
> Don't underestimate my...
usually edge out pg in row by row ops), and without taking multi user
issues into account, it's often going to come down to who generates a
better plan. postgres has more plan options and a better statistics
model and can usually beat mysql on many types of selects.
updates w/myisam are where mysql really shines in single user apps.
the reason is obvious: no mvcc means the heap can often be updated in
place.
merlin
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to y...
