From: | Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com> |
---|---|
To: | Marcos Barreto de Castro <mbdecastro(at)yahoo(dot)com> |
Cc: | pgsql-general(at)hub(dot)org |
Subject: | Re: Queries using the C API |
Date: | 2000-05-16 15:16:05 |
Message-ID: | 39216635.3124217B@cupid.suninternet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Marcos Barreto de Castro wrote:
> My questions are: Is there a skip function in
> Postgresql that I can use to browse through the
> records in a table forwards and backwards (That table
> has 50,000 records)? If not, how would I be able to
> develop
> such a mechanism as the one explained above? Are there
> examples of existing algorithms or even functions,
> libraries of functions fit for the job? Are there
> examples of free software developed using the
> Postgresql C API? If so, where can I find them?
I may be way off base but have you looked into CURSORs?
Apparently they can create a snapshot of the database
and then allow you to browse backwards and forwards
through it (FETCH i beleive).
I currently thinking of using this to solve the problem
I'm having with pg_dump dumping a 400,000 row table and
chewing all of system memory doing it.
--
Martijn van Oosterhout <kleptog(at)cupid(dot)suninternet(dot)com>
http://cupid.suninternet.com/~kleptog/
From | Date | Subject | |
---|---|---|---|
Next Message | Samuel A. Mullen | 2000-05-16 15:19:59 | ODBC Question for 7.0 |
Previous Message | Travis Bauer | 2000-05-16 15:05:49 | array data types and performance |