MVCC feature of postgresql
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@gmail.com> wrote:
Show quoted text
Is there any tools by which I can test out the MVCC feature of postgresql?
On Sat, Oct 22, 2011 at 9:31 PM, AI Rumman <rummandba@gmail.com> wrote:
Is there any tools by which I can test out the MVCC feature of postgresql?
The best tool is psql. Just open up two or more sessions and
experiment with transactions, transaction isolation levels and update
/ insert / delete / select and see how it works.