Re: [GENERAL] postgresql with storage

2009-02-26 Thread Serge Fonville
> > 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

Re: [GENERAL] postgresql with storage

2009-02-26 Thread John R Pierce
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 datadi

Re: [GENERAL] postgresql with storage

2009-02-26 Thread Nagalingam, Karthikeyan
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 availabi

Re: [GENERAL] postgresql with storage

2009-02-26 Thread Serge Fonville
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 P

[GENERAL] postgresql with storage

2009-02-26 Thread Nagalingam, Karthikeyan
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