adey11@xxxxxxxxx (adey) writes: > ...but I can't find pgsql_tmp in my v8.1.4 installation. > > Where can I find these temp files please? They get created on demand, and go away when that demand disappears. Run a big REINDEX and you'll see them pop into place... -- output = ("cbbrowne" "@" "ntlug.org") http://cbbrowne.com/info/sap.html "...Roxanne falls in love with Christian, a chevalier in Cyrano's regiment who hasn't got the brains God gave an eclair..." -- reviewer on NPR