[HACKERS] PostgreSQL optimisations on Linux machines with more than 24 cores

2012-03-25 Thread Constantin Teodorescu
. Is the new 9.1.3 PostgreSQL using some of the patches recommended in that article that would enhance multi-core scalability? Thank you very much for your attention, Constantin Teodorescu

Re: [HACKERS] PostgreSQL performance enhancement when query planner

2006-08-08 Thread Constantin Teodorescu
Csaba Nagy wrote: Constantin, What binding are you using ? We here use Java+JDBC, and we were able to get stable query plans by forcing server side prepared statements (using PGStatement#setPrepareThreshold with 1 as the threshold), where the query is prepared without knowing the parameter

[HACKERS] PostgreSQL performance enhancement when query planner fails to guess the right plan

2006-08-07 Thread Constantin Teodorescu
of there the best of the quickest of the fastest query plan. :-) Hope that this long message have not disturb you so much ... so I'm waiting for your comments and suggestions. Best regards, Constantin Teodorescu Braila, ROMANIA ---(end of broadcast)--- TIP 5

[HACKERS] Big number of schemas (3500) into a single database

2004-11-23 Thread Constantin Teodorescu
workstation database in a separate schema in the central database that mean that I will have 3500 different schemas. Is there any limit or any barrier that could stop this kind of approach or make things go slower? Constantin Teodorescu Ancient PgAccess developer P.S. Please Cc: me at [EMAIL

[HACKERS] Re: [INTERFACES] pgAccess fails to launch on HPUX

2001-02-12 Thread Constantin Teodorescu
ly because it isn't in a "load" explicit command. Constantin Teodorescu