Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Subject: Re: The fastest way to update thousands of rows in moderately sized table
From: twoflower <standa.kurik@xxxxxxxxx>
Date: Fri, 24 Jul 2015 01:36:05 -0700 (MST)
In-reply-to: <CACudzGh5y_ikE3imvUFE2gd+RCNU9LO6LyjakRzmWsQ7hvKj3g@mail.gmail.com>

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.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

References:
- The fastest way to update thousands of rows in moderately sized table
  - From: twoflower
- Re: The fastest way to update thousands of rows in moderately sized table
  - From: Adrian Klaver
- Re: The fastest way to update thousands of rows in moderately sized table
  - From: twoflower
- Re: Re: The fastest way to update thousands of rows in moderately sized table
  - From: 林士博
- Re: The fastest way to update thousands of rows in moderately sized table
  - From: twoflower
- Re: Re: The fastest way to update thousands of rows in moderately sized table
  - From: 林士博
- Re: The fastest way to update thousands of rows in moderately sized table
  - From: twoflower
- Re: Re: The fastest way to update thousands of rows in moderately sized table
  - From: 林士博
- Re: The fastest way to update thousands of rows in moderately sized table
  - From: twoflower
- Re: Re: The fastest way to update thousands of rows in moderately sized table
  - From: 林士博

Prev by Date: Re: Re: The fastest way to update thousands of rows in moderately sized table
Next by Date: Re: Re: The fastest way to update thousands of rows in moderately sized table
Previous by thread: Re: Re: The fastest way to update thousands of rows in moderately sized table
Next by thread: Re: Re: The fastest way to update thousands of rows in moderately sized table
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Jobs] [Postgresql Admin] [Postgresql Performance] [Linux Clusters] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Books] [PHP Databases] [Postgresql & PHP] [Yosemite]