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 1437726965909-5859205.post@n5.nabble.com
Whole thread Raw
In response to Re: Re: The fastest way to update thousands of rows in moderately sized table  (林士博 <lin@repica.co.jp>)
List pgsql-general
Tree view
In fact I did not partition by fk_job but by the id (primary key) instead though partitioning by fk_job was my first idea.

I use various columns when querying the table, fk_job is not always there.
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: 林士博
Date:
Subject: Re: Re: The fastest way to update thousands of rows in moderately sized table
Next
From: 林士博
Date:
Subject: Re: Re: The fastest way to update thousands of rows in moderately sized table