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 <bennettk9...@gmail.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 <pie...@hogranch.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@postgresql.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/
