Re: [GENERAL] Slow query but can't see whats wrong

24 jul 2007 kl. 16:10 skrev Tom Lane: Henrik Zagerholm [EMAIL PROTECTED] writes: I'm using pgsql 8.2.4 and I have this query which is sooo slow but I can seem to figure out why. Seems the core of the problem is the misestimation here: - Index

[GENERAL] Slow query but can't see whats wrong

Hello list, I'm using pgsql 8.2.4 and I have this query which is sooo slow but I can seem to figure out why. It is using the appropriate indexes but there is something wrong with the nested loops. I'm running auto vacuum so the statistics should be up to date. I've increase the

Re: [GENERAL] Slow query but can't see whats wrong

On Tue, Jul 24, 2007 at 10:40:16AM +0200, Henrik Zagerholm wrote: I'm using pgsql 8.2.4 and I have this query which is sooo slow but I can seem to figure out why. It is using the appropriate indexes but there is something wrong with the nested loops. I'm running auto vacuum so the

Re: [GENERAL] Slow query but can't see whats wrong

Henrik Zagerholm [EMAIL PROTECTED] writes: I'm using pgsql 8.2.4 and I have this query which is sooo slow but I can seem to figure out why. Seems the core of the problem is the misestimation here: - Index Scan using tbl_file_idx on tbl_file