От: Kevin Grittner
Тема: Re: the XID question
Дата: ,
Msg-id: 4D3816DB02000025000398DF@gw.wicourts.gov
(см: обсуждение, исходный текст)
Ответ на: Re: the XID question  ("Charles.Hou")
Ответы: Re: the XID question  (Robert Haas)
Список: pgsql-performance

Скрыть дерево обсуждения

the XID question  ("Charles.Hou", )
 Re: the XID question  ("Charles.Hou", )
 Re: the XID question  (Filip Rembiałkowski, )
  Re: the XID question  ("Kevin Grittner", )
 Re: the XID question  (Chris Browne, )
  Re: the XID question  (Andres Freund, )
   Re: the XID question  ("Kevin Grittner", )
    Re: the XID question  (Greg Smith, )
 Re: the XID question  ("Charles.Hou", )
  Re: the XID question  ("Kevin Grittner", )
   Re: the XID question  (Robert Haas, )
 Re: the XID question  ("Charles.Hou", )

"Charles.Hou" <> wrote:

> my postgresql version is 8.1.3

Ouch!  That's getting pretty old; I hope it's not on Windows.

http://wiki.postgresql.org/wiki/PostgreSQL_Release_Support_Policy

http://www.postgresql.org/about/news.865

> 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?

The point is to reduce maintenance, not increase it -- you don't
need to worry about cleaning these up.

-Kevin


В списке pgsql-performance по дате сообщения:

От: Tom Lane
Дата:
Сообщение: Re: copy command and blobs
От: Robert Haas
Дата:
Сообщение: Re: "NOT IN" substantially slower in 9.0.2 than 8.3.13 - NOT EXISTS runs fast in both 8.3.13 and 9.0.2