Yup - that would work; too much work though. My 600MB dump has just finished. I'm going to dump the schema seperately and replace all bigint's with int, and restore.
To play it safe, I also replaced all smallint's with int - stuff it. Performance is now as it should be. Instead of 45 MINUTES, the queue now (a queue of 250+ tickets) displays in 10-15 seconds. Even merely closing tickets is faster now (3s instead of almost a minute). This thread should give other postgres/otrs users hope! Henry -------------------------------------------------------- This message was sent using MetroWEB's AirMail service. http://www.metroweb.co.za/ - full access for only R73. Free Web Accelerator, WebMail, Calendar, Anti-Virus, Anti-Spam, 10 emails, 100MB personal webspace, and more! Phone Now! 086 11 11 440