Re: [GENERAL] JDBC speed question.

2001-04-28 Thread Justin Clift
n > > - Original Message - > From: "Doug McNaught" <[EMAIL PROTECTED]> > To: "Clayton Vernon" <[EMAIL PROTECTED]> > Cc: "John Oakes" <[EMAIL PROTECTED]>; > <[EMAIL PROTECTED]> > Sent: Thursday, April 26, 2001 6:19 PM

Re: [GENERAL] JDBC speed question.

2001-04-26 Thread Doug McNaught
"Clayton Vernon" <[EMAIL PROTECTED]> writes: > Thanks, but can I specify each port? I've only seen the one documented > command option "-p" which I assume was for the TCP/IP port. Well, Unix sockets don't have a "port". The port number you specify is appended to the name of the socket in the fi

Re: [GENERAL] JDBC speed question.

2001-04-26 Thread Doug McNaught
"Clayton Vernon" <[EMAIL PROTECTED]> writes: > Related question: how do you run postgreSQL to simultaneously support a Unix > socket and TCP/IP? Just add '-i' to the postmaster startup options. The Unix socket will still be available. -Doug -- The rain man gave me two cures; he said jump ri

Re: [GENERAL] JDBC speed question.

2001-04-26 Thread Doug McNaught
"John Oakes" <[EMAIL PROTECTED]> writes: > Anyone have any ideas how to speed up performance using the JDBC driver? A > query that takes me 20 seconds to execute from command line takes 1 full > minute with the jdbc driver. Thanks. Since you don't guve any details of your query or network setu