Re: return records in DB load order??

Поиск
Список
Период
Сортировка
От Maksim Likharev
Тема Re: return records in DB load order??
Дата
Msg-id 56510AAEF435D240958D1CE8C6B1770A014A0C79@mailc03.aurigin.com
обсуждение исходный текст
Ответ на return records in DB load order??  ("Maksim Likharev" <mlikharev@aurigin.com>)
Список pgsql-general
I am pretty much understand what going to happen with int4 when it hit
2^32 + 1,
but what going to happen with PostgreSQL and that that particular
table if all rows are alive?


-----Original Message-----
From: Dann Corbit [mailto:DCorbit@connx.com]
Sent: Friday, June 13, 2003 1:37 PM
To: pgsql-general@postgresql.org
Subject: Re: [GENERAL] return records in DB load order??


> -----Original Message-----
> From: Maksim Likharev [mailto:mlikharev@aurigin.com]
> Sent: Friday, June 13, 2003 1:33 PM
> To: gearond@cvc.net
> Cc: pgsql-general@postgresql.org
> Subject: Re: [GENERAL] return records in DB load order??
>
>
> Is isn't suppose to be unique?

What happens when you have 2^32 + 1 rows in a table?  A 4 byte OID
cannot contain it.

---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

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

Предыдущее
От: weigelt@metux.de
Дата:
Сообщение: Re: using sequences
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] SAP and MySQL ... [and Benchmark]