From: | Ron Johnson <ron(dot)l(dot)johnson(at)cox(dot)net> |
---|---|
To: | PgSQL Performance ML <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: Selecting random rows efficiently |
Date: | 2003-08-30 16:18:25 |
Message-ID: | 1062260304.669.566.camel@haggis |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-performance |
On Sat, 2003-08-30 at 09:01, Rod Taylor wrote:
> > i was hoping there was some trickery with sequences that would allow me to
> > easily pick a random valid sequence number..?
>
> I would suggest renumbering the data.
>
> ALTER SEQUENCE ... RESTART WITH 1;
> UPDATE table SET pkey = DEFAULT;
>
> Of course, PostgreSQL may have trouble with that update due to
> evaluation of the unique constraint immediately -- so drop the primary
> key first, and add it back after.
And if there are child tables, they'd all have to be updated, too.
--
-----------------------------------------------------------------
Ron Johnson, Jr. ron(dot)l(dot)johnson(at)cox(dot)net
Jefferson, LA USA
"Whatever may be the moral ambiguities of the so-called
demoratic nations and however serious may be their failure to
conform perfectly to their democratic ideals, it is sheer moral
perversity to equate the inconsistencies of a democratic
civilization with the brutalities which modern tyrannical states
practice."
Reinhold Nieburhr, ca. 1940
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2003-08-30 16:33:42 | Re: FE/BE Protocol - Specific version |
Previous Message | Andrew Dunstan | 2003-08-30 16:15:48 | Re: massive quotes? |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2003-08-30 16:19:42 | Re: How to force Nested Loop plan? |
Previous Message | Rob Nagler | 2003-08-30 15:47:02 | Re: How to force Nested Loop plan? |