Re: PostgreSQL HardWare

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(dot)Campano(at)LibertyMutual(dot)com
[mailto:Troy(dot)Campano(at)LibertyMutual(dot)com]
Sent: Friday, January 04, 2002 12:30 PM
To: jwbaker(at)acm(dot)org; snmartin(at)galilea(dot)cl
Cc: pgsql-general(at)postgresql(dot)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(at)acm(dot)org]
Sent: Friday, January 04, 2002 2:02 PM
To: Fernando San Martín Woerner
Cc: pgsql-general(at)postgresql(dot)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(at)postgresql(dot)org)

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