Dmitry Tkach [EMAIL PROTECTED] writes:
3) I restart the server manually, and try again
analyze mytable;
... it *works*
4) I let it run for a while, then try again:
analyze mytable;
... it crashes.
Proves nothing, since ANALYZE only touches a random sample of the rows.
If you get that
Tom Lane wrote:
Proves nothing, since ANALYZE only touches a random sample of the rows.
Ok, I understand... Thanks.
If you get that behavior with VACUUM, or a full-table SELECT (say,
SELECT count(*) FROM foo), then it'd be interesting.
I never got it with select - only with vacuum and/or
Dmitry Tkach [EMAIL PROTECTED] writes:
Well ... *today* there seem to be files between and 00EC
Is that range supposed to stay the same or does it vary?
It will vary, but not quickly --- each file represents 1 million
transactions.
If the problem is erratic with VACUUM or SELECT COUNT(*),
Tom Lane wrote:
Dmitry Tkach [EMAIL PROTECTED] writes:
Well ... *today* there seem to be files between and 00EC
Is that range supposed to stay the same or does it vary?
It will vary, but not quickly --- each file represents 1 million
transactions.
If the problem is erratic with
Dmitry Tkach [EMAIL PROTECTED] writes:
Any ideas?
Time to get out memtest86 and badblocks.
regards, tom lane
---(end of broadcast)---
TIP 6: Have you searched our list archives?