Re: What is the tuplestore?

From: Hans Schou <hans(dot)schou(at)gmail(dot)com>
To: ronljohnsonjr(at)gmail(dot)com
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: What is the tuplestore?
Date: 2018-12-11 05:48:25
Message-ID: CAApBw35kkNwVBC5JBdL0uOgN7F=5N+CWxb_0H1O7VHvXB20Nag@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

When one get a "No space left on device" and there is a lot of space it is
sometimes caused by lack of inodes.

Try run the command:
df --inodes

On Mon, Dec 10, 2018 at 4:56 PM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:

> Hi,
>
> v9.6.6
>
>
> 2018-12-07 06:21:55.504 EST 10.140.181.89(35868) CDS CDSLBXW 13748 SELECT
> PostgreSQL JDBC Driver 53100 ERROR: could not write to tuplestore
> temporary
> file: No space left on device
>
> I see this in the pg_log file, but #1 can't figure out what "tuplestore"
> is
> (Google doesn't help), and #2 there's lots of space on all my file
> systems.
> data/base, where pgsql_tmp lives, has 96GB free.)
>
> Thanks
>
> --
> Angular momentum makes the world go 'round.
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Anton Shen 2018-12-11 06:19:51 new stored procedure with OUT parameters
Previous Message Thomas Munro 2018-12-11 05:04:18 Re: What is the tuplestore?