| From: | Raghavendra <raghavendra(dot)rao(at)enterprisedb(dot)com> |
|---|---|
| To: | AI Rumman <rummandba(at)gmail(dot)com> |
| Cc: | pgsql-general General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: MVCC feature of postgresql |
| Date: | 2011-10-23 03:53:05 |
| Message-ID: | CA+h6AhiWVX8V27eMus3hvhXHWNxnXryA52Ky60zGgJDKx2JHJw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
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?
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2011-10-23 03:57:35 | Re: MVCC feature of postgresql |
| Previous Message | AI Rumman | 2011-10-23 03:31:09 | MVCC feature of postgresql |