Search Postgresql Archives

Re: copy losing information

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Silvela, Jaime \(Exchange\)" <JSilvela@xxxxxxxx> writes:
> I have a pretty big file, around 2 million rows, in tab-separated
> format, with 4 columns, that I read into a table in Postgres using the
> copy command.

> I've started to notice missing info sometimes. I'll truncate the table,
> read from the file, and notice that sometimes there are less rows in the
> table than in the file.

This looks a lot like Dan Kavan's problem,
http://archives.postgresql.org/pgsql-admin/2006-09/msg00092.php
which we have now pretty well proven was a kernel bug.

> The version running in the server is 8.1.3 on Linux 2.6.5 on an Intel
> platform.

2.6.5 what exactly?  And what's the "Intel platform"?  Although I don't
have any details about the kernel bug, I can't help suspecting that it
only manifested on systems pretty similar to Dan's dual Opteron.

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux