Re: Upgrade questions

From: Carson Gross <carsongross(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Upgrade questions
Date: 2012-03-13 16:43:16
Message-ID: CAO92UoH-o1d_E2bZAHxAUP5RWD=mpi=i_fhqiNc-EJMG7gVfYw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)hogranch(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jim Ostler 2012-03-13 16:49:34 Re: Matching on keyword or phrases within a field that is delimited with an "or" operator "|"
Previous Message Scott Marlowe 2012-03-13 16:23:15 Re: Allowing Other Users to Alter a Table