Re: [HACKERS] Is it necessary to rewrite table while increasing the scale of datatype numeric? - Mailing list pgsql-hackers

From Jeff Janes
Subject Re: [HACKERS] Is it necessary to rewrite table while increasing the scale of datatype numeric?
Date
Msg-id CAMkU=1zCgTdhXAMTf9jL9sdA3Gi+a1C4CVcrt8iXXFtbAHL52g@mail.gmail.com
Whole thread Raw
In response to Is it necessary to rewrite table while increasing the scale ofdatatype numeric?  (wangshuo@highgo.com.cn)
Responses Re: Is it necessary to rewrite table while increasing thescale of datatype numeric?
List pgsql-hackers
On Tue, Sep 3, 2013 at 9:08 PM,  <wangshuo@highgo.com.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: [9.4] Make full_page_writes only settable on server start?
Next
From: Kohei KaiGai
Date:
Subject: Re: [v9.4] row level security