X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id D9DA9D1D298 for ; Thu, 12 Feb 2004 08:40:31 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 96812-09 for ; Thu, 12 Feb 2004 04:40:31 -0400 (AST) Received: from rock.spider.ru (rock.spider.ru [62.183.34.226]) by svr1.postgresql.org (Postfix) with ESMTP id DA97FD1CACB for ; Thu, 12 Feb 2004 04:40:29 -0400 (AST) Received: from rock (localhost [127.0.0.1]) by rock (Postfix) with SMTP id 62D7D913B2 for ; Thu, 12 Feb 2004 11:40:30 +0300 (MSK) Received: from sad.localnet.ru (sad.localnet.ru [10.0.0.33]) by rock.spider.ru (Postfix) with ESMTP id 3DA2A9139D for ; Thu, 12 Feb 2004 11:40:30 +0300 (MSK) Content-Type: text/plain; charset="iso-8859-1" From: sad Organization: IT To: pgsql-sql@postgresql.org Subject: Re: cascade delete Date: Thu, 12 Feb 2004 11:45:10 +0300 User-Agent: KMail/1.4.3 References: <200402121033.06964.sad@bankir.ru> <000901c3f13a$e87bf1e0$c4688a90@athlon2000> In-Reply-To: <000901c3f13a$e87bf1e0$c4688a90@athlon2000> MIME-Version: 1.0 Content-Transfer-Encoding: quoted-printable Message-Id: <200402121145.10845.sad@bankir.ru> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200402/110 X-Sequence-Number: 16801 > Check if it is using indexes. > 7.3 seems to ignore them somethimes, try upgrading to 7.4 where index use > is apparently improved. good,=20 i will upgrade anyway but how can i check index usage when DELETE from table1; ? EXPLAIN tells me only "seq scan on table1"=20 when many other tables involved in this DELETE by foreign keys