Postgres Pro
Downloads
Home   >   mailing lists

Thread: MVCC feature of postgresql

MVCC feature of postgresql

From
AI Rumman
Date:
Is there any tools by which I can test out the MVCC feature of postgresql?

Re: MVCC feature of postgresql

From
Raghavendra
Date:
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?

Re: MVCC feature of postgresql

From
Scott Marlowe
Date:
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.