I am using postgres 8.2.6 on windows xp pro sp2. Of about 80 tables, one is a large binary table containing over 2gb of data. Postgres backsup the data and 95% of the time sticks at this table and cpu activity drops from 40-60% to about zero. I can stay there for hours before I just have to stop the attempt. We are using a health care record with postgres backend and other people are having the same problem. _____________________________________________________________ Own the Ultimate Platinum Credit Card. Click here. http://thirdpartyoffers.netzero.net/TGL2211/fc/Ioyw6ijldJaAPEMcUmOFzZNdfk9TMs4LECG50diB8qzKXj17ZyjcYG/ ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match