Re: Upgrade questions

Поиск
Список
Период
Сортировка
От Carson Gross
Тема Re: Upgrade questions
Дата
Msg-id CAO92UoH-o1d_E2bZAHxAUP5RWD=mpi=i_fhqiNc-EJMG7gVfYw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Upgrade questions  (John R Pierce <pierce@hogranch.com>)
Ответы Re: Upgrade questions  (Carson Gross <carsongross@gmail.com>)
Список pgsql-general
John,

Thanks, I'll clarify my language around that.

Still hoping that there is a way to get a rough estimate of how long converting an integer column to a bigint will take.  Not possible?

Thanks guys,
Carson

On Mon, Mar 12, 2012 at 6:13 PM, John R Pierce <pierce@hogranch.com> wrote:
On 03/12/12 5:01 PM, Carson Gross wrote:

We are also considering sharding the table and maybe the right thing is to simply fix it when we do the sharding.

postgres generally calls that partitioning...   Sharding usually means splitting data across multiple servers.




--
john r pierce                            N 37, W 122
santa cruz ca                         mid-left coast


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

В списке pgsql-general по дате отправления:

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: Allowing Other Users to Alter a Table
Следующее
От: Jim Ostler
Дата:
Сообщение: Re: Matching on keyword or phrases within a field that is delimited with an "or" operator "|"