Re: Re: is PG able to handle a >500 GB Database?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Re: is PG able to handle a >500 GB Database?
Дата
Msg-id 14352.980202914@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: is PG able to handle a >500 GB Database?  (Florent Guillaume <efgeor@noos.fr>)
Ответы Re: Re: is PG able to handle a >500 GB Database?
Re: Re: is PG able to handle a >500 GB Database?
Список pgsql-general
Florent Guillaume <efgeor@noos.fr> writes:
> If, however, like someone else on this list, you have an application
> that does 200 requests per second, and that each request generates two
> updates, that's 1440000 oids consumed per hour, 34560000 per day,
> 12614400000 per year, oops that's more than 2^32, oids have wrapped
> around nearly three times in the year...

Updates do not consume OIDs ... only insertions of *new* rows consume
OIDs ... that may or may not matter here ...

            regards, tom lane

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: optimizing "between" queries
Следующее
От: Florent Guillaume
Дата:
Сообщение: Re: Re: is PG able to handle a >500 GB Database?