[ADMIN] Postgres on polyserve cluster file system

2008-08-01 Thread Bhella Paramjeet-PFCW67
Hi, We are going to be moving our production postgres databases to new SAN with polyserve clustering filesystem. Can anyone running postgres on polyserver tell us what file system mount options should we use to get best performance? Our existing san with ext3 filesystem mounted with " rw,noatime

Re: [ADMIN] [PERFORM] Nls sorting in Postgresql-8.3.3

2008-08-01 Thread Richard Huxton
Praveen wrote: Hello, I installed postgresql-8.3.3 in our local server with option --enable-nls . After successful installion , I create database and import data.But I am not aware how to use nls sort in this postgresql-8.3.3 . Please tell me syntax how to use nls sort in query , if some one

[ADMIN] Nls sorting in Postgresql-8.3.3

2008-08-01 Thread Praveen
Hello, I installed postgresql-8.3.3 in our local server with option --enable-nls . After successful installion , I create database and import data.But I am not aware how to use nls sort in this postgresql-8.3.3 . Please tell me syntax how to use nls sort in query , if some one know. Thanks in