Postgres Pro
Downloads
Home   >   mailing lists

Re: The fastest way to update thousands of rows in moderately sized table - Mailing list pgsql-general

From twoflower
Subject Re: The fastest way to update thousands of rows in moderately sized table
Date
Msg-id 1437685250817-5859148.post@n5.nabble.com
Whole thread Raw
In response to Re: The fastest way to update thousands of rows in moderately sized table  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: Re: The fastest way to update thousands of rows in moderately sized table  (林士博 <lin@repica.co.jp>)
List pgsql-general
Tree view
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: Re: The fastest way to update thousands of rows in moderately sized table
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

pgsql-general by date:

Previous
From: Tim Clarke
Date:
Subject: Re: Using the database to validate data
Next
From: Mephysto
Date:
Subject: Re: Backup fatal issue