Dear all,
With the below transaction we got an out of memory error.
BEGIN;
ANALYZE referenceAuthorLnkTemp;
INSERT INTO referenceAuthor (author)
SELECT DISTINCT ON (author) author
FROM referenceAuthorLnkTemp;
ANALYZE referenceAuthor;
UPDATE referenceAuthorLnkTemp
SET
On Wed, Jun 06, 2007 at 10:57:25AM +0200, Christophe Combet PBIL/IBCP/CNRS
wrote:
> Dear all,
>
>
> With the below transaction we got an out of memory error.
Here's your problem:
> AfterTriggerEvents: 3170885632 total in 397 blocks; 12200 free (384
> chunks); 3170873432 used
You've got som
Dear all,
With the below transaction we got an out of memory error.
BEGIN;
ANALYZE referenceAuthorLnkTemp;
INSERT INTO referenceAuthor (author)
SELECT DISTINCT ON (author) author
FROM referenceAuthorLnkTemp;
ANALYZE referenceAuthor;
UPDATE referenceAuthorLnkTemp
SET
