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(at)gmail(dot)com> wrote:
> Is there any tools by which I can test out the MVCC feature of postgresql?
>