| From: | Piyush <piyushnewe(at)gmail(dot)com> |
|---|---|
| To: | pgsql-in-general(at)lists(dot)postgresql(dot)org |
| Subject: | Pg Server-side-cursors |
| Date: | 2021-09-06 10:59:04 |
| Message-ID: | CAMa94Aj83Bbb_6vejcdWkVnZZEBNeuhS6-jTxgKv=ddn4od_Tg@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | Postg토토 결과SQL : Postg토토 |
Hello,
When executing the query which returns billions of records, the server-side
cursor holds the records in memory or keeps those in temp-table/file ?
e.g.
select * from LINEITEM order by L_ORDERKEY desc;
Can somebody help me to understand this ?
-Piyush
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Anitha P | 2021-10-08 07:34:14 | Fwd: PostgreSQL 12 Authentication type questions |
| Previous Message | Rui DeSousa | 2020-12-03 18:45:33 | Re: time taking deletion on large tables |