Transaction Steps!!

Started by Farhan Mughalover 18 years ago3 messagesgeneral
Jump to latest
#1Farhan Mughal
farhanhafeezmughal@yahoo.co.uk

Can someone please tell How a simple transaction goes through various steps for completion in PostgreSQL. Thanks.

Regards,
Farhan

---------------------------------
Yahoo! Answers - Get better answers from someone who knows. Tryit now.

#2Rodrigo De León
rdeleonp@gmail.com
In reply to: Farhan Mughal (#1)
Re: Transaction Steps!!

On 9/24/07, Farhan Mughal <farhanhafeezmughal@yahoo.co.uk> wrote:

Can someone please tell How a simple transaction goes through various steps
for completion in PostgreSQL. Thanks.

Maybe you'll find something here:
http://www.postgresql.org/docs/8.2/static/internals.html

#3Simon Riggs
simon@2ndQuadrant.com
In reply to: Farhan Mughal (#1)
Re: Transaction Steps!!

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