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:
"-> Inde
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_
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
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 statistics