Tom,
I've also got a customer getting this error message.
the OS is OSX 10.3 they are using plpgsql, and shared buffers is set
very low
shared_buffers = 16
Dave
On 3-Jan-07, at 10:19 AM, Tom Lane wrote:
hubert depesz lubaczewski [EMAIL PROTECTED] writes:
and - after some time of
Dave Cramer [EMAIL PROTECTED] writes:
I've also got a customer getting this error message.
the OS is OSX 10.3 they are using plpgsql, and shared buffers is set
very low
shared_buffers = 16
Well, the answer to that is if it hurts, don't do that. You couldn't
expect to process more than a
On 1/3/07, Richard Huxton dev@archonet.com wrote:
hubert depesz lubaczewski wrote:
On 1/3/07, Richard Huxton dev@archonet.com wrote:
If you do that separately at the start of the process, (one query per
custom column in the old table) then it becomes straightforward.
no, because meaning
On 1/3/07, Richard Huxton dev@archonet.com wrote:
my questions are:
1. is it a bug and will it be fixed?
2. if it is a bug - is it in hstore? plperl? my code?
My guess would be that plperl isn't freeing it's result set storage
until the end of the transaction. Might not be classed as a bug,
hubert depesz lubaczewski [EMAIL PROTECTED] writes:
and - after some time of this create table, postmaster process eats all
the memory (over 1.8g), and dies with:
psql:133.sql:125: ERROR: error from Perl function: no unpinned buffers
available at line 5.
Could you reduce this to a
On 1/3/07, Richard Huxton dev@archonet.com wrote:
If you do that separately at the start of the process, (one query per
custom column in the old table) then it becomes straightforward.
no, because meaning of col1 in advert_custom_fields is different for each
record.
for one record it's
On 1/3/07, Tom Lane [EMAIL PROTECTED] wrote:
Could you reduce this to a self-contained example please? Your
functions depend on a bunch of tables that you have not provided
definitions or data for ...
i'll try. it will take some time though.
hubert
--
http://www.depesz.com/ - nowy, lepszy