Received: from news.tht.net (news.hub.org [216.126.91.242]) by postgresql.org (8.11.3/8.11.4) with ESMTP id fBH29lm53213 for ; Sun, 16 Dec 2001 21:09:48 -0500 (EST) (envelope-from news@news.tht.net) Received: (from news@localhost) by news.tht.net (8.11.4/8.11.4) id fBH26rh65320 for pgsql-sql@postgresql.org; Sun, 16 Dec 2001 21:06:53 -0500 (EST) (envelope-from news) X-Newsgroups: comp.databases.postgresql.sql From: marc@oscar.eng.cv.net (Marc Spitzer) Subject: Re: persistent connections, AOLserver (Was: maybe Offtopic : References: <20011203110458.E93680-100000@megazone23.bigpanda.com> Message-Id: User-Agent: slrn/0.9.7.0 (FreeBSD) Lines: 21 Date: Mon, 17 Dec 2001 02:01:06 GMT Organization: Optimum Online To: pgsql-sql@postgresql.org X-Archive-Number: 200112/168 X-Sequence-Number: 5991 In article <20011203110458.E93680-100000@megazone23.bigpanda.com>, Stephan Szabo wrote: > On Fri, 30 Nov 2001, Steve Brett wrote: > >> is there a limit/guide to the number of inserts you should use in a >> transaction block ? > > Not a hard one, but I usually do thousands of rows (around 5k) per > transaction when I'm batch inserting, and I usually set it there so > I can watch its progress from another db session as the counts rise. > How do you set up the other session to watch? marc > > ---------------------------(end of broadcast)--------------------------- > TIP 2: you can get off all lists at once with the unregister command > (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)