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.