On 4/7/06, Josh Berkus <josh@agliodbs.com> wrote:
> So even on a single seq scan, parallel query
> execution would make a significant difference
> in performance, possibly as
> much as +75% on seq scans of large tables.
I've been looking at several commercial systems which employ dynamic
partitioning for sequential scans of large tables. While 75% sounds a
little optimistic, there is most definitely a sizable performance
increase.
--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324