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