Re: Amazon High I/O instances

From: Sébastien Lorion <sl(at)thestrangefactory(dot)com>
To: John R Pierce <pierce(at)hogranch(dot)com>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Amazon High I/O instances
Date: 2012-09-13 21:08:39
Message-ID: CAGa5y0MiVFabbFmRjM6uVKDjjb=W6HgRfiRFhLqLh1ts6uA93Q@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I started db creation over, this time with 16GB maintenance_work_mem and
fsync=off and it does not seem to have a great effect. After again 5 hours,
during index creation, disk and cpu are barely used: 95% idle and 2-3 MB/s
writes (150 reads/s, 90 writes/s).

Sébastien

On Thu, Sep 13, 2012 at 1:29 AM, John R Pierce <pierce(at)hogranch(dot)com> wrote:

> On 09/12/12 10:01 PM, Sébastien Lorion wrote:
>
>> pgbench initialization has been going on for almost 5 hours now and still
>> stuck before vacuum starts .. something is definitely wrong as I don't
>> remember it took so long first time I created the db....
>>
>
> pgbench initialization with a high scale factor, like the -s 10000 I
> frequently use, does take quite a few hours. you need a large
> maintenance_work_mem, or the create index phase will take a really long
> time to index the 150GB worth of tables its created.
>
>
>
>
> --
> john r pierce N 37, W 122
> santa cruz ca mid-left coast
>
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/**mailpref/pgsql-general<http://www.postgresql.org/mailpref/pgsql-general>
>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bill Moran 2012-09-13 21:25:09 Re: Best free tool for relationship extraction
Previous Message David Salisbury 2012-09-13 20:51:57 Re: pg_dump -Fd must create directory