Skip site navigation (1) Skip section navigation (2)

Re: Hardware recommendations to scale to silly load

From: "Matt Clark" <matt(at)ymogen(dot)net>
To: "Vivek Khera" <khera(at)kcilink(dot)com>,<pgsql-performance(at)postgresql(dot)org>
Subject: Re: Hardware recommendations to scale to silly load
Date: 2003-08-28 16:29:39
Message-ID: OAEAKHEHCMLBLIDGAFELOEFEDHAA.matt@ymogen.net (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-performance
> Just how big do you expect your DB to grow?  For a 1GB disk-space
> database, I'd probably just splurge for an SSD hooked up either via
> SCSI or FibreChannel.  Heck, up to about 5Gb or so it is not that
> expensive (about $25k) and adding another 5Gb should set you back
> probably another $20k.  I use an SSD from Imperial Technology
> ( http://www.imperialtech.com/ ) for mail spools.  My database is way
> to big for my budget to put in SSD.

I may well be able to split some tables that aren't used in joins into a separate DB, and could well use an SSD for those.

In fact two of the inserts per user interaction could be split off, and they're not financially important tables, so fsync=false
could be enabled for those, in which case an SSD might be overkill...

The whole thing will definitely *not* fit in an SSD for a sensible price, but the WAL might well!






In response to

pgsql-performance by date

Next:From: Matt ClarkDate: 2003-08-28 16:37:24
Subject: Re: Hardware recommendations to scale to silly load
Previous:From: Andrew SullivanDate: 2003-08-28 16:19:53
Subject: Re: Hardware recommendations to scale to silly load

pgsql-hackers by date

Next:From: Tom LaneDate: 2003-08-28 16:30:21
Subject: Re: memory allocation and powers of two
Previous:From: Andrew SullivanDate: 2003-08-28 16:19:53
Subject: Re: Hardware recommendations to scale to silly load

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group