Postgres Pro
Downloads
Home   >   mailing lists

Getting a random row - Mailing list pgsql-performance

From Shaul Dar
Subject Getting a random row
Date
Msg-id 234efe30910130817x299cf3d8wbf35386659bd94f@mail.gmail.com
Whole thread Raw
Responses Re: Getting a random row
Re: Getting a random row
Re: Getting a random row
List pgsql-performance
Tree view
Hi,

I am running performance simulation against a DB. I want to randomly pull different records from a large table. However the table has no columns that hold sequential integer values (1..MAX), i.e. the columns all have "holes" (due to earlier filtering). Also PG does not have a concept of an auto-increment pseudo-column like Oracle's "rownum". Any suggestions?

Thanks,

-- Shaul

pgsql-performance by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2?
Next
From: Grzegorz Jaśkiewicz
Date:
Subject: Re: Getting a random row