Re: understanding postgres issues/bottlenecks

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: Ron <rjpeace(at)earthlink(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: understanding postgres issues/bottlenecks
Date: 2009-01-10 22:09:55
Message-ID: 87mydybyoc.fsf@oxford.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Ron <rjpeace(at)earthlink(dot)net> writes:

> At 10:36 AM 1/10/2009, Gregory Stark wrote:
>>
>> Or a system crash. If the kernel panics for any reason when it has dirty
>> buffers in memory the database will need to be restored.
>
> A power conditioning UPS should prevent a building wide or circuit level bad
> power event

Except of course those caused *by* a faulty UPS. Or for that matter by the
power supply in the computer or drive array, or someone just accidentally
hitting the wrong power button.

I'm surprised people are so confident in their kernels though. I know some
computers with uptimes measured in years but I know far more which don't.

--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's RemoteDBA services!

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message david 2009-01-10 22:40:51 Re: understanding postgres issues/bottlenecks
Previous Message Ron 2009-01-10 21:56:56 Re: understanding postgres issues/bottlenecks