Re: [PERFORM] Query too slow

2003-09-04 Thread Bruce Momjian
Tom Lane wrote: Stephan Szabo [EMAIL PROTECTED] writes: On Tue, 26 Aug 2003, Ang Chin Han wrote: Veering aside a bit, since we usually pinpoint performance problems by looking at EXPLAIN ANALYZE's differences between the planner's estimation and actual execution's stats, what's involved

Re: [PERFORM] Query too slow

2003-08-25 Thread Stephan Szabo
On Mon, 25 Aug 2003, Rhaoni Chiu Pereira wrote: Hi List, As I said before, I'm not a DBA yet , but I'm learning ... and I already have a PostgreSQL running, so I have to ask some help... I got a SQL as folows : ... Looking at the explain: It's choosing lots of nested loops

Re: [PERFORM] Query too slow

2003-08-25 Thread Shridhar Daithankar
On 25 Aug 2003 at 8:44, Stephan Szabo wrote: On Mon, 25 Aug 2003, Rhaoni Chiu Pereira wrote: Hi List, As I said before, I'm not a DBA yet , but I'm learning ... and I already have a PostgreSQL running, so I have to ask some help... I got a SQL as folows : ...