From: | Andres Freund <andres(at)2ndquadrant(dot)com> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Josh Berkus <josh(at)agliodbs(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: Let's drop two obsolete features which are bear-traps for novices |
Date: | 2014-11-01 18:43:13 |
Message-ID: | 20141101184313.GL17790@awork2.anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On 2014-11-01 14:39:21 -0400, Tom Lane wrote:
> Andres Freund <andres(at)2ndquadrant(dot)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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2014-11-01 18:45:47 | Re: Let's drop two obsolete features which are bear-traps for novices |
Previous Message | Tom Lane | 2014-11-01 18:39:21 | Re: Let's drop two obsolete features which are bear-traps for novices |