DW wrote:
Hello,
I'm perplexed. I'm trying to find out why some queries are taking a long
time, and have found that after running analyze, one particular query
becomes slow.
This query is based on a view that is based on multiple left outer joins
to merge data from lots of tabl
which rows are
the relevent ones?
Also, I am running postgresql-server-7.4.9 from FreeBSD port (with
optimized CFLAGS turned on during compiling)
OS: FreeBSD 5.4 p8
Thanks,
DW
---(end of broadcast)---
TIP 2: Don't 'kill -9' the postmaster
this
problem on different hardware, so I know that this issue is not the
direct cause of this.
Thanks for any info. I can supply more info (like config files, schemas,
etc.) if you think it might help. But I though I would just describe the
problem for starters.
-DW
--