---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Yuji Shinozaki
]/
/ /
/ /
Yuji Shinozaki Computer Systems Senior Engineer
[EMAIL PROTECTED] Advanced Technologies Group
(434)924-7171 Information Technology Communication
http://www.people.virginia.edu/~ys2nUniversity of Virginia
]/
/ /
/ /
Yuji Shinozaki Computer Systems Senior Engineer
[EMAIL PROTECTED] Advanced Technologies Group
(434)924-7171 Information Technology Communication
http://www.people.virginia.edu/~ys2nUniversity of Virginia
/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
Yuji Shinozaki Computer Systems Senior Engineer
[EMAIL PROTECTED] Advanced
last)? Or can I simply concatenate all these single-table
dumps and tell pg_restore to apply the indexes last?
Is there a simple way to accomplish this?
yuji
Yuji Shinozaki Computer Systems Senior Engineer
[EMAIL PROTECTED] Advanced Technologies
start
it doesn't work! And I'm still confused as to why the script doesn't work.
Terse answer: Do not use quotes in your exec statement.
yuji
Yuji Shinozaki Computer Systems Senior Engineer
[EMAIL PROTECTED] Advanced Technologies Group
(434
found is dump/restore,
and again we pay the penalty of the 12-hour reindexing.
Any pointers?
Thanks!
yuji
Yuji Shinozaki Computer Systems Senior Engineer
[EMAIL PROTECTED] Advanced Technologies Group
(434)924-7171
(not
to mention inserts) slow!
Now the restore only takes about 20 minutes (yay!)
Thanks,
yuji
On Thu, 14 Aug 2003, Sam Barnett-Cormack wrote:
On Thu, 14 Aug 2003, Yuji Shinozaki wrote:
I have two questions about restoring and moving databases (in pg 7.3), to
which I have not been able
:
Yuji Shinozaki [EMAIL PROTECTED] writes:
Then the problem is that
reindexing takes a very long time. One particular index is taking on the
order of 12 hours to finish.
Seems like a lot. What is the index definition exactly, and how many
rows in the table? If it's a btree, have you tried