On 7/13/06, Christian Rengstl
<Christian.Rengstl@klinik.uni-regensburg.de> wrote:
> Good morning list,
>
> the following query takes about 15 to 20 minutes for around 2 million lines in the file myfile.txt, but with 8
millionlines it takes around 5 hours and i just don't understand why there is such a huge discrepancy in performance.
on the surface it doesn't make sense, can you post an explain analyze?
merlin
