On Mon, Mar 10, 2008 at 03:43:37PM -0700, Mark Smith wrote: > I'm not sure on the ramifications of this change on Postgres as well. > The particular code you're proposing change is used cross-db. Some > quick web searches seem to indicate that TRUNCATE is a-ok on Postgres, > but it'd be good to know if this is actually advisable in that > environment or not. TRUNCATE TABLE actually vastly outperforms DELETE FROM on Postgres. However on there was some recent (~3 months ago) talk about mapping the case of a full 'DELETE FROM' without a WHERE clause to just use TRUNCATE anyway.
However I do agree that having it per-db is probably wise. -- Robin Hugh Johnson Gentoo Linux Developer & Infra Guy E-Mail : [EMAIL PROTECTED] GnuPG FP : 11AC BA4F 4778 E3F6 E4ED F38E B27B 944E 3488 4E85
pgpd9waXG8XBw.pgp
Description: PGP signature
