Re: perf problem with huge table

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(at)gmail(dot)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
>
>