Nagalingam, Karthikeyan wrote:
> Thanks for your information Serge Fonville, My answers are below
>
> 1.Use a hight performance storage device (as applies with all databases)
>
> The stroages are in cluster
that could mean almost anything.
>
> 2. everything that uis located in the PostgreSQL datadirectory can be
> located on any device you prefer as long as the availability is
> guaranteed from the perspective of the PostgreSQL processes.
> Availability no issue, Is there any benchmark tool is there to check
> the performance of Postgres in Storage environment.
>
the only meaningful benchmark is your application, all other benchmarks
only measure the performance of the benchmark.
> What environment do you have.
> I would like to keep the database in storage controller, which is
> accessible through NFS.
NFS is generally not recommended for relational databases, file locking
and random access on NFS can be somewhat sketchy. Most high
performance database servers use either SAN (FC, iSCSI) or direct
attached storage.