Message-ID: <4D4EF7D6.5000200@linos.es>
Date: Sun, 06 Feb 2011 20:34:46 +0100
From: Linos <info@linos.es>
User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US;
	rv:1.9.2.13) Gecko/20101230 Lanikai/3.1.7 ThunderBrowse/3.3.4
MIME-Version: 1.0
To: Pierre C <lists@peufeu.com>
CC: pgsql-performance@postgresql.org
Subject: Re: general hardware advice
References: <4D4EE577.9060803@linos.es> <op.vqhxjnfxeorkce@apollo13>
In-Reply-To: <op.vqhxjnfxeorkce@apollo13>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit

El 06/02/11 20:24, Pierre C escribió:
> 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.
>

The load for the Postgresql instance it is to be low, maybe 5 or 6 simultaneous 
clients with a oltp application, but it is database intensive only when 
reporting not in the usual work.

About the filesystem i was thinking to use xfs, i think would be the best for 
this use-case in Linux, any advice on this please?

Regards,
Miguel Angel.