Re: pgbench --unlogged-tables

On Fri, Jul 22, 2011 at 05:15:37PM -0400, Greg Smith wrote:
> That looks straightforward enough. 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.

Do you have any theories as to how indexing on SSD speeds things up?
IIRC you found only marginal benefit in putting WALs there. Are there
cases that SSD helps more than others when it comes to indexing?

Cheers,
David.
--
David Fetter <david(at)fetter(dot)org> http://fetter.org/
Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter
Skype: davidfetter XMPP: david(dot)fetter(at)gmail(dot)com
iCal: webcal://www.tripit.com/feed/ical/people/david74/tripit.ics

Remember to vote!
Consider donating to Postgres: http://www.postgresql.org/about/donate