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-24 08:36:05
Message-ID: 1437726965909-5859205.post@n5.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

In fact I did not partition by *fk_job* but by the *id* (primary key) instead
thoughpartitioning 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: http://postgresql.nabble.com/The-fastest-way-to-update-thousands-of-rows-in-moderately-sized-table-tp5859144p5859205.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message 林士博 2015-07-24 08:55:22 Re: Re: The fastest way to update thousands of rows in moderately sized table
Previous Message 林士博 2015-07-24 08:29:24 Re: Re: The fastest way to update thousands of rows in moderately sized table