By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,834 Members | 2,234 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,834 IT Pros & Developers. It's quick & easy.

PostgreSQL v8 NAMEDATALEn >=128

P: n/a
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...



Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hi,

Am Di, den 12.10.2004 schrieb DEHAINSALA Hondjack um 20:43:
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 wonder what could be the reason to do so? Is it kind of an
ORM (object relational mapper)?
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.


Most of the time some indices here and there help :-)
You should have some example queries you find slow
and use EXPLAIN or EXPLAIN ANALYZE with them.

You can post the output here if you need help.

Regards
Tino
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.