Re: persistent connections, AOLserver (Was: maybe Offtopic :

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Steve Brett <steve(dot)brett(at)e-mis(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: persistent connections, AOLserver (Was: maybe Offtopic :
Date: 2001-12-03 19:07:19
Message-ID: 20011203110458.E93680-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php pgsql-sql

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.

In response to

Responses

Browse pgsql-php by date

  From Date Subject
Next Message Ewald Geschwinde 2001-12-04 14:54:00 Re: Connection problem
Previous Message Jean-Michel POURE 2001-12-02 16:58:25 Re: PostgreSQL pseudo cluster

Browse pgsql-sql by date

  From Date Subject
Next Message Josh Berkus 2001-12-03 19:13:15 Re: Need help with a college SQL exam question...
Previous Message Vigny Christophe 2001-12-03 13:37:22 update with RE