On 10/12/14 12:28, Strahinja Kustudić wrote:
* These tests are with the H710p controller set to write-back (WB) and
with adaptive read ahead (ADRA). I ran a few tests with
write-through (WT) and no read ahead (NORA), but the results were worse.
That is interesting: I've done some tes
On 10 December 2014 at 10:46, Josh Berkus wrote:
> On 12/05/2014 08:04 AM, Simon Riggs wrote:
>> On 6 December 2014 at 00:45, Merlin Moncure wrote:
>>
>>> Neat -- got any test cases (would this have prevented OP's problem)?
>>
>> No test case was posted, so I am unable to confirm.
>>
>> A test ca
On 12/05/2014 08:04 AM, Simon Riggs wrote:
> On 6 December 2014 at 00:45, Merlin Moncure wrote:
>
>> Neat -- got any test cases (would this have prevented OP's problem)?
>
> No test case was posted, so I am unable to confirm.
>
> A test case I produced that appears to be the same issue is fixed
I have a beast of a Dell server with the following specifications:
- 4x Xeon E5-4657LV2 (48 cores total)
- 196GB RAM
- 2x SCSI 900GB in RAID1 (for the OS)
- 8x Intel S3500 SSD 240GB in RAID10
- H710p RAID controller, 1GB cache
Centos 6.6, RAID10 SSDs uses XFS (mkfs.xfs -i size=512
On Mon, Dec 8, 2014 at 03:40:43PM -0600, Merlin Moncure wrote:
> >> Did not see consistent measurable gains > 256
> >> effective_io_concurrency. Interesting that at setting of '2' (the
> >> lowest possible setting with the feature actually working) is
> >> pessimal.
> >
> > Very interesting. Whe
On Tue, Dec 9, 2014 at 3:42 PM, Vivekanand Joshi wrote:
> What I actually want to achieve is right now is that running the same load
> on Netezza and PostgreSQL [300 GB data, 20 concurrent queries, and 30k-40K
> queries in an hour].
You will need to provide far more information about the type
Hi Team,
We are thinking of shifting our data warehouse solution from Netezza to
PostgreSQL. I am reading a lot about PostgreSQL lately.
Can you please let us know the minimum[overall performance should be good]
hardware requirements for the below mentioned statistics. My question is
actually
