X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 5F9E0563F6 for ; Wed, 9 Mar 2005 14:46:42 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 36636-02 for ; Wed, 9 Mar 2005 14:46:32 +0000 (GMT) Received: from uead1.campusvirtual.br (unknown [200.222.48.40]) by svr1.postgresql.org (Postfix) with ESMTP id 134FE563E7 for ; Wed, 9 Mar 2005 14:46:29 +0000 (GMT) Received: from silvio (unknown [10.40.0.27]) by uead1.campusvirtual.br (Postfix) with SMTP id 4A414192736 for ; Wed, 9 Mar 2005 14:31:08 +0000 (UTC) Message-ID: <006401c524b6$82277940$1b00280a@ugf.br> From: =?iso-8859-1?Q?Ricardo_Valen=E7a_de_Assis?= To: References: <003101c52316$bd8e4f00$8c0aa8c0@rram> <422EDF21.4080903@tinet.org> Subject: Slow Update Date: Wed, 9 Mar 2005 11:44:33 -0300 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2800.1437 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 X-Campus_Virtual-UGF-MailScanner-Information: Please contact the ISP for more information X-Campus_Virtual-UGF-MailScanner: Found to be clean X-MailScanner-From: valenca@campusvirtual.br X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/124 X-Sequence-Number: 16622 Hi everydoby! I have a table with more than 26000 rows and I need to use update a column of this tables on all lines according with a column. So, I need to use update 26000 times correct? I tried to use a this command: "UPDATE database SET column1=0 WHERE column2 in (VARIABLES)", where VARIABLES is the list separeted by commas. But the list has about 26000 entries, so I got a message of too long parameters. Is there a way to use UPDATE pushing values from a file? Is there a way to run update more faster? It is taking about 10 seconds for each UPDATE... Does anyone knows another form to do this task? Thanks ----- Original Message ----- From: "Daniel Rubio" To: Sent: Wednesday, March 09, 2005 8:33 AM Subject: Re: [ADMIN] Too many clients----A big problem for my team > I had the same problem a few weeks ago. > > Was happening that our developers using Tomcat, were using connection > pools, and stoping and restarting their aplications which causes to > leave these connection opened and opening some new. > > Look in the servlet engine (or what they use) for the number of > connections they made (in Tomcat it's a parameter), say them not to > leave the connections opened, and not to stop and restart the java > application when they make changes, they must restart the "engine" (it > closes all the opened connections). > > It worked for me ... > > ganapatiram wrote: > > > Hi Experts, > > > > I work with postgresql 8.0 version. I have a team of 14 > > developers. When all the team connects the DB i see this error very very > > frequently which is a severe problem for me and team all the day. The > > error is: > > > > > > *Please report this exception: java.sql.SQLException: FATAL: sorry, too > > many clients already* > > > > ** > > > > *when i do trial and error changes i see this error differently but the > > essense of the error remains same. * > > > > ** > > > > * *I have max_connections=200 and i have 5 users for my DB. I > > dont understand what to do in order to resolve this. Please suggest me > > something by which i can overcome this problem. I referred few threads > > but none of them are of my case. > > > > > > > > > > > > Waiting for your valuable suggestion.......... > > > > > > > > > > > > > > > > > > > > Thanks and Regards > > > > Ram > > > > > -- > ******************************************************** > Daniel Rubio Rodríguez > OASI (Organisme Autňnom Per la Societat de la Informació) > c/ Assalt, 12 > 43003 - Tarragona > Tef.: 977.244.007 - Fax: 977.224.517 > e-mail: drubio a oasi.org > ******************************************************** > > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org