On 10/10/2012 12:05 PM, Claudio Freire wrote:
Why does nobody every mention that concurrent access has to be taken into account?
That's actually a good point. But if you have one giant database, the overlap of which tables are being accessed by various sessions is going to be immense.
There probably should be a point about this in the docs, though. There are more and more shared-hosting setups or places that spread their data horizontally across separate databases for various clients, and in those cases, parallel usage does not imply overlap.
-- Shaun Thomas OptionsHouse | 141 W. Jackson Blvd. | Suite 500 | Chicago IL, 60604 312-444-8534 sthomas@xxxxxxxxxxxxxxxx ______________________________________________ See http://www.peak6.com/email_disclaimer/ for terms and conditions related to this email -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance