| From: | Juan José Santamaría Flecha <juanjo(dot)santamaria(at)gmail(dot)com> |
|---|---|
| To: | Daniel Gustafsson <daniel(at)yesql(dot)se> |
| Cc: | rishavjainrj1998(at)gmail(dot)com, PostgreSQL mailing lists <pgsql-bugs(at)lists(dot)postgresql(dot)org> |
| Subject: | Re: BUG #16453: Not able to load a 10gb file. |
| Date: | 2020-05-19 14:22:00 |
| Message-ID: | CAC+AXB3R1F-hXExmW9NONTU=BJ3OqERmfpL9zRstZ+QhKuKGqw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-bugs |
On Tue, May 19, 2020 at 4:15 PM Daniel Gustafsson <daniel(at)yesql(dot)se> wrote:
> > While loading a 10gb file it is giving unknown error but at the same
> time a
> > sample .csv file out of that is working fine what should i do?
> > Please help its urgent.
>
> You could start by posting the actual error message you're encountering,
> the
> offending row in the CSV (if possible) and the target table definition.
> Without any details on the error there is little anyone can do to help.
>
> It's also quite likely that this isn't a bug in postgres, but an issue
> with the
> data, and if so then pgsql-general@ is a good mailinglist for getting
> help.
>
The handling of large files in Windows is a known issue [1]. Being an
urgent matter I would recommend you split the file in smaller chunks.
[1] https://commitfest.postgresql.org/28/2189/
Regards,
Juan José Santamaría Flecha
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2020-05-19 15:32:39 | Re: [bug] Table not have typarray when created by single user mode |
| Previous Message | Daniel Gustafsson | 2020-05-19 14:14:51 | Re: BUG #16453: Not able to load a 10gb file. |