I have used batch update in postgres.
for jdbc driver:
A driver that implements batch updates may or may not continue to process
the remaining commands in a batch when one of the commands fails to execute
properly.
then , who can tell which version postgres's jdbc driver that continue to
process th
ECTED]>
wrote:
> On Thu, Feb 21, 2008 at 1:07 AM, hewei <[EMAIL PROTECTED]> wrote:
> > Hi, Scott Marlowe:
> >
> > You said that " As for processing them in order versus randomly,that's a
> > common problem. "
> > do you know why? how postgres
Hi, Scott Marlowe:
You said that " As for processing them in order versus randomly,that's a
common problem. "
do you know why? how postgres work in this scenario.
On Wed, Feb 20, 2008 at 3:07 PM, Scott Marlowe <[EMAIL PROTECTED]>
wrote:
> On Feb 19, 2008 9:38 PM, hewei &
uery, and the explain output, and then we can help
> you.
>
> On Feb 19, 2008 7:38 PM, hewei <[EMAIL PROTECTED]> wrote:
> > Hi,Every body;
> >I have a table contains 100,000 rows, and has a primary key(int).
> > Now ,I need to execute sql command like "up
Hi,Every body;
I have a table contains 100,000 rows, and has a primary key(int).
Now ,I need to execute sql command like "update .. where id=*"(id
is primary key).
I expect execute 1200-1600 sqlcommands per second(1200-1600/s).
In test,when the id increase by degrees in sqlcommands
Can send email from stored procedure in Postgres?
