Re: problem about maximum row size ? - Mailing list pgsql-odbc

From Bruce Momjian
Subject Re: problem about maximum row size ?
Date
Msg-id 200604121856.k3CIuX108667@candle.pha.pa.us
Whole thread Raw
In response to Re: problem about maximum row size ?  ("Dave Page" <dpage@vale-housing.co.uk>)
List pgsql-odbc
Dave Page wrote:
> > > > FAQ updated with new number, and mention that increasing
> > block size
> > > > quadruples it.
> > >
> > > I've updated the limitations page on the website, though I didn't
> > > bother with the blocksize hack on there.
> > >
> > > Whilst we're on the subject, is 16TB for a table still
> > correct given
> > > CE partitioning?
> >
> > Uh, probably not, but do we want to require CE to increase that limit?
>
> It's worth a mention don't you think? Something like:
>
> Maximum table size: 16TB (for a partitioned table, this is the maximum
> size of each partition).

OK, FAQ updated by adding second setence:

    <P>The maximum table size, row size, and maximum number of columns
    can be quadrupled by increasing the default block size to 32k.  The
    maximum table size can also be increased using table partitioning.</P>

--
  Bruce Momjian   http://candle.pha.pa.us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

pgsql-odbc by date:

Previous
From: "Dave Page"
Date:
Subject: Re: Promoting the enhanced branch
Next
From: "Dave Held"
Date:
Subject: ODBC Drivers