finecur wrote:
Hi, I am ruuning a database behind a webserver and there is a table
which is huge. I need to pull data from this table and send to user
through http. If I use
select * from huge_table where userid = 100
It will return millions of records which exhuasts my server's memory.
Is there a better way to do this?
Consider using database cursors. Set up by beginning a transaction and
issuing the statement:
DECLARE huge_table_curs CURSOR FOR
SELECT * FROM huge_table WHERE userid = 100;
... then to get results, just execute:
FETCH 1000 FROM huge_table_curs;
--
Craig Ringer
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
