Re: pgbench --unlogged-tables - Mailing list pgsql-hackers

From Robert Haas
Subject Re: pgbench --unlogged-tables
Date
Msg-id CA+Tgmob54uZNwQ7ZJ5aPmsGjfPfhRY93Nk4VuOrX1p0j2Hpb9A@mail.gmail.com
Whole thread Raw
In response to Re: pgbench --unlogged-tables  (Greg Smith <greg@2ndQuadrant.com>)
Responses Re: pgbench --unlogged-tables
List pgsql-hackers
On Fri, Jul 22, 2011 at 5:15 PM, Greg Smith <greg@2ndquadrant.com> wrote:
> That looks straightforward enough.

OK, committed.

> The other thing I keep realizing would
> be useful recently is to allow specifying a different tablespace to switch
> to when creating all of the indexes.  The old "data here, indexes on faster
> storage here" trick was already popular in some environments.  But it's
> becoming a really big win for environments that put indexes on SSD, and
> being able to simulate that easily with pgbench would be nice.

Hearing no objections, I did this, too.

At some point, we also need to sort out the scale factor limit issues,
so you can make these things bigger.

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: Access to current database from C-language function
Next
From: Tim
Date:
Subject: Re: vacuumlo patch