| From: | Tod McQuillin <devin(at)spamcop(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Lee Joramo <lee(dot)list(at)joramo(dot)com>, rob <rob(at)cabrion(dot)com>, postgre general list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly |
| Date: | 2001-01-10 01:11:20 |
| Message-ID: | Pine.GSO.4.31.0101091909530.333-100000@sysadmin |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 9 Jan 2001, Tom Lane wrote:
> -S suppresses all log output, so first you need to get rid of that.
The postgres.1 man page from postgresql-7.0.3/doc/man.tar.gz says:
-S SortSize
Specifies the amount of memory to be used by inter-
nal sorts and hashes before resorting to temporary
disk files. The value is specified in kilobytes,
and defaults to 512 kilobytes. Note that for a com-
plex query, several sorts and/or hashes might be
running in parallel, and each one will be allowed
to use as much as SortSize kilobytes before it
starts to put data into temporary files.
Who is right?
--
Tod McQuillin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2001-01-10 01:16:00 | Re: Re: COPY error: pqReadData() -- backend closed the channel unexpectedly |
| Previous Message | Tom Lane | 2001-01-10 00:56:30 | Re: "Cluster" means "tangle" for me |