Re: Improving speed of copy

On 20 Sep 2002 at 10:14, Jonah H. Harris wrote:

> Are you using copy within a transaction?

No. Will that help? I can try. But the utility I wrote, I could insert say 10K 
records in a transaction. Copy seems to be doing it all in one transaction. I 
don't get any value for select count(*) in another psql session till copy 
finishes..
> I don't know how to explain the size difference tho.  I have never seen an
> overhead difference that large.  What type of MySQL tables were you using
> and what version?

Dunno.. Not my machine.. I am just trying to tune postgres on a friends 
machine.. not even postgres/root there.. So can not answer these questions fast 
but will get back on themm..
> Have you tried this with Oracle or similar commercial database?

No. This requirement is specific for open source database..

May be in another test on a 4 way/4GB RAM  machine, I might seem another 
result. Mysql was creating index on a 10GB table for last 25hours and last I 
knew it wasn't finished..Must be something with parameters..

Will keep you guys posted..

ByeShridhar

--
brain, n:    The apparatus with which we think that we think.        -- Ambrose Bierce, 
"The Devil's Dictionary"