Re: Remove xmin and cmin from frozen tuples

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Remove xmin and cmin from frozen tuples
Дата
Msg-id 20050901162635.GA29941@surnet.cl
обсуждение исходный текст
Ответ на Re: Remove xmin and cmin from frozen tuples  (Josh Berkus <josh@agliodbs.com>)
Список pgsql-hackers
On Thu, Sep 01, 2005 at 09:20:48AM -0700, Josh Berkus wrote:

> > What I'm saying is that you can write a heap file, on which the tuples
> > would all have xmin=FrozenTransactionId, xmax=Invalid, and the
> > corresponding bits set in the infomask.  This ensures that no matter the
> > state of the server, you can plug the file in and all tuples will be
> > valid.
> 
> So, bulk loading by file generation?   So the idea is that you would generate 
> a properly formatted PostgreSQL table file, and then in one transaction 
> create the table and attach it?

Exactly.

-- 
Alvaro Herrera -- Valdivia, Chile         Architect, www.EnterpriseDB.com
"Changing the world ... one keyboard at a time!"                        (www.DVzine.org)


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

Предыдущее
От: Darcy Buskermolen
Дата:
Сообщение: Re: Version number in psql banner
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Remove xmin and cmin from frozen tuples