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)
Список
Дерево обсуждения
perf problem with huge table rama <rama.rama@tiscali.it>
Re: perf problem with huge table Justin Graf <justin@magwerks.com>
Re: perf problem with huge table Greg Smith <greg@2ndquadrant.com>
Re: perf problem with huge table jesper@krogh.cc
Re: perf problem with huge table Dave Crooke <dcrooke@gmail.com>
Re: perf problem with huge table Jon Lewison <jlewison1@gmail.com>
Re: perf problem with huge table Dave Crooke <dcrooke@gmail.com>
Re: perf problem with huge table Leo Mannhart <leo.mannhart@beecom.ch>
Re: perf problem with huge table Jon Lewison <jlewison1@gmail.com>
Re: perf problem with huge table Dave Crooke <dcrooke@gmail.com>
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.
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 по дате отправления
