Re: MVCC feature of postgresql

[Raghavendra <raghavendra.rao@xxxxxxxxxxxxxxxx>]

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

Blog: http://raghavt.blogspot.com/

On Sun, Oct 23, 2011 at 9:01 AM, AI Rumman <rummandba@xxxxxxxxx> wrote:

Is there any tools by which I can test out the MVCC feature of postgresql?