Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
Date: 2005-03-09 04:37:44
Message-ID: 200503082037.44639.josh@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom,

> > Maybe I'm not an idiot (really!) even with almost 2GB of
> > maintenance_mem, PG still writes to pgsql_tmp no faster than 2MB/s. I
> > think there may be an artificial bottleneck there. Question is,
> > PostgreSQL, OS or hardware?
>
> AFAIR that's just fwrite() ...

Well, are there any hacks to speed it up? It's about doubling the amount of
time it takes to create an index on a very large table.

--
--Josh

Josh Berkus
Aglio Database Solutions
San Francisco

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tom Lane 2005-03-09 04:37:58 Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?
Previous Message Tom Lane 2005-03-09 04:27:44 Re: Why would writes to pgsql_tmp bottleneck at 1mb/s?