Glen Eustace escribió: > >> Generally speaking, virtualization allows you to take a bunch of low >> powered servers and make them live in one big box saving money on >> electricity and management. Generally speaking, database sers are big >> powerful boxes with lots of hard disks and gigs upon gigs of ram to >> handle terabytes of data. Those two things seem at odds to me. > > If one is handling databases with Terabytes of data and 1000s of > connections, I would agree. We will be looking at 100s of Megabytes max > and possible several hundred connections. A much smaller workload.
You're not gonna get "several hundred connections" on a resource-starved machine. Consider using a pooler (pgbouncer, pgpool), and reducing the number of actual connections to the DB to a very low number of dozens. -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
