470,810 Members | 1,272 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 developers. It's quick & easy.

REINDEX issues

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

Nov 22 '05 #1
1 2251
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-----

Nov 22 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by G.W. Lucas | last post: by
5 posts views Thread by Edmund Dengler | last post: by
1 post views Thread by Ulrich Wisser | last post: by
1 post views Thread by paul | last post: by
reply views Thread by shubhangi | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.