Re: Max number of rows in a table
От | Stephan Szabo |
---|---|
Тема | Re: Max number of rows in a table |
Дата | |
Msg-id | 20031201080822.D45949@megazone.bigpanda.com обсуждение исходный текст |
Ответ на | Max number of rows in a table (ow <oneway_111@yahoo.com>) |
Ответы |
Re: Max number of rows in a table
|
Список | pgsql-hackers |
On Mon, 1 Dec 2003, ow wrote: > > --- Tom Lane <tgl@sss.pgh.pa.us> 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.
В списке pgsql-hackers по дате отправления: