Postgres Pro
Downloads
Home   >   mailing lists

Re: What is the tuplestore? - Mailing list pgsql-general

From Hans Schou
Subject Re: What is the tuplestore?
Date
Msg-id CAApBw35kkNwVBC5JBdL0uOgN7F=5N+CWxb_0H1O7VHvXB20Nag@mail.gmail.com
Whole thread Raw
In response to What is the tuplestore?  (Ron <ronljohnsonjr@gmail.com>)
List pgsql-general
Tree view
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@gmail.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.

pgsql-general by date:

Previous
From: Thomas Munro
Date:
Subject: Re: What is the tuplestore?
Next
From: Anton Shen
Date:
Subject: new stored procedure with OUT parameters