| From: | Israel Brewster <ijbrewster(at)alaska(dot)edu> |
|---|---|
| To: | Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca> |
| Cc: | "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: UPDATE many records |
| Date: | 2020-01-07 20:58:49 |
| Message-ID: | F9677E36-0B9C-4C5C-9251-568F3CEC1827@alaska.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On Jan 7, 2020, at 11:56 AM, Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca> wrote:
>
> On Tue, 2020-01-07 at 11:47 -0900, Israel Brewster wrote:
>> One potential issue I just thought of with this approach: disk space.
>> Will I be doubling the amount of space used while both tables exist?
>> If so, that would prevent this from working - I don’t have that much
>> space available at the moment.
>
> The original update you planned would do that, too.
>
> You probably need to just do the update in batches and vacuum the table
> between batches.
>
>
Really? Why? With the update I am only changing data - I’m not adding any additional data, so the total size should stay the same, right? I’m obviously missing something… :-)
---
Israel Brewster
Software Engineer
Alaska Volcano Observatory
Geophysical Institute - UAF
2156 Koyukuk Drive
Fairbanks AK 99775-7320
Work: 907-474-5172
cell: 907-328-9145
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2020-01-07 21:01:03 | Re: UPDATE many records |
| Previous Message | Alan Hodgson | 2020-01-07 20:56:16 | Re: UPDATE many records |