* Andy <[EMAIL PROTECTED]> wrote:
>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 mac
ot;.id)
Total runtime: 31952.811 ms
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Andy" <[EMAIL PROTECTED]>
Cc: "Steinar H. Gunderson" <[EMAIL PROTECTED]>;
Sent: Tuesday, October 11, 2005 5:17 PM
Subject: Re: [PERFORM] Massive d
"Andy" <[EMAIL PROTECTED]> writes:
> EXPLAIN ANALYZE
> DELETE FROM report WHERE id_order IN
> ...
> Hash IN Join (cost=3532.83..8182.33 rows=32042 width=6) (actual
> time=923.456..2457.323 rows=59557 loops=1)
> ...
> Total runtime: 456718.658 ms
So the runtime is all in the delete triggers. Th
ctpartner_id_user_idx
on contactpartner cp (cost=0.00..15.38 rows=4 width=8) (actual
time=27.348..27.352 rows=1 loops=1)
Index Cond: (cp.id_user = "outer".id)
Total runtime: 456718.658 ms
- Original Message -
From: "Steinar H. Gunderson"
On Tue, Oct 11, 2005 at 10:47:03AM +0300, Andy wrote:
> 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.
>
> How can I increase this DELETE procedure because it is really
On 10/11/05 8:05 AM, "Andy" <[EMAIL PROTECTED]> wrote:
>> Do you have foreign key relationships that must be followed for cascade
>> delete? If so, make sure that you have indices on them.
> Yes I have such things. Indexes are on these fields. >> To be onest this
> delete is taking the longest ti
, October 11, 2005 2:54 PM
Subject: Re: [PERFORM] Massive delete performance
On 10/11/05 3:47 AM, "Andy" <[EMAIL PROTECTED]> wrote:
Hi to all,
I have the following problem: I have a client to which we send every
night a
"dump" with a the database in which there
On 10/11/05 3:47 AM, "Andy" <[EMAIL PROTECTED]> wrote:
> Hi to all,
>
> 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
Hi to all,
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.
So, I h
