"Magnus Naeslund(f)" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq