I proposed to explore splitting BLCKSZ into separate values for logging
and data to see if there might be anything to gain:
My first pass was to do more or less a search and replace (attached) and
I am already running into trouble with a 'make check' (below). I'm
guessing that when initdb is run, I'm not properly saving the values
that I've defined for DATA_BLCKSZ and possibly LOG_BLCKSZ.
So I'm hoping someone could give me a pointer and I thought it might be
a good idea send something out.
Running in noclean mode. Mistakes will not be cleaned up.
The files belonging to this database system will be owned by user "markw".
This user must also own the server process.
The database cluster will be initialized with locale C.
creating directory /home/markw/shell/src/pgsql/src/test/regress/./tmp_check/data ... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers/max_fsm_pages ... 3000/150000
creating configuration files ... ok
creating template1 database in /home/markw/shell/src/pgsql/src/test/regress/./tmp_check/data/base/1 ... PANIC: database files are incompatible with server
DETAIL: The database cluster was initialized with DATA_BLCKSZ 0, but the server was compiled with DATA_BLCKSZ 8192.
HINT: It looks like you need to recompile or initdb.
child process was terminated by signal 6
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2006-03-22 19:19:48|
|Subject: Re: WIP: splitting BLCKSZ |
|Previous:||From: Csaba Nagy||Date: 2006-03-22 16:19:58|
|Subject: Re: WAL logging of SELECT ... INTO command|