From: Marcos Ortiz <mlortiz@uci.cu>
To: Mark Stosberg <mark@summersault.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: debugging handle exhaustion and 15 min/ 5mil row delete
Date: Fri, 07 May 2010 15:22:58 +0200
Message-ID: <4BE41432.5000203@uci.cu> (raw)
In-Reply-To: <20100507101031.3442dd08@summersault.com>
References: <20100507093742.20c715b1@summersault.com>
<4BE3C4C9.60601@uci.cu>
<20100507101031.3442dd08@summersault.com>
El 07/05/2010 16:10, Mark Stosberg escribió:
>
>> You can use TRUNCATE instead DELETE. TRUNCATE is more efficient and
>> faster that DELETE.
>>
> Thanks for the suggestion. However, TRUNCATE is not compatible with
> Slony, and we also have some rows which remain in table.
>
>
>> Now, we need more information about your system to give you a certain
>> solution:
>> Are you using a RAID controller for you data?
>>
> Yes.
>
>
>> Do you have separated the xlog directory from the data directory?
>>
> No.
>
>
>> Which is your Operating System?
>>
> FreeBSD.
>
>
>> Which is you architecture?
>>
> i386.
>
> Thanks for the feedback. I'm going to try batching the deletes for now,
> which is approach was worked well for some of our other long-running
> deletes.
>
> Mark
>
>
Have you valorated to use a 64 bits version of FreeBSD for that?
The 64 bits OS can help you very much on large databases because yo can
use actually all available RAM that you have on the server.
Many experts on this list recommende to separate the xlog directory on a
RAID 1 configuration and the data directory on RAID 10 to obtain a
better performance.
The filesystems are very diverse, but I ´ve seen that ZFS is very useful
on these cases.
Which version of Slony-I are you using?
Regards
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mlortiz@uci.cu, mark@summersault.com
Subject: Re: debugging handle exhaustion and 15 min/ 5mil row delete
In-Reply-To: <4BE41432.5000203@uci.cu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox