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