REINDEX issues

[Sally Sally]

I just started a REINDEX on a non-system table because I was getting "failed
to re-find parent key" while analyzing. I realized a little too late that
the docs said the pg server should have been running as a standalone. Is
this something I should worry about? It's taking a bit of a while too!
Thanx
Sally

__________________________________________________ _______________
Stay informed on Election 2004 and the race to Super Tuesday.
http://special.msn.com/msn/election2004.armx
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend

[Martijn van Oosterhout]

On Wed, Feb 25, 2004 at 06:43:11PM +0000, Sally Sally wrote:

I just started a REINDEX on a non-system table because I was getting
"failed to re-find parent key" while analyzing. I realized a little too
late that the docs said the pg server should have been running as a
standalone. Is this something I should worry about? It's taking a bit of a
while too!
Nope. REINDEX on a non-system table is not a problem. You can do that
anything, though it does lock the table.

On system tables you need to be standalone, but then it wouldn't have
let you do it accedently.

Big tables take a while to index. About as long as:

select fieldname from table order by 1;
--
Martijn van Oosterhout <kl*****@svana.org> http://svana.org/kleptog/ If the Catholic church can survive the printing press, science fiction
will certainly weather the advent of bookwarez.
http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org

iD8DBQFAPPWkY5Twig3Ge+YRAqW7AKDKzC5KULCKjWJhq4xlBP XPzVZQgQCg0MgX
K1Iao3PCKFTAJ8dUeuj0cG4=
=o209
-----END PGP SIGNATURE-----