On Fri, Aug 1, 2008 at 4:49 PM, Alex Vinogradovs
<AVinogradovs@clearpathnet.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