Re: COPY FROM command v8.1.4

From: "Robert Reeves" <robert(dot)reeves(at)quest(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: Re: COPY FROM command v8.1.4
Date: 2006-09-19 00:46:00
Message-ID: 0BAEFFA7AFADFD4497F50DD093687E07016FB908@melmbxw01.prod.quest.corp
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi,
Any update on this ?

--robert

-----Original Message-----
From: pgsql-admin-owner(at)postgresql(dot)org
[mailto:pgsql-admin-owner(at)postgresql(dot)org] On Behalf Of Mr. Dan
Sent: Thursday, 14 September 2006 11:14 PM
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: [ADMIN] COPY FROM command v8.1.4

Hi Ray,

I've tried "it" on both WAFL and Reiser filesystems and gotten either
0,1,
or 2 blocks of 25 rows missing. I haven't tried it on ext3 or JFS. No,
I
haven't seen any problems in the syslogs and I haven't seen any drops on
the
network in regards to WAFL. Reiser is the local filesystem.

I'm planning to verify the ctid values today in the missing rows and get

back to Tom with information ASAP.

~DjK

---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Marc G. Fournier 2006-09-19 00:54:18 Re: Query about mailing list
Previous Message Sriram Dandapani 2006-09-19 00:15:40 Re: autovacuum ignore tables