Re: [PERFORM] slow queries after ANALYZE

2005-11-14 Thread DW
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

Re: [PERFORM] slow queries after ANALYZE

2005-11-11 Thread DW
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

[PERFORM] slow queries after ANALYZE

2005-11-11 Thread DW
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 --