for almost any long-running query.
I'm moving those servers to PG, due to this (concurrency) and other reasons.
My top 3 reasons are: a much better concurrency (even with bg vacuums
running :-), a much better planner, and PG's rich feature set.
--
Best Regards,
Igor Shevchenk
v3 protocol with binary format (PostgreSQL 7.4+), the
overhead is minimal both ways.
--
Best regards,
Igor Shevchenko
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
