| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
| Cc: | Andrew Chernow <ac(at)esilo(dot)com>, Pavel Golub <pavel(at)gf(dot)microolap(dot)com>, Pavel Golub <pavel(at)microolap(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>, pgsql-interfaces <pgsql-interfaces(at)postgresql(dot)org> |
| Subject: | Re: [HACKERS] PQdeleteTuple function in libpq |
| Date: | 2011-06-02 15:57:23 |
| Message-ID: | 1307030194-sup-4091@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-interfaces |
Excerpts from Merlin Moncure's message of jue jun 02 11:33:28 -0400 2011:
> On Thu, Jun 2, 2011 at 10:02 AM, Alvaro Herrera
> <alvherre(at)commandprompt(dot)com> wrote:
> > Seems pretty wasteful if you want to delete a single tuple from a large
> > result. I think if you desired to compact the result to free some
> > memory after deleting a large fraction of the tuples in the result it
> > could be useful to do that, otherwise just live with the unused holes in
> > the storage area as suggested by Pavel.
>
> That would work, but it would potentially invalidate external pointers
> to internal result data. If you wanted to do this, it might be better
> to expose a compaction feature which can be invoked directly.
Wouldn't that also invalidate external pointers?
--
Álvaro Herrera <alvherre(at)commandprompt(dot)com>
The PostgreSQL Company - Command Prompt, Inc.
PostgreSQL Replication, Consulting, Custom Development, 24x7 support
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Dunstan | 2011-06-02 15:59:02 | Re: Please test peer (socket ident) auth on *BSD |
| Previous Message | Merlin Moncure | 2011-06-02 15:33:28 | Re: PQdeleteTuple function in libpq |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Merlin Moncure | 2011-06-02 16:05:47 | Re: PQdeleteTuple function in libpq |
| Previous Message | Merlin Moncure | 2011-06-02 15:33:28 | Re: PQdeleteTuple function in libpq |