| From: | Greg Stark <stark(at)mit(dot)edu> |
|---|---|
| To: | aaron(at)heyaaron(dot)com |
| Cc: | PostgreSQL Bugs <pgsql-bugs(at)postgresql(dot)org> |
| Subject: | Re: BUG #13637: ~2 GB psql import fails with out of memory error on machine with 64 GB RAM |
| Date: | 2015-10-14 07:31:35 |
| Message-ID: | CAM-w4HPsW=eqisUfioOEmv8Wg1G71HxcsBhT4e2UNPivTRtn3w@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Fri, Sep 25, 2015 at 3:06 AM, <aaron(at)heyaaron(dot)com> wrote:
> It runs for a few minutes, and then I either get an out of memory error, or
> it appears to exit normally without importing the data.
>
> Thinking it was because my 'dev' server is only 512 MB, I temporarily scaled
> it up to 8 GB. Same error.
I would suggest posting the actual error. There are various errors
that can be read as "out of memory" but they're not really the same
thing. If you had free memory on the machine then which error it was
specifically might be important. Also Postgres prints more information
than just "out of memory" and that additional context could be
helpful.
--
greg
| From | Date | Subject | |
|---|---|---|---|
| Next Message | i.frolkov | 2015-10-14 09:58:31 | BUG #13679: Planer chooses not optimal plan |
| Previous Message | Pavel Stehule | 2015-10-14 04:53:17 | Re: BUG #13677: CPU 100% for WITH RECURSIVE CTE Queries |