Nykolyn, Andrew wrote: > My real issue is not that I need subtransactions but I need to flush the > buffer so that I can regain memory for my stored procedure to complete > without getting a memory error.
Please don't top-post. Normal operation does not "fill buffers", thus they don't need any flushing. There must be something weird about what your SP is doing. Can we see it? Are you maybe opening and keeping half-scanned a lot of cursors? If not, can you explain in much detail what it is doing? -- Alvaro Herrera http://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
