On Wed, Dec 12, 2007 at 10:16:43AM +0000, Matthew Lunnon wrote: > Does anyone have any ideas what my bottle neck might be and what I can do > about it? Your bottleneck is that you are using a very old version of PostgreSQL. Try 8.2 or (if you can) the 8.3 beta series -- it scales a _lot_ better in this kind of situation. /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate