Re: perf problem with huge table

Поиск
Список
Период
Сортировка
От Dave Crooke
Тема Re: perf problem with huge table
Дата
Msg-id ca24673e1002101651o4f522489sce83b0c9b93281b0@mail.gmail.com
обсуждение исходный текст
Ответ на Re: perf problem with huge table  (Jon Lewison <jlewison1@gmail.com>)
Список pgsql-performance
Actually, in a way it does .... "No space left on device" or similar ;-)

Cheers
Dave

P.S. for those not familiar with Oracle, ORA-01555 translates to "your query / transaction is kinda old and I've forgotten the data, so I'm just going to throw an error at you now". If you're reading, your SELECT randomly fails, if you're writing it forces a rollback of your transaction.

On Wed, Feb 10, 2010 at 6:09 PM, Jon Lewison <jlewison1@gmail.com> wrote:

Speaking of rollback segments I'm assuming that since all storage for non-visible row versions is in the main table that PostgreSQL has no equivalent for an ORA-01555.

- Jon


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

Предыдущее
От: Jon Lewison
Дата:
Сообщение: Re: perf problem with huge table
Следующее
От: Greg Smith
Дата:
Сообщение: Re: perf problem with huge table