Re: What's the XID?

From: Guillaume Lelarge <guillaume(at)lelarge(dot)info>
To: "ivan(dot)hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: What's the XID?
Date: 2008-01-03 07:54:53
Message-ID: 477C94CD.2070607@lelarge.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

ivan.hou wrote:
> how do u know this theory ? 1 + (2 * number of columns in the SELECT)
> just try & test?

I did this at first, yes. I changed log_statement to all, reload the
configuration, and voila. I've seen that pgAdmin's query tool executes
this number of queries to display the result.

> or have any document?

After I did a few tests, I get a look at the source. There's no other
documents, as far as I know, about this.

Regards.

--
Guillaume.
http://www.postgresqlfr.org
http://dalibo.com

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message giuseppe.derossi 2008-01-03 09:11:05 dynamic name of table in select
Previous Message Anoo Sivadasan Pillai 2008-01-03 07:50:45 Windows Evenlog entry - How to Control?