Need advice on best system to choose

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>
>