From: | "Jaime Casanova" <jcasanov(at)systemguards(dot)com(dot)ec> |
---|---|
To: | "Alex Vinogradovs" <AVinogradovs(at)clearpathnet(dot)com> |
Cc: | "David Wilson" <david(dot)t(dot)wilson(at)gmail(dot)com>, "Joshua Drake" <jd(at)commandprompt(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: non-WAL btree? |
Date: | 2008-08-02 17:53:11 |
Message-ID: | 3073cc9b0808021053n188ef055j73f81ef41e29d6e4@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Aug 1, 2008 at 4:49 PM, Alex Vinogradovs
<AVinogradovs(at)clearpathnet(dot)com> wrote:
> It's all about number of repetions. If say I load my table
> with 50k every minute, and run reindex every minute, how
> long do you think it would take by end of the day, when
> my table (it's daily partition actually) is at maximum
> capacity ? And database may actually never crash, and
> I won't have to run reindex at all ;)
>
maybe http://www.postgresql.org/docs/8.3/static/wal-async-commit.html
is what you need...
begin;
set local synchronous_commit to off;
insert...
insert...
...
commit;
or
set synchronous_commit to off;
copy command;
set synchronous_commit to on;
--
regards,
Jaime Casanova
Soporte y capacitación de PostgreSQL
Guayaquil - Ecuador
Cel. (593) 87171157
From | Date | Subject | |
---|---|---|---|
Next Message | Glyn Astill | 2008-08-02 19:02:23 | Re: Initdb problem on debian mips cobalt: Bus error |
Previous Message | Sushant Sinha | 2008-08-02 15:50:18 | Re: [GENERAL] Fragments in tsearch2 headline |