| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
| Cc: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "ivan(dot)hou" <ivan(dot)hou(at)msa(dot)hinet(dot)net>, pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: What's the XID? |
| Date: | 2008-01-02 11:54:35 |
| Message-ID: | 20080102115435.GB31408@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
Guillaume Lelarge wrote:
> We first send the query to the database. For each returned column, we
> send two queries. The first one gives us the type's name of the column
> and the second one gives us the OID of the base type. So, each query
> executed with pgAdmin's query tool should increase age(datfrozenxid) by :
> 1 + (2 * number of columns in the SELECT)
Ever thought of doing it all in a single transaction?
--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Guillaume Lelarge | 2008-01-02 12:57:37 | Re: What's the XID? |
| Previous Message | Glyn Astill | 2008-01-02 11:33:11 | Shutting down warm standby server? " |