Re: Is there a batch/bulk UPDATE syntax available?

Here is my UPDATE query and EXPLAIN ANALYZE output:

UPDATE query:
UPDATE MYUPDATETABLE SET ABOOLEANCOLUMN = TRUE WHERE COMPANYID = 999 AND
EMAIL1 = 'someemail(at)somedomain(dot)com'

EXPLAIN ANALYZE output:
Bitmap Heap Scan on myupdatetable (cost=190.89..16107.70 rows=45
width=1826) (actual time=31.150..31.155 rows=2 loops=1)
Recheck Cond: (companyid = 999::numeric)
Filter: ((email1)::text = 'someemail(at)somedomain(dot)com'::text)
-> Bitmap Index Scan on mut_cmpid_indx (cost=0.00..190.88 rows=9051
width=0) (actual time=13.868..13.868 rows=60206 loops=1)
Index Cond: (companyid = 999::numeric)
Total runtime: 31.319 ms

-----Original Message-----
From: pasman pasmanski [mailto:pasman(dot)p(at)gmail(dot)com]
Sent: Friday, February 04, 2011 2:01 AM
To: gnanam(at)zoniac(dot)com
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] Is there a batch/bulk UPDATE syntax available?

Show us explain analyze for this update.

2011/2/3, Gnanakumar <gnanam(at)zoniac(dot)com>:
> Hi,
>
> Is there a batch/bulk UPDATE query syntax available in PostgreSQL, similar
> to multirow VALUES syntax available for INSERT?
>
> INSERT Multirow VALUES syntax example:
> INSERT INTO films (code, title, did, date_prod, kind) VALUES
> ('B6717', 'Tampopo', 110, '1985-02-10', 'Comedy'),
> ('HG120', 'The Dinner Game', 140, DEFAULT, 'Comedy');
>
> There is a situation in my application, where I am performing lots and
lots
> of updates on individual rows. I am trying to figure out how to make the
> updates faster.
>
> Any other ideas/ways to make updates faster are highly appreciated.
>
> Regards,
> Gnanam
>
>
> --
> Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
>

--
------------
pasman