postgresql with storage

Hi,
Not entirely sure what you mean, but here goes

1.Use a hight performance storage device (as applies with all databases)
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.

It would be helpful if you were more specific in what you want to know and
if it were a bit more clear of what your goals and environment is:
What OS are you using
What will be the purpose of the databases
What environment do you have.
What services should it provide
What database engines do you already have experience with
Why do you want to know this (what is your endgoal)
What have you already researched (googled)
Are you migrating data or is it a new setup.
What do the servers look like

To name a few questions that come to mind

Hope this helps

Regards,

Serge Fonville

On Thu, Feb 26, 2009 at 1:06 PM, Nagalingam, Karthikeyan <
KARTHIKEYAN.Nagalingam@netapp.com> 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

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.

It would be helpful if you were more specific in what you want to know
and if it were a bit more clear of what your goals and environment is:
What OS are you using
RHEL5

What will be the purpose of the databases
Databases for webapplicaiton, datawarehousing

What environment do you have.
I would like to keep the database in storage controller, which is
accessible through NFS.

What services should it provide
Web services for continous read and write in the database

What database engines do you already have experience with
I have experience with MySQL storage engines, specifically MyISAM,
Innodb.

Why do you want to know this (what is your endgoal)
The performance of Postgresql in Storage environment. Also we would like
to create the Backup, Restore and DR solution using Storage

What have you already researched (googled)
Installation of Postgres, doing basic functionality

Are you migrating data or is it a new setup.
Now New setup, But In future we might need to migrat the data from
different database like MySQL, Oracle

What do the servers look like
The servers are IBM X86[32bit ]

To name a few questions that come to mind

Hope this helps

Regards,

Serge Fonville

On Thu, Feb 26, 2009 at 1:06 PM, Nagalingam, Karthikeyan
<KARTHIKEYAN.Nagalingam@netapp.com> wrote:

Hi,

I have some basic query in postgresql with storage, Please help
me for the following

1. What is the best practice to use postgresql with storage.

2. Which are the files and folders we can keep them in storage.

Regards
Karthikeyan.N

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.

The only meaningful benchmark is your application, all other benchmarks
only measure the performance of the benchmark.

As a benchmark you can also look into
http://developer.postgresql.org/pgdocs/postgres/pgbench.html
Hope this helps

Regards,

Serge Fonville