Postgres Pro
Downloads
Home   >   mailing lists

Re: Upgrade questions - Mailing list pgsql-general

From Carson Gross
Subject Re: Upgrade questions
Date
Msg-id CAO92UoH-o1d_E2bZAHxAUP5RWD=mpi=i_fhqiNc-EJMG7gVfYw@mail.gmail.com
Whole thread Raw
In response to Re: Upgrade questions  (John R Pierce <pierce@hogranch.com>)
Responses Re: Upgrade questions
List pgsql-general
Tree view
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 by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: Allowing Other Users to Alter a Table
Next
From: Jim Ostler
Date:
Subject: Re: Matching on keyword or phrases within a field that is delimited with an "or" operator "|"