[PERFORM] Nls sorting in Postgresql-8.3.3

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

Re: [PERFORM] Nls sorting in Postgresql-8.3.3

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

Re: [PERFORM] Database size Vs performance degradation

On Thu, 31 Jul 2008, Andrzej Zawadzki wrote: Maybe I'm wrong but if this bulk insert and delete process is cyclical then You don't need vacuum full. Released tuples will fill up again with fresh data next day - after regular vacuum. Yes, a regular manual vacuum will prevent the table from