On Wed, Dec 8, 2010 at 3:03 PM, Benjamin Krajmalnik wrote:
> I need to build a new high performance server to replace our current
> production database server.
We run FreeBSD 8.1 with PG 8.4 (soon to upgrade to PG 9). Hardware is:
Supermicro 2u 6026T-NTR+
2x Intel Xeon E5520 Nehalem 2.26GHz
On Thu, 09 Dec 2010 06:51:26 +0100, Alex Goncharov
wrote:
,--- You/Divakar (Wed, 8 Dec 2010 21:17:22 -0800 (PST)) *
| So it means there will be visible impact if the nature of DB
interaction is DB
| insert/select. We do that mostly in my app.
You can't say a "visible impact" unless you
If you are worried about wearing out the SSD's long term get a larger SSD and
create the partition smaller than the disk, this will reduce the write
amplification and extend the life of the drive.
TRIM support also helps lower write amplification issues by not requiring as
many pages to do the
On Thu, Dec 9, 2010 at 04:28, Scott Marlowe wrote:
> On Wed, Dec 8, 2010 at 5:03 PM, Benjamin Krajmalnik
> wrote:
>> My biggest concern with SSD drives is their life expectancy,
>
> Generally that's not a big issue, especially as the SSDs get larger.
> Being able to survive a power loss without
