Re: [PERFORM] [BUGS] BUG #2737: hash indexing large table fails, while btree of same index works

[ cc'ing to pgsql-performance because of performance issue for hash indexes ] "Balazs Nagy" <[EMAIL PROTECTED]> writes: > Database table size: ~60 million rows > Field to index: varchar 127 > CREATE INDEX ... USING hash ... > fails with a file not found error (psql in verbose mode): > ERROR: 5

[PERFORM] Lying drives [Was: Re: Which OS provides the _fastest_ PostgreSQL performance?]

toby wrote: > > That's not quite what I meant by "trust". Some drives lie about the > flush. Is that really true, or a misdiagnosed software bug? I know many _drivers_ lie about flushing - for example EXT3 on Linux before early 2005 "did not have write barrier support that issues the FLUSH CACH