Return-Path: Delivered-To: apmail-cayenne-user-archive@www.apache.org Received: (qmail 74788 invoked from network); 22 Sep 2007 00:06:14 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 22 Sep 2007 00:06:14 -0000 Received: (qmail 36225 invoked by uid 500); 22 Sep 2007 00:06:05 -0000 Delivered-To: apmail-cayenne-user-archive@cayenne.apache.org Received: (qmail 36208 invoked by uid 500); 22 Sep 2007 00:06:04 -0000 Mailing-List: contact user-help@cayenne.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user@cayenne.apache.org Delivered-To: mailing list user@cayenne.apache.org Received: (qmail 36199 invoked by uid 99); 22 Sep 2007 00:06:04 -0000 Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136) by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 21 Sep 2007 17:06:04 -0700 X-ASF-Spam-Status: No, hits=1.2 required=10.0 tests=SPF_NEUTRAL X-Spam-Check-By: apache.org Received-SPF: neutral (athena.apache.org: local policy) Received: from [59.167.240.32] (HELO fish.ish.com.au) (59.167.240.32) by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 22 Sep 2007 00:06:04 +0000 Received: from [10.29.62.13] (helo=[10.29.62.13]) by fish.ish.com.au with esmtpa (Exim 4.43) id 1IYsRa-0001uL-QK for user@cayenne.apache.org; Sat, 22 Sep 2007 10:02:01 +1000 Mime-Version: 1.0 (Apple Message framework v752.2) In-Reply-To: References: Content-Type: multipart/signed; protocol="application/pgp-signature"; micalg=pgp-sha1; boundary="Apple-Mail-27--488544398" Message-Id: <48E8CFCC-126A-4C28-A3E1-992A79855AFA@maniatis.org> Content-Transfer-Encoding: 7bit From: Aristedes Maniatis Subject: Re: Optimize cascade deletes Date: Sat, 22 Sep 2007 10:05:36 +1000 To: user@cayenne.apache.org X-Pgp-Agent: GPGMail 1.1.2 (Tiger) X-Mailer: Apple Mail (2.752.2) X-Spam-Score: -1.4 (-) X-Spam-Report: -1.4 ALL_TRUSTED Passed through trusted hosts only via SMTP X-Virus-Checked: Checked by ClamAV on apache.org --Apple-Mail-27--488544398 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed On 22/09/2007, at 2:45 AM, Giulio Cesare Solaroli wrote: > In this case, to delete just 68 rows it took more than two minutes, > but I don't know if this time is spent somewhere inside the cayenne > code, or if this is simply the time it took PostgreSQL to "physically" > delete the rows. > > Do these details help understanding what is going on? From these logs (and I don't use Postgresql so I don't know much about it), it would appear that the speed issue is inside Postgresql. I'd recommend trying this without Parallels (postgresql should run OK in OSX) and seeing what extra logging you can switch on at the database. mysql has a concept of 'slow-query-log' - perhaps postgresql has something similar. Cheers Ari Maniatis --------------------------> Aristedes Maniatis phone +61 2 9660 9700 PGP fingerprint 08 57 20 4B 80 69 59 E2 A9 BF 2D 48 C2 20 0C C8 --Apple-Mail-27--488544398 content-type: application/pgp-signature; x-mac-type=70674453; name=PGP.sig content-description: This is a digitally signed message part content-disposition: inline; filename=PGP.sig content-transfer-encoding: 7bit -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.3 (Darwin) iEYEARECAAYFAkb0XFAACgkQ72p9Lj5JECoevQCbBGFb2TeafbuTzY8MEVbgFY1z ddMAniWkiGPMjZT4QbnftbrH9Bb/TI8R =k+bT -----END PGP SIGNATURE----- --Apple-Mail-27--488544398--