I constantly import databases from our (postgres) production systems to our test systems. The largest of this databases is about 1GB without BLOBS, most of the data is just numbers, so we have a lot of rows to insert. On the test system where we check out performance problems (Celeron 466, so slow, you notice every performance problem weeks before it could harm the production system) the import takes around 15 to 30 minutes. So this is far away from your 4 days.
>> For example, if I have a simple table, indexed >>on an integer field, and do a select that was >>"WHERE that_field = 123", it is fast, and uses >>the index, but if I do "WHERE that_field IN >>(123, 456)", it doesn't use the index, unless >>you analyzed the table
I guess you were using an old postgres version? It was a problem in the pre 7.3 versions, but since then IN statements are as fast or faster than joins.
I'm looking forward to plug my keyboard and my monitor to my mum when she's ill. Thousands and millions of bacterias! This should rock. Imagine some nerds speaking: Hey, my grandma has 13 GFLOPS - Ha, my mum does Quake VII with 134 fps, but she's getting healthier every day...
Slashdot Mirror
I constantly import databases from our (postgres) production systems to our test systems. The largest of this databases is about 1GB without BLOBS, most of the data is just numbers, so we have a lot of rows to insert. On the test system where we check out performance problems (Celeron 466, so slow, you notice every performance problem weeks before it could harm the production system) the import takes around 15 to 30 minutes. So this is far away from your 4 days.
>> For example, if I have a simple table, indexed
>>on an integer field, and do a select that was >>"WHERE that_field = 123", it is fast, and uses
>>the index, but if I do "WHERE that_field IN
>>(123, 456)", it doesn't use the index, unless
>>you analyzed the table
I guess you were using an old postgres version? It was a problem in the pre 7.3 versions, but since then IN statements are as fast or faster than joins.
> Gamers Are Good People, Too
They just behave like good people, they call it Role Playing.
Whale meat isn't particularly tasty, but it's traditional. Sort of like canabalism was in certain populations in the last century.
But human meat is tasty, a little sweet, though.
3ware actively supports Linux as there a linux drivers on the CD you get with their RAID-Cards. Works fine, at least with SuSE 7.2+
I'm looking forward to plug my keyboard and my monitor to my mum when she's ill. Thousands and millions of bacterias! This should rock. Imagine some nerds speaking: Hey, my grandma has 13 GFLOPS - Ha, my mum does Quake VII with 134 fps, but she's getting healthier every day ...