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..

Bye
Shridhar

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