Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Re: Some pgbench results


  • From: Douglas McNaught <doug(at)mcnaught(dot)org>
  • To: "Magnus Naeslund(f)" <mag(at)fbab(dot)net>
  • Cc: Just Someone <just(dot)some(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org
  • Subject: Re: Some pgbench results
  • Date: Fri, 24 Mar 2006 13:55:35 -0500
  • Message-id: <877j6ju0yg(dot)fsf(at)suzuka(dot)mcnaught(dot)org>

"Magnus Naeslund(f)" <mag(at)fbab(dot)net> writes:

> It might seem that I'm selling ext3 or something :) but it's the linux
> filesystem I know best.
> If you want ext3 to perform with large directories, there is an mkfs
> option that enables directory hashing that you can try: -O dir_index.

You can also turn it on for an existing filesystem using 'tune2fs' and
a remount, but it won't hash already-existing large directories--those
will have to be recreated to take advantage of hashing.

-Doug



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group