| From: | Thomas Munro <thomas(dot)munro(at)enterprisedb(dot)com> |
|---|---|
| To: | ronljohnsonjr(at)gmail(dot)com |
| Cc: | "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: What is the tuplestore? |
| Date: | 2018-12-11 00:24:01 |
| Message-ID: | CAEepm=290kPKi0Hk6kgxzxdnYUBZDLaJdETDjOR8jFZKvS2Z9Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Dec 11, 2018 at 2:56 AM Ron <ronljohnsonjr(at)gmail(dot)com> wrote:
> 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.)
Maybe the setting log_temp_files could help you identify the query
that is doing it?
https://www.postgresql.org/docs/current/runtime-config-logging.html#GUC-LOG-TEMP-FILES
--
Thomas Munro
http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2018-12-11 00:45:01 | Re: Memory exhaustion due to temporary tables? |
| Previous Message | Rene Romero Benavides | 2018-12-11 00:07:02 | Re: What is the tuplestore? |