On 1æ19æ, äå10æ39å, Kevin.Gritt...@xxxxxxxxxxxx ("Kevin Grittner")
wrote:
> Filip Rembia*kowski<plk.zu...@xxxxxxxxx> wrote:
> > 2011/1/19 Charles.Hou <giveme...@xxxxxxxxx>:
> >> " select * from mybook" SQL command also increase the XID ?
>
> > Yes. Single SELECT is a transaction. Hence, it needs a transaction
> > ID.
>
> No, not in recent versions of PostgreSQL. ÂThere's virtual
> transaction ID, too; which is all that's needed unless the
> transaction writes something.
>
my postgresql version is 8.1.3
you means the newer version has a virtual transaction ID. and what's
the maxmium of this virtual id, also 4 billion ?
should i also vacuum freeze the virtual id in the new version when it
reached the 4 billion?
> Also, as a fine point, if you use explicit database transactions
> (with BEGIN or START TRANSACTION) then you normally get one XID for
> the entire transaction, unless you use SAVEPOINTs.
>
> -Kevin
>
> --
> Sent via pgsql-performance mailing list (pgsql-performa...@xxxxxxxxxxxxxx)
> To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-performance
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
