On Fri, Nov 20, 2009 at 12:15 PM, Matt Solnit <msolnit@soasta.com> wrote:
>
> We are running PostgreSQL 8.3.8 (64-bit) on a dedicated Fedora Core 8 machine, in Amazon EC2. This was using an
"extra-large"instance, which means 4 Xeon cores (2.66 GHz) and 15.5 GB of memory.
considering that ec2 is a virtualized environment, the first
conclusion that everyone is going to jump to is that this is some type
of issue with ec2. IIRC ec2 runs xen, did you search for any related
issues with xen and postgresql?
are you running the correct kernel?
http://developer.amazonwebservices.com/connect/entry.jspa?externalID=1535
"We strongly recommend using the 2.6.18 Xen stock kernel with the
c1.medium and c1.xlarge instances. Although the default Amazon EC2
kernels will work, the new kernels provide greater stability and
performance for these instance types. For more information about
kernels, refer to the Amazon Elastic Compute Cloud Developer Guide."
merlin