- Previous thread: [HACKERS] check for missing tablespaces?
- Next thread: [HACKERS] proposal: SQL parser integration to PL/pgSQL
- Threads sorted by date: pgsql 200905
Craig Ringer wrote on 24.05.2009 17:58:
> There isn't currently any REINDEX CONCURRENTLY option
But them manual does list this option:
http://www.postgresql.org/docs/8.3/static/sql-createindex.html
"When this option is used, PostgreSQL will build the index without taking any
locks that prevent concurrent inserts, updates, or deletes on the table"
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
> There isn't currently any REINDEX CONCURRENTLY option
But them manual does list this option:
http://www.postgresql.org/docs/8.3/static/sql-createindex.html
"When this option is used, PostgreSQL will build the index without taking any
locks that prevent concurrent inserts, updates, or deletes on the table"
Thomas
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Conversations: [GENERAL] do postgresql this job for me ? (firebird user)
- [GENERAL] do postgresql this job for me ? (firebird user) by mnavahan on 2009-05-24T05:12:59+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by Craig Ringer on 2009-05-24T08:12:56+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by mnavahan on 2009-05-24T11:37:17+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by Guillaume Lelarge on 2009-05-24T13:52:37+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by mnavahan on 2009-05-24T14:16:08+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by mnavahan on 2009-05-24T14:16:36+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by Guillaume Lelarge on 2009-05-24T14:29:38+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by Craig Ringer on 2009-05-24T15:59:57+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by Tom Lane on 2009-05-24T16:34:33+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by Thomas Kellerer on 2009-05-24T17:34:06+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by Christophe on 2009-05-24T17:53:55+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by Tom Lane on 2009-05-24T18:22:28+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by Craig Ringer on 2009-05-25T04:22:56+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by Tom Lane on 2009-05-25T14:40:35+00:00
- Re: [GENERAL] do postgresql this job for me ? (firebird user) by Craig Ringer on 2009-05-26T04:09:33+00:00
Related Threads
- Issue with debugging information generated by compiler gcc 4.3.3. - gcc
- Multiple Primary Key - django
- (no subject) - freebsd
- [webkit-dev] How to create a test for a "missing layout update" bug? - webkit
- How to check if a list contains an item - python
- Re: [ydn-javascript] YUI Menu Visibility - javascript
- [GIT] kbuild - kernel
- Test Mail. - debian
- [flexcoders] Looking for graphic designers for partnership - flex
- [users] Error while opening the Excel file using Openoffice - openoffice
- [Openvpn-users] Bridging not working as expected - openvpn
- [eGroupWare-users] Address book in Felamimail is broken! - egroupware