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.
>
>
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? |