Toby Corkindale <toby.corkindale@xxxxxxxxxxxxxxxxxxxx> writes: > On 26/04/12 13:11, Tom Lane wrote: >> Well, if you were to provide a reproducible test case, somebody might be >> motivated to look into it. There could be a memory leak in the planner >> somewhere, but without a test case it's not very practical to go look >> for it. > Would a Perl-based script that built up a database like that be a useful > test case for you? Yeah, sure, just something that somebody else can run to duplicate the problem. > For what it's worth, I discovered something quite interesting. The > memory usage only blows out when I do an update based on the results of > the query. Hm, is the update target an inheritance tree? regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
