No problem, hope it helps. The single most important part of any
fast, transactional server is the RAID controller and its cache.
On Sat, Aug 25, 2012 at 3:26 PM, Felix Schubert wrote:
> Don't know but I forwarded the question to the System Administrator.
>
> Anyhow thanks for the information up
Don't know but I forwarded the question to the System Administrator.
Anyhow thanks for the information up to now!
best regards,
Felix
Am 25.08.2012 um 14:59 schrieb Scott Marlowe :
> Well it sounds like it does NOT have a battery back caching module on
> it, am I right?
> Not always. The case for having (col1,col2) might be very
> compelling.
True. But in our case, the table has like 8M rows, so and col1 is some kind of
job identifier, so it's evenly distributed. Col2 on the other hand is a
customer id, so it has much higher cardinality. Previous DBA missed it
On Sat, Aug 25, 2012 at 6:53 AM, Felix Schubert wrote:
> Hi Scott,
>
> the controller is a HP i410 running 3x300GB SAS 15K / Raid 5
Well it sounds like it does NOT have a battery back caching module on
it, am I right?
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org
On Sat, Aug 25, 2012 at 6:59 AM, Scott Marlowe wrote:
> On Sat, Aug 25, 2012 at 6:53 AM, Felix Schubert wrote:
>> Hi Scott,
>>
>> the controller is a HP i410 running 3x300GB SAS 15K / Raid 5
>
> Well it sounds like it does NOT have a battery back caching module on
> it, am I right?
Also what sof
Hi Scott,
the controller is a HP i410 running 3x300GB SAS 15K / Raid 5
Mit freundlichen Grüßen
Felix Schubert
Von meinem iPhone gesendet :-)
Am 25.08.2012 um 14:42 schrieb Scott Marlowe :
> On Sat, Aug 25, 2012 at 6:07 AM, Felix Schubert wrote:
>> Hello List,
>>
>> I've got a system on a c
On Sat, Aug 25, 2012 at 6:07 AM, Felix Schubert wrote:
> Hello List,
>
> I've got a system on a customers location which has a XEON E5504 @ 2.00GHz
> Processor (HP Proliant)
>
> It's postgres 8.4 on a Debian Squeeze System running with 8GB of ram:
>
> The Postgres Performance on this system measu
Hello List,
I've got a system on a customers location which has a XEON E5504 @ 2.00GHz
Processor (HP Proliant)
It's postgres 8.4 on a Debian Squeeze System running with 8GB of ram:
The Postgres Performance on this system measured with pgbench is very poor:
transaction type: TPC-B (sort of)
sca
