Nobody commented on the fact that for a body text search it keeps on spawning new search threads which slowly bring the machine to its knees.
Does this make any sense? Sim Sim Zacks wrote: > DBMail 2.2.10 > Postgresql 8.2.7 > Thunderbird 2.0.0.14 > > When searching in the body text for sim, the imap reaction became very > slow. We checked the server and it is using 80 percent CPU. > > I checked pg_stat_activity and found 30 rows with the exact same > current_query: > > "SELECT m.message_idnr,k.messageblk FROM dbmail_messageblks k JOIN > dbmail_physmessage p ON k.physmessage_id = p.id JOIN dbmail_messages m > ON p.id = m.physmessage_id WHERE mailbox_idnr = 8 AND status IN (0,1 ) > AND k.is_header = '0' GROUP BY m.message_idnr,k.messageblk HAVING > ENCODE(k.messageblk::bytea,'escape') LIKE '%sim%'" > > I stopped the search in Thunderbird and those rows still showed up in > the pg_stat_activity. I turned off my Thunderbird client and the rows > still showed up in the pg_stat_activity and the server was still going > very slowly. > > After some time, each connection slowly finished (as shown in the log > below, more then 20 minutes). After each one of these log messages, the > number of rows in pg_stat_activity was one less. > > 2 Questions: > > 1) Is this supposed to be happening and how can I prevent it from > happening again. > > > > Thank you > Sim > _______________________________________________ > DBmail mailing list > [email protected] > https://mailman.fastxs.nl/mailman/listinfo/dbmail _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
