Re: The fastest way to update thousands of rows in moderately sized table

From: twoflower <standa(dot)kurik(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: The fastest way to update thousands of rows in moderately sized table
Date: 2015-07-23 21:00:50
Message-ID: 1437685250817-5859148.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver-4 wrote
> Have you tried wrapping the above in a BEGIN/COMMIT block?

Yes, I am running the tests inside a BEGIN TRANSACTION / ROLLBACK block.

--
View this message in context: http://postgresql.nabble.com/The-fastest-way-to-update-thousands-of-rows-in-moderately-sized-table-tp5859144p5859148.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mephysto 2015-07-23 21:26:12 Re: Backup fatal issue
Previous Message Tim Clarke 2015-07-23 20:58:21 Re: Using the database to validate data