On 19/08/11 12:52, Mark Kirkwood wrote:
On 19/08/11 02:09, Ogden wrote:
On Aug 18, 2011, at 2:07 AM, Mark Kirkwood wrote:
On 18/08/11 17:35, Craig Ringer wrote:
On 18/08/2011 11:48 AM, Ogden wrote:
Isn't this very dangerous? I have the Dell PERC H700 card - I see
that it has 512Mb Cache. Is
On 19/08/11 02:09, Ogden wrote:
On Aug 18, 2011, at 2:07 AM, Mark Kirkwood wrote:
On 18/08/11 17:35, Craig Ringer wrote:
On 18/08/2011 11:48 AM, Ogden wrote:
Isn't this very dangerous? I have the Dell PERC H700 card - I see that it has
512Mb Cache. Is this the same thing and good enough to s
I'm in the process of upgrading from postgres 7.4.8 to 9.0.4 and wanted to run
my decisions past some folks who can give me some input on whether my decisions
make sense or not.
It's basically a LAPP configuration and on a busy day we probably get in the
neighborhood of a million hits.
Serve
Hi Craig,
Fair point. For now, I mean "just fast" - which is 5-15 seconds, but I'd
like to get it down to the 1-2 second range.
>From the query I provided, I have approximately 30,000 unique keys (what I
called primary_id) that I'm grouping by, and each key has a series of
numerical values for e
On Aug 17, 2011, at 4:17 PM, Greg Smith wrote:
> On 08/17/2011 02:26 PM, Ogden wrote:
>> I am using bonnie++ to benchmark our current Postgres system (on RAID 5)
>> with the new one we have, which I have configured with RAID 10. The drives
>> are the same (SAS 15K). I tried the new system with
On Aug 18, 2011, at 2:07 AM, Mark Kirkwood wrote:
> On 18/08/11 17:35, Craig Ringer wrote:
>> On 18/08/2011 11:48 AM, Ogden wrote:
>>> Isn't this very dangerous? I have the Dell PERC H700 card - I see that it
>>> has 512Mb Cache. Is this the same thing and good enough to switch to
>>> nobarrier
On Thu, Aug 18, 2011 at 1:35 AM, Craig Ringer wrote:
> On 18/08/2011 11:48 AM, Ogden wrote:
>>
>> Isn't this very dangerous? I have the Dell PERC H700 card - I see that it
>> has 512Mb Cache. Is this the same thing and good enough to switch to
>> nobarrier? Just worried if a sudden power shut down
On 18 Srpen 2011, 0:40, hyelluas wrote:
> Should I start with replacing the sql with procedures?
>
> Should I start with replacing the views with the procedures to save time
> on
> recreating an execution plan and parsing?
>
> Should I start with tuning server parameters ?
Yes, you should start b
On 18/08/11 17:35, Craig Ringer wrote:
On 18/08/2011 11:48 AM, Ogden wrote:
Isn't this very dangerous? I have the Dell PERC H700 card - I see
that it has 512Mb Cache. Is this the same thing and good enough to
switch to nobarrier? Just worried if a sudden power shut down, then
data can be lost
