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
:
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 work in this scenario.
Pretty much the same way any database would. it's likely
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 [EMAIL PROTECTED] wrote:
Hi
, 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 update .. where
id=*(id
is primary key).
I expect
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?