[GENERAL] Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"

Greetings, A function aborts with the error in the subject line despite the available free space on the disk. I have a bunch of other questions regarding the underlying reason but first things first: why is pg telling me no space is left on device when there is space? the only config param I can s

Re: [GENERAL] Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"

> Le 2014-08-10 à 06:31, Seref Arikan a écrit : > > Greetings, > A function aborts with the error in the subject line despite the available > free space on the disk. > I have a bunch of other questions regarding the underlying reason but first > things first: why is pg telling me no space is

Re: [GENERAL] Disk space available, but getting error "could not write to hash-join temporary file: No space left on device"

François, How vry stupid of me, and how kind of you to point at the obvious thing I was missing. Best regards Seref On Sun, Aug 10, 2014 at 12:40 PM, François Beausoleil wrote: > > > Le 2014-08-10 à 06:31, Seref Arikan a écrit : > > > > Greetings, > > A function aborts with the error in the

[GENERAL] pg_advisory_lock problem

Hey dear list, following the advise of Depesz I'm trying to use advisory lock. I'm trying to perform parallel upsert. I have 2 different sessions in which I run a very complicated querry (lot's of CTE) concurrently. In fact this complicated querry is simply put inside a plpgsql function for ease

Re: [GENERAL] pg_advisory_lock problem

Rémi Cura wrote > Hey dear list, > > following the advise of Depesz I'm trying to use advisory lock. > > I'm trying to perform parallel upsert. > I have 2 different sessions in which I run a very complicated querry > (lot's > of CTE) concurrently. In fact this complicated querry is simply put ins

Re: [GENERAL] pg_advisory_lock problem

- PERFORM pg_advisory_lock(#1 , 2 or 3 depending on the table#,id of the stuff I want to upsert) ; WITH stuff_to_upsert () ,updating AS (update returning id) ,inserting AS (insert if not updated) PERFORM pg_advisory_unlock(same as above). ah, you're releasing the lock before