Re: postgresql with storage - Mailing list pgsql-general

From Nagalingam, Karthikeyan
Subject Re: postgresql with storage
Date
Msg-id 5FFF8E9361C5D84EBBAF70C1931CDDE3035D81BD@BTCMVEXC1-PRD.hq.netapp.com
Whole thread Raw
In response to Re: postgresql with storage  (Serge Fonville <serge.fonville@gmail.com>)
Responses Re: postgresql with storage
List pgsql-general
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

pgsql-general by date:

Previous
From: Sam Mason
Date:
Subject: Re: Format string for ISO-8601 date and time
Next
From: Andrew Gould
Date:
Subject: Off Topic: ICD-10 codes in a database table?