Re: [PERFORM] extrem bad performance

2004-07-21 Thread Stefan
Rod Taylor wrote: Lets start with an example. Please send us an EXPLAIN ANALYZE of a couple of the poorly performing queries. thanks for your answer. the problem was solved by using FULL(!) VACUUM. regards, Stefan ---(end of broadcast)--- TIP 5: Have

Re: [PERFORM] extrem bad performance

2004-07-16 Thread Rod Taylor
The database grows very slowly. The main load comes from SELECT's and not from INSERT's or UPDATE's, but the performance gets slower day by day... I have no idea where to search for the speed break! Lets start with an example. Please send us an EXPLAIN ANALYZE of a couple of the poorly