On Sun, Mar 6, 2011 at 5:41 AM, Martijn van Oosterhout <klep...@svana.org>wrote:
> If it's really really important there are ways you can use trigger > tables and summary views to achieve the results you want. Except it's > expensive and when people are told that all of the sudden the count(*) > performance isn't so important any more. :) > That's often perfectly fine, with read-heavy, single-writer workloads. I definitely wish there was a way to create indexes to track counters on various types of queries, even if it eliminates write concurrency on affected writes. Doing it by hand is a pain. -- Glenn Maynard