News for hackers. Stuff that matters.
Re:PostgreSQL Parallel Query v2 by throwaway91111 on Tuesday March 14, 2017 @09:16PM (#13873054)
Doesn't this inherently depend on the query? Shard-local i/o saturation affects the latency of the entire query if you're not expecting the i/o to the client to saturate.
Re:PostgreSQL Parallel Query v2 by qeternity on Tuesday March 14, 2017 @09:44PM (#13873151)
This was exactly my point. But usually you're doing a full scan across all shards, so disk i/o is being saturated by virtue of the MPP sharding.