In my environment which is linux on the server side and both windows and
linux on the client side I have noticed that the introduction of pg_notify
(with payload) makes the size of the postgres processes on the server side
increase much more than before I used the notifiy calls. My server
inte
e('$name')") ;
$sth->execute();
}
print "Testing notify memory consumption..." ;
$handle->do("DELETE FROM mynames") ;
my $count = 1;
&insertName("Donald Duck");
while ($count == 1) {
&updateName("Donald Duck");
}
$handle-&
Thank you very much for your fast answers (both Tom and Merlin), I really appreciate it.
Do I have to send a proper bug report for this?
We have this problem in our product now, so I volunteer to test a patch :-)
Best regards,
Per-Olov Esgård-Tom Lane wrote: -
To: Per-Olov Esgard
The patch seemed to work for me too.
Thanks.
Regards, Per-Olov Esgård
From: Tom Lane
To: Per-Olov Esgard
Cc: Merlin Moncure , pgsql-general@postgresql.org
Date: 05/27/2011 06:19 PM
Subject:Re: [GENERAL] Is there any problem with pg_notify and
memory consumption?
I
