On 2014-11-01 14:39:21 -0400, Tom Lane wrote: > Andres Freund <and...@2ndquadrant.com> writes: > > A REINDEX is imo unlikely to be acceptable. It takes long (why would you > > bother on a small table?) and locks the relation/indexes. > > I think the goalposts just took a vacation to Acapulco.
I think that might be caused by a misunderstanding. > What exactly do you think is going to make a crashed unlogged index valid > again without a REINDEX? Certainly the people who are currently using > hash indexes in the way Andrew describes are expecting to have to REINDEX > them after a crash. Obviously that individual index needs to be recreated. What I mean is that I don't think it'll be acceptable that the table essentially can't be queried before that's done. The situations in which I'd found unlogged indexes useful is where there's some indexes are critical for the OLTP business (those would continue to be logged), but some other large ones are for things that aren't absolutely essential. Reports and such. Greetings, Andres Freund -- Andres Freund http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers