"Scot Kreienkamp" <SKreien@xxxxxxxxxxxx> writes: > Another strange thing I just found when composing this email... If I set > limit 5 on the query it works on the soldtrx table, but if I don't set a > limit it just hangs. Is it chewing CPU, chewing I/O, or just sitting? If the latter, try attaching to the backend with gdb and getting a stack trace. I'm still not buying the theory that the dump/restore method has something to do with it. You might try the test yourself: run pg_restore's output into a text file and compare with the text dump. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
