Is it necessary to rewrite table while increasing the scale of datatype numeric？

From: wangshuo(at)highgo(dot)com(dot)cn
To: Pgsql Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Is it necessary to rewrite table while increasing the scale of datatype numeric？
Date: 2013-09-04 04:08:48
Message-ID: c48a5ba3a044907d58872adb932ee079@highgo.com.cn
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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!

Best Regards!

Yours,
Wang Shuo
HighGo Software Co.,Ltd.
September 4, 2013

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tsunakawa, Takayuki 2013-09-04 04:11:09 [tiny doc fix] statistics are not retained across immediate shutdown
Previous Message Alvaro Herrera 2013-09-04 04:07:54 Re: [rfc] overhauling pgstat.stat