Re: Single pass vacuum - take 1

Поиск
Список
Период
Сортировка
От Alvaro Herrera
Тема Re: Single pass vacuum - take 1
Дата
Msg-id 1310668936-sup-1775@alvh.no-ip.org
обсуждение исходный текст
Ответ на Re: Single pass vacuum - take 1  (Pavan Deolasee <pavan.deolasee@gmail.com>)
Список pgsql-hackers
Excerpts from Pavan Deolasee's message of jue jul 14 13:54:36 -0400 2011:
> On Thu, Jul 14, 2011 at 12:43 PM, Heikki Linnakangas <
> heikki.linnakangas@enterprisedb.com> wrote:

> > Seems odd to store relindxvacxlogid/off as two int32 columns. Store it in
> > one uint64 column, or invent a new datatype for LSNs, or store it as text in
> > %X/%X format.
> >
> >
> Yeah. I don't remember what issues I faced with uint64 column, may be did
> not get around the case where uint64 is not natively supported on the
> platform. But %X/%X looks very reasonable. Will change to that.

Where is this to be stored?

AFAIR we no longer support platforms that do not have working 64 bit
integer types.

As a column name, relindxvacxlogid seems a bit unfortunate, BTW ...

-- 
Álvaro Herrera <alvherre@commandprompt.com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Florian Pflug
Дата:
Сообщение: Re: Need help understanding pg_locks
Следующее
От: Josh Berkus
Дата:
Сообщение: Re: Allow pg_archivecleanup to ignore extensions