On 17 Listopad 2011, 19:26, David Johnston wrote: > Anyway, if you execute the three TRUNCATEs in the proper order, thus > avoiding any kind of cascade, you should get maximum performance possible > on your UNSUPPORTED VERSION of PostgreSQL.
AFAIK cascade with TRUNCATE means 'truncate the depending tables first'. That's quite different from cascade with DELETE where the db has to actually find the records, and I don't think there's a significant performance impact. Tomas -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
