768 1157121286572
-/+ buffers/cache: 6399401419532
Swap: 2096440 4909681605472
thanks,
--
Sebastien Lemieux
Bioinformatics, post-doc
Elitra-canada
---(end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
s constraints, replacing delete
by truncate and it now runs in about 25 seconds. Downside is that I lose
the foreign keys integrity verification, but because of this reference
loop in my schema it has caused me more problem than it has avoided until
now. So I can live with that
On Wed, 6 Aug 2003, Tom Lane wrote:
> Sebastien Lemieux <[EMAIL PROTECTED]> writes:
> > All the time is taken at the commit of both transaction.
>
> Sounds like the culprit is foreign-key checks.
>
> One obvious question is whether you have your foreign keys set up
