Good Morning All! I'm testing moving stuff off of MS-SQL Server onto pgsql so far so good... Thanks for everyones help. When I run a particulare SQL select statement (with 5 tables, 5 inner joins) my pgsql server almost always crashes. the error I get is ... pqReadData() -- backend closed the channel unexpectedly. This probably means the backend terminated abnormally before or while processing the request. We have lost the connection to the backend, so further processing is impossible. Terminating. HOW WOULD I GO ABOUT FIGURING WHATS WRONG? ps (I'm running FreeBSD 3.2 (with fairly inadequate hardware). but I would assume that hardware would just affect response times) ************