By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
464,761 Members | 1,045 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 464,761 IT Pros & Developers. It's quick & easy.

REINDEX issues

P: n/a
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
Share this Question
Share on Google+
1 Reply

P: n/a
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.