Re: pg_restore and transaction id wraparound

Поиск
Список
Период
Сортировка
От ow
Тема Re: pg_restore and transaction id wraparound
Дата
Msg-id 20031129201147.94126.qmail@web21410.mail.yahoo.com
обсуждение исходный текст
Ответ на Re: pg_restore and transaction id wraparound  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
--- 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.
>

Perhaps noone yet had a table with 4B records in pgSql. Otherwise, how would
they dump/restore it?

Thanks





__________________________________
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
http://companion.yahoo.com/

В списке pgsql-admin по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: pg_restore and transaction id wraparound
Следующее
От: William Yu
Дата:
Сообщение: Re: filesystem suggestion for pg