Re: MVCC feature of postgresql - Mailing list pgsql-general

From Raghavendra
Subject Re: MVCC feature of postgresql
Date
Msg-id CA+h6AhiWVX8V27eMus3hvhXHWNxnXryA52Ky60zGgJDKx2JHJw@mail.gmail.com
Whole thread Raw
In response to MVCC feature of postgresql  (AI Rumman <rummandba@gmail.com>)
List pgsql-general
Good way to understand MVCC feature is XID(transaction-id) and with the help of hidden columns prefixed for each row in a table. 
You need to test with doing DML(update/Delete/Insert) statements by opening multiple sessions to know about MVCC feature.

Eg:-
select xmin,xmax,cmin,cmax,ctid, * from <tablename>;

---
Regards,
Raghavendra
EnterpriseDB Corporation



On Sun, Oct 23, 2011 at 9:01 AM, AI Rumman <rummandba@gmail.com> wrote:
Is there any tools by which I can test out the MVCC feature of postgresql?

pgsql-general by date:

Previous
From: AI Rumman
Date:
Subject: MVCC feature of postgresql
Next
From: Scott Marlowe
Date:
Subject: Re: MVCC feature of postgresql