Antw: Re: [GENERAL] Performance problem with query

2006-07-18 Thread Christian Rengstl
now finally after a long time i have the query plan for the whole filled table. I hope somebody can explain me why it takes so much longer... QUERY PLAN -

Antw: Re: [GENERAL] Performance problem with query

2006-07-14 Thread Christian Rengstl
Hi, somehow my reply yesterday got lost, but nevertheless here comes the explain analyze again. It's the explain of the operation that causes this huge performance discrepancy. Unfortunately i had to perform the explain analyze with an empty temp_table, because after the whole operation is done, i