Beta 3 question(s)

Started by Mitch Vincentalmost 25 years ago2 messages
#1Mitch Vincent
mitch@venux.net

Hey guys, I am just getting back into the swing of things (after a nice
vacation and a not-so-nice move across country).. I just installed 7.1 Beta
3 and am playing with it (I'm impressed with the speed increase I've seen
with virtually no tweaking BTW).. I see a lot of this when I'm importing
data :

DEBUG: copy: line 2865, XLogWrite: new log file created - try to increase
WAL_FILES

Is that anything to be concerned about? Do I need to increase WAL_FILES? If
so, how?

Thanks!

-Mitch

#2Mikheev, Vadim
vmikheev@SECTORBASE.COM
In reply to: Mitch Vincent (#1)
RE: Beta 3 question(s)

I see a lot of this when I'm importing data :

DEBUG: copy: line 2865, XLogWrite: new log file created -
try to increase WAL_FILES

Is that anything to be concerned about?

No, WAL_FILES affects performance only.

Do I need to increase WAL_FILES? If so, how?

You may ignore this for data import, but it's good
to have WAL_FILES >= 1 for database use under high load.
Sorry, Oliver Elphick and me write WAL docs right now -
should be ready in 1-2 days.

Vadim