Re: general hardware advice - Mailing list pgsql-performance

From Pierre C
Subject Re: general hardware advice
Date
Msg-id op.vqhxjnfxeorkce@apollo13
Whole thread Raw
In response to general hardware advice  (Linos <info@linos.es>)
Responses Re: general hardware advice
List pgsql-performance
On Sun, 06 Feb 2011 19:16:23 +0100, Linos <info@linos.es> wrote:

> I am searching what would be the best hardware combination to a new
> server i have to install, the new server will have a Postgresql 9.0 with
> a database of about 10gb, the database part it is not the problem for
> me, in this size almost, the part where i am a bit lost is that i have
> to share from the same server about 20TB of data with samba or ISCSI (i
> have to test both ways to share when i have the hardware) because this
> is to be the file-server of 8 Avid video workstations.

What is the expected load on the postgresql instance ?

Also, for multiple high throughput concurrent streams (as in AVID),
filesystem choice is critical.

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Really really slow select count(*)
Next
From: Linos
Date:
Subject: Re: general hardware advice