| 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: | Whole Thread | Raw Message | 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? |