Search Postgresql Archives

Re: Importance of re-index

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, 2006-08-03 at 18:03, Tom Lane wrote:
> Scott Marlowe <smarlowe@xxxxxxxxxxxxxxxxx> writes:
> > Reindex was originally
> > designed to fix broken indexes, and, at least in earlier encarnations,
> > should something stop it in the middle of reindexing I believe it is
> > possible to be left with no index.
> 
> That was once true but these days reindex is perfectly crash-safe.  The
> only case where it's not is where you want to reindex a shared catalog's
> index (eg one of pg_database's), and we don't let you do that in
> multiuser mode anyway.

Oh cool! nice to know that's since been fixed.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux