[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 advance. Praveen Malik.
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 one know. What is "nls sort"? What do you expect --enable-nls to do? It looks like it's for multi-language message display rather than sorting. The locale options are already built-in. -- Richard Huxton Archonet Ltd -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
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 growing more than it needs to. However, a vacuum full is required to actually reduce the size of the table from 7.5G to 2.7G if that hasn't been done on the production system already. Matthew -- It's one of those irregular verbs - "I have an independent mind," "You are an eccentric," "He is round the twist." -- Bernard Woolly, Yes Prime Minister -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
