In Oracle, there is a method bywhich tables can be loaded into memory as a method of speeding up queries. Is there anyway this can be done in Postgres? Does anyone know a good site outlining general methods of database optimisation? Thanks, --------------------------------------------------------- Jonathan Brace Junior Software Engineer Blitz The Net [EMAIL PROTECTED] www.blitzthenet.com