Postgres Pro
Downloads
Home   >   mailing lists

Re: SELECTing every Nth record for better performance - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: SELECTing every Nth record for better performance
Date
Msg-id 2f4958ff0912040226h6a822046o8acbef242ae1352a@mail.gmail.com
Whole thread Raw
In response to Re: SELECTing every Nth record for better performance  (Ivan Voras <ivoras@freebsd.org>)
List pgsql-general
Tree view
why create another table, straightforward on 8.4:
SELECT * FROM (SELECT *, (row_number() OVER( ORDER BY id))%10 AS rn FROM table) sa WHERE sa.rn=1 LIMIT 10;

pgsql-general by date:

Previous
From: "A. Kretschmer"
Date:
Subject: Re: SELECTing every Nth record for better performance
Next
From: Greg Smith
Date:
Subject: Re: SELECTing every Nth record for better performance