Re: PostgreSQL HardWare - Mailing list pgsql-general

From SHELTON,MICHAEL (Non-HP-Boise,ex1)
Subject Re: PostgreSQL HardWare
Date
Msg-id FB60DFB2C0E24449AC0C21F743B935410150F8C1@xboi02.boi.hp.com
Whole thread Raw
In response to PostgreSQL HardWare  (Fernando San Martín Woerner <snmartin@galilea.cl>)
List pgsql-general
In europe 70.000,00 = 70,000.00 in US (got bit by that little bug when we
brought on a brokerage in Germany -- also watch out for 5/6/02 = May 6th,
2002 in US and June 5th, 2002 in Europe!!).

Mike

-----Original Message-----
From: Troy.Campano@LibertyMutual.com
[mailto:Troy.Campano@LibertyMutual.com]
Sent: Friday, January 04, 2002 12:30 PM
To: jwbaker@acm.org; snmartin@galilea.cl
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL HardWare


Well did he mean 70.000 records or 70,000 records?




-----Original Message-----
From: Jeffrey W. Baker [mailto:jwbaker@acm.org]
Sent: Friday, January 04, 2002 2:02 PM
To: Fernando San Martín Woerner
Cc: pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgreSQL HardWare




On Fri, 4 Jan 2002, Fernando San Martín Woerner wrote:

> I need to build a postgresql database with 2 tables containing 70.000
> records each one, but they'll increase their size in 4.000 records
> monthly and some triggers and functions will be running on this tables
> plus other smaller tables less than 40.000 records.

That's a really small database.  You should be able to run it on practically
any hardware, and probably store all the data in memory.

-jwb



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
    (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)

---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster

pgsql-general by date:

Previous
From: "Robert J. Sanford, Jr."
Date:
Subject: Re: PostgreSQL HardWare
Next
From: Tom Lane
Date:
Subject: Re: startup failed! fatal error