Re: [HACKERS] Is it necessary to rewrite table while increasing the scale of datatype numeric?

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: wangshuo(at)highgo(dot)com(dot)cn
Cc: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: [HACKERS] Is it necessary to rewrite table while increasing the scale of datatype numeric?
Date: 2013-09-04 15:41:03
Message-ID: CAMkU=1zCgTdhXAMTf9jL9sdA3Gi+a1C4CVcrt8iXXFtbAHL52g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Tue, Sep 3, 2013 at 9:08 PM, <wangshuo(at)highgo(dot)com(dot)cn> wrote:
> Hi, Hackers!
>
> I find that it takes a long time when I increase the scale of a numeric
> datatype.
> By checking the code, I found that's because it needs to rewrite that
> table's file.
> After checking that table's data file, I found only parameter n_header
> changed.
> And, I found the data in that numeric field never changed.
> So I thank It's not necessary to rewrite the table's file in this case.
>
> Anyone has more idea about this, please come to talk about this!

This was fixed in version 9.2. You must be using an older version.

Cheers,

Jeff

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Kohei KaiGai 2013-09-04 15:46:53 Re: [v9.4] row level security
Previous Message Tom Lane 2013-09-04 15:32:46 Re: [9.4] Make full_page_writes only settable on server start?