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