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@xxxxxxxxxx> wrote:
Hi,I have some basic query in postgresql with storage, Please help me for the following1. What is the best practice to use postgresql with storage.2. Which are the files and folders we can keep them in storage.RegardsKarthikeyan.N