| From: | Simon Riggs <simon(at)2ndQuadrant(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Andres Freund <andres(at)2ndquadrant(dot)com>, Michael Paquier <michael(dot)paquier(at)gmail(dot)com>, "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: Support for REINDEX CONCURRENTLY |
| Date: | 2012-12-09 17:15:16 |
| Message-ID: | CA+U5nMJtsRCLAa2WhiXnb5WcJSQFqRRE4ZhnfMv178Lsb6y3pA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
On 8 December 2012 15:14, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
> Maybe the best way is to admit that we need a short-term exclusive lock
> for the swapping step.
Which wouldn't be so bad if this is just for the toast index, since in
many cases the index itself is completely empty anyway, which must
offer opportunities for optimization.
> Or we could wait for MVCC catalog access ...
If there was a published design for that, it would help believe in it more.
Do you think one exists?
--
Simon Riggs http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2012-12-09 17:16:17 | Re: MySQL search query is not executing in Postgres DB |
| Previous Message | Tom Lane | 2012-12-09 16:53:15 | Re: Proof of concept: auto updatable views [Review of Patch] |