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

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: [HACKERS] Is it necessary to rewrite table while increasing the scale of datatype numeric?
Дата
Msg-id CAMkU=1zCgTdhXAMTf9jL9sdA3Gi+a1C4CVcrt8iXXFtbAHL52g@mail.gmail.com
обсуждение исходный текст
Ответ на Is it necessary to rewrite table while increasing the scale ofdatatype numeric?  (wangshuo@highgo.com.cn)
Ответы Re: Is it necessary to rewrite table while increasing thescale of datatype numeric?  (wangshuo@highgo.com.cn)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [9.4] Make full_page_writes only settable on server start?
Следующее
От: Kohei KaiGai
Дата:
Сообщение: Re: [v9.4] row level security