PostgreSQL v8 NAMEDATALEn >=128

From: "DEHAINSALA Hondjack" <hondjack(dot)dehainsala(at)ensma(dot)fr>
To: <pgsql-general(at)postgresql(dot)org>
Subject: PostgreSQL v8 NAMEDATALEn >=128
Date: 2004-10-12 18:43:13
Message-ID: 013201c4b08b$5751fc30$4aa337c1@pchondjack
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi !
sorry for my english ! I am french :-)

I want to test postgreSQL v8 native Windows! Where i can get a version which
allows more than 64 characters (NAMEDATALEN ~=128) to the name of tables and
columns ?

I generate automaticly tables and the length of some of these tables is > to
64.

I use Postgresql 7.5 that I have recompiled the source after to have
modified the NAMEDATALEN to 128!
The server is very slow (ex. a query to table which contain 16.000 instances
take 1 munite). I don't know exactely why ?
Someone think that the emulateur cygwin is responsible and they recommend me
to install a postreSQL windows version.
Personally I think it may a problem of conguration of the server and a
tuning could increase performance.

SomeOne can help to tune my PostgreSQL?

Sorry again for my english !!

Thanks U for your help !!

Hondjack...

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Steven Klassen 2004-10-12 18:49:02 Re: data dir permissions and ownership
Previous Message CSN 2004-10-12 18:40:52 data dir permissions and ownership