[Date Prev][Date Next][Thread Prev][Thread Next]
[Date Index]
[Thread Index]
- Subject: Re: Load large amount of data fast
- From: Petite Abeille <petite.abeille@...>
- Date: Sun, 17 Oct 2010 04:21:05 +0200
On Oct 17, 2010, at 3:56 AM, Alexander Gladysh wrote:
> I guess those UUIDs are especially bad for performance:
For the record, using uuid, 10 million records, ~800 MB, ~10 minutes:
2010-10-17 04:09:38 Started reading
2010-10-17 04:10:06 Finished reading
2010-10-17 04:10:06 Started load
2010-10-17 04:15:59 Finished load
2010-10-17 04:15:59 Started call
2010-10-17 04:19:29 Finish call
2010-10-17 04:19:29 Started count
10000000
2010-10-17 04:19:29 Finish count
Still, I don't think it's a clever idea :))