On Mon, 1 Dec 2003, ow wrote:
> > --- Tom Lane <[EMAIL PROTECTED]> wrote:
> > Actually you can only have 4 billion SQL commands per xid, because the
> > CommandId datatype is also just 32 bits. I've never heard of anyone
> > running into that limit, though.
> >
>
> Wouldn't the above put a limit on a number of records one could have in table?
> One have to use pg_dump/pg_restore to be able to upgrade between pgSql releases
> and/or to backup data. If one cannot backup data and/or upgrade between pg
> releases, then 4B records is the effective limit on the number of records in
> pgSql ... or am I missing something?
I'd expect copy to be a single command, no matter how many rows were
copied.
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
