Re: [GENERAL] question about "delete performance"

2005-01-23 Thread Michael Fuhr
On Mon, Jan 24, 2005 at 12:29:12PM +0800, Öܵ½¾© wrote: > I have a table with 500,000 records which has some invalid records, > I had wrote a program to check it, by the program I get all OIDs of > the redundant records, so I use "delete from tableXXX where oid =XXX1 > or oid =XXX2 or oid =XXX3 .

Re: [GENERAL] question about "delete performance"

2005-01-23 Thread Robert Creager
When grilled further on (Mon, 24 Jan 2005 12:29:12 +0800), Öܵ½¾© <[EMAIL PROTECTED]> confessed: > I have a table with 500,000 records which has some invalid records, I had > wrote a program to check it, by the program I get all OIDs of the redundant > records, so I use "delete from tableXXX wher

[GENERAL] question about "delete performance"

2005-01-23 Thread Öܵ½¾©
I have a table with 500,000 records which has some invalid records, I had wrote a program to check it, by the program I get all OIDs of the redundant records, so I use "delete from tableXXX where oid =XXX1 or oid =XXX2 or oid =XXX3 ... or oid=XXX1000, but it take me a long time to complete thi