Re: [PERFORM] extrem bad performance
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 you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Re: [PERFORM] extrem bad performance
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 performing queries. ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match