| From: | Alvaro Herrera <alvherre(at)alvh(dot)no-ip(dot)org> |
|---|---|
| To: | Josh Berkus <josh(at)agliodbs(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Remove xmin and cmin from frozen tuples |
| Date: | 2005-09-01 16:26:35 |
| Message-ID: | 20050901162635.GA29941@surnet.cl |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2005-09-01 16:31:25 | Re: Version number in psql banner |
| Previous Message | Alvaro Herrera | 2005-09-01 16:25:19 | Re: Remove xmin and cmin from frozen tuples |