Thread: Beta 3 question(s)

Beta 3 question(s)

From
"Mitch Vincent"
Date:
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



RE: Beta 3 question(s)

From
"Mikheev, Vadim"
Date:
> 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