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
