Postgres Pro
Downloads
Home   >   mailing lists

Is it necessary to rewrite table while increasing the scale ofdatatype numeric？ - Mailing list pgsql-hackers

From wangshuo@highgo.com.cn
Subject Is it necessary to rewrite table while increasing the scale ofdatatype numeric？
Date
Msg-id c48a5ba3a044907d58872adb932ee079@highgo.com.cn
Whole thread Raw
Responses Re: Is it necessary to rewrite table while increasing the scale of datatype numeric???
Re: [HACKERS] Is it necessary to rewrite table while increasing the scale of datatype numeric？
List pgsql-hackers
Tree view 
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

pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: [rfc] overhauling pgstat.stat
Next
From: "Tsunakawa, Takayuki"
Date:
Subject: [tiny doc fix] statistics are not retained across immediate shutdown