Re: [PERFORM] libpq or postgresql performance

2012-09-07 Thread Ireneusz Pluta
W dniu 2012-09-07 17:43, Aryan Ariel Rodriguez Chalas pisze: Thank you all for answering that quickly... A simple query could be "SELECT LOCALTIMESTAMP(0)" which could last even 5 seconds for returning data. The other queries that I would like to be faster, return less than 50 rows until now

Re: [PERFORM] exponential performance decrease in ISD transaction

2012-09-07 Thread John Nash
Sorry I forgot to attach the mentioned file with performance results. Please find it enclosed now. Regards 2012/9/7 John Nash : > Hi, > > We have investigated further and have observed the following: > > We have another host with postgres installed in another IP. Called host 190. > > The host we

Re: [PERFORM] exponential performance decrease in ISD transaction

2012-09-07 Thread John Nash
Hi, We have investigated further and have observed the following: We have another host with postgres installed in another IP. Called host 190. The host we have reported to have the issue is host174 We have observed that if we launch the java program from host 190 towards host 174 through the ne