X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 75547D720B for ; Tue, 11 Oct 2005 08:37:50 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 83374-09 for ; Tue, 11 Oct 2005 11:37:32 +0000 (GMT) Received: from svr2.postgresql.org (svr2.postgresql.org [65.19.161.25]) by svr1.postgresql.org (Postfix) with ESMTP id C4443D76DC for ; Tue, 11 Oct 2005 08:35:58 -0300 (ADT) Received: from ar-sd.net (unknown [82.77.155.72]) by svr2.postgresql.org (Postfix) with ESMTP id 86BBEF11D2 for ; Tue, 11 Oct 2005 08:36:34 +0100 (BST) Received: from localhost (localhost [127.0.0.1]) by ar-sd.net (Postfix) with ESMTP id 9562F21396 for ; Tue, 11 Oct 2005 10:31:15 +0300 (EEST) Received: from ar-sd.net ([127.0.0.1]) by localhost (linz [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 07680-08 for ; Tue, 11 Oct 2005 10:31:14 +0300 (EEST) Received: from forge (unknown [192.168.0.11]) by ar-sd.net (Postfix) with SMTP id 90DDCE791 for ; Tue, 11 Oct 2005 10:31:14 +0300 (EEST) Message-ID: <00bd01c5ce37$f8a4cc00$0b00a8c0@forge> From: "Andy" To: Subject: Massive delete performance Date: Tue, 11 Oct 2005 10:47:03 +0300 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_00BA_01C5CE51.1D679E50" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2900.2180 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2180 X-Virus-Scanned: by amavisd-new at ar-sd.net X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.254 required=5 tests=[AWL=0.176, FORGED_RCVD_HELO=0.05, HTML_60_70=0.027, HTML_MESSAGE=0.001] X-Spam-Level: X-Archive-Number: 200510/185 X-Sequence-Number: 14953 This is a multi-part message in MIME format. ------=_NextPart_000_00BA_01C5CE51.1D679E50 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hi to all,=20 I have the following problem: I have a client to which we send every = night a "dump" with a the database in which there are only their data's. = It is a stupid solution but I choose this solution because I couldn't = find any better. The target machine is a windows 2003. =20 So, I have a replication only with the tables that I need to send, then = I make a copy of this replication, and from this copy I delete all the = data's that are not needed.=20 How can I increase this DELETE procedure because it is really slow??? = There are of corse a lot of data's to be deleted.=20 Or is there any other solution for this?=20 DB -> (replication) RE_DB -> (copy) -> COPY_DB -> (Delete unnecesary = data) -> CLIENT_DB -> (ISDN connection) -> Data's to the client.=20 Regards,=20 Andy. ------=_NextPart_000_00BA_01C5CE51.1D679E50 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Hi to all,

I have the following problem: I have a = client to=20 which we send every night a "dump" with a the database in which there = are only=20 their data's. It is a stupid solution but I choose this solution = because I=20 couldn't find any better. The target machine is a windows 2003.=20

So, I have a replication only with the = tables that=20 I need to send, then I make a copy of this replication, and from this = copy I=20 delete all the data's that are not needed.

How can I increase this DELETE = procedure because it=20 is really slow??? There are of corse a lot of data's to be = deleted.=20

Or is there any other solution for = this?=20

DB -> (replication) RE_DB -> = (copy) ->=20 COPY_DB -> (Delete unnecesary data) -> CLIENT_DB -> (ISDN = connection)=20 -> Data's to the client.

Regards,

Andy.

------=_NextPart_000_00BA_01C5CE51.1D679E50--