Getting a random row

From: Shaul Dar <shauldar(at)gmail(dot)com>
To: pgsql-performance(at)postgresql(dot)org
Subject: Getting a random row
Date: 2009-10-13 15:17:10
Message-ID: 234efe30910130817x299cf3d8wbf35386659bd94f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2009-10-13 15:19:40 Re: Getting a random row
Previous Message Kenneth Marshall 2009-10-13 12:53:55 Re: Are folks running 8.4 in production environments? and 8.4 and slon 1.2?