Re: Need advice on best system to choose

Hi, Kenroy. Can you make a test suite so that you could run a performance
test on each platform? I see you will have different hardware and
operating systems.

Best,
Aleksey

On Sun, Mar 24, 2013 at 11:40 AM, Kenroy Bennett <bennettk9999(at)gmail(dot)com>wrote:

>
>
> On a hourly basis 13 tables with number of columns between 50 to 70
> columns are updated with 170 rows.
> The tables have a text and timestamps column with other columns being
> real.
>
> Kenroy
>
>
>
> On Sat, Mar 23, 2013 at 8:40 PM, John R Pierce <pierce(at)hogranch(dot)com>wrote:
>
>> On 3/23/2013 4:03 PM, Kenroy Bennett wrote:
>>
>>> I welcome your advice on choosing between these systems
>>>
>>
>> those are both obsolete systems several generations old. The HP DL stuff
>> is g7 or g8 now, not g4. that sunfire is newer, but doesn't have much
>> ram, at least by modern database server standards.
>>
>> your system description didn't include the all important performance
>> requirements. "the database will be update on a hourly basis." ... does
>> that mean 1 row is updated every hour? some sized batch of new data is
>> inserted? or the whole database is wiped and rebuilt? or what? most
>> of my databases are undergoing constant updates/inserts of new data on a
>> steady basis, so we measure things in terms of transactions/second, with an
>> understanding of the approximate size of each transaction.
>>
>> the CPUs in that DL380G4 are late Pentium-4 class, they are the dual core
>> version of the rather slow 'netburst' architecture. in particular these
>> weren't all that fast at most floating point type operations.
>>
>> the E5450, is from the Core 2 Quad generation, so its quite a bit better
>> than the P4's, but still way behind the Sandy Bridge/Ivy Bridge stuff
>>
>>
>>
>> --
>> john r pierce 37N 122W
>> somewhere on the middle of the left coast
>>
>>
>>
>> --
>> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
>> To make changes to your subscription:
>> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>>
>
>
>

--
CFEngine Training:
New Jersey, Apr 29 - May 2. http://cf3.eventbrite.com/