Fwd: --with-wal-segsize in-effective?
| От | Dhimant Patel |
|---|---|
| Тема | Fwd: --with-wal-segsize in-effective? |
| Дата | |
| Msg-id | f3e51c11003031001p2812f739ifb766aec3e017d5a@mail.gmail.com обсуждение исходный текст |
| Ответ на | --with-wal-segsize in-effective? (Dhimant Patel <drp4kri@gmail.com>) |
| Ответы |
Re: Fwd: --with-wal-segsize in-effective?
|
| Список | pgsql-admin |
To investigate this further I worked on the 8.4.2 source code and it allows to set the xlog segment size but still does not follow what documentation implies - unless I am wrong.
--with-wal-segsize=2 as per documentation should give me 4MB size segment, I am getting it of 2MB.
Thanks,
DP.
--with-wal-segsize=2 as per documentation should give me 4MB size segment, I am getting it of 2MB.
Thanks,
DP.
---------- Forwarded message ----------
From: Dhimant Patel <drp4kri@gmail.com>
Date: Wed, Mar 3, 2010 at 12:32 PM
Subject: --with-wal-segsize in-effective?
To: pgsql-admin@postgresql.org
Hi All,
I am working with latest source downloaded from postgres org site.
I compiled and installed the source with --with-wal-segsize=2, assuming it should give me 4MB size xlog files. (As per the documentation it is a power of 2 value.)
During the compilation the configure script spitted out "checking for WAL segment size... 2MB" - so something was off - and I could not imagine what it is. After successful install and creating database, I still got 16MB files in my pg_xlog directory. That's too bad. I can not seem to be able to follow.
I thought it time to turn on archive anyway. I got 16MB files in my archive location!
So what am I doing wrong?
Please help.
-DP.
From: Dhimant Patel <drp4kri@gmail.com>
Date: Wed, Mar 3, 2010 at 12:32 PM
Subject: --with-wal-segsize in-effective?
To: pgsql-admin@postgresql.org
Hi All,
I am working with latest source downloaded from postgres org site.
I compiled and installed the source with --with-wal-segsize=2, assuming it should give me 4MB size xlog files. (As per the documentation it is a power of 2 value.)
During the compilation the configure script spitted out "checking for WAL segment size... 2MB" - so something was off - and I could not imagine what it is. After successful install and creating database, I still got 16MB files in my pg_xlog directory. That's too bad. I can not seem to be able to follow.
I thought it time to turn on archive anyway. I got 16MB files in my archive location!
So what am I doing wrong?
Please help.
-DP.
В списке pgsql-admin по дате отправления: