Re: Transaction Steps!!

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: Farhan Mughal <farhanhafeezmughal(at)yahoo(dot)co(dot)uk>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Transaction Steps!!
Date: 2007-09-24 13:53:14
Message-ID: 1190641994.4181.183.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 2007-09-24 at 10:35 +0100, Farhan Mughal wrote:
>
> Can someone please tell How a simple transaction goes through various
> steps for completion in PostgreSQL. Thanks.
>

You might mean the execution steps. You can view these using EXPLAIN.

http://developer.postgresql.org/pgdocs/postgres/sql-explain.html

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2007-09-24 14:00:25 Re: SRF called with optional NULL input runs 7x slower
Previous Message Simon Riggs 2007-09-24 13:51:31 Re: DELETE FROM pg_class