| Lists: | pgsql-admin |
|---|
| From: | Dhimant Patel <drp4kri(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | --with-wal-segsize in-effective? |
| Date: | 2010-03-03 17:32:15 |
| Message-ID: | f3e51c11003030932g4a12e1c7u4d5852f0b7cde0e8@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
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(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Fwd: --with-wal-segsize in-effective? |
| Date: | 2010-03-03 18:01:08 |
| Message-ID: | f3e51c11003031001p2812f739ifb766aec3e017d5a@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | 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.
---------- Forwarded message ----------
From: Dhimant Patel <drp4kri(at)gmail(dot)com>
Date: Wed, Mar 3, 2010 at 12:32 PM
Subject: --with-wal-segsize in-effective?
To: pgsql-admin(at)postgresql(dot)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: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Dhimant Patel <drp4kri(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: Fwd: --with-wal-segsize in-effective? |
| Date: | 2010-03-03 18:33:12 |
| Message-ID: | 14353.1267641192@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
Dhimant Patel <drp4kri(at)gmail(dot)com> writes:
> --with-wal-segsize=2 as per documentation should give me 4MB size segment, I
> am getting it of 2MB.
Not sure what part of the documentation you're reading, but what I'm
looking at says the size is specified in megabytes. So that behavior
seems correct to me.
regards, tom lane
| From: | Alex Hunsaker <badalex(at)gmail(dot)com> |
|---|---|
| To: | Dhimant Patel <drp4kri(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org |
| Subject: | Re: --with-wal-segsize in-effective? |
| Date: | 2010-03-03 23:31:17 |
| Message-ID: | 34d269d41003031531v1e126502vee39d5cb2ae54092@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-admin |
On Wed, Mar 3, 2010 at 10:32, Dhimant Patel <drp4kri(at)gmail(dot)com> wrote:
> 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.)
Erm "it must be a power of 2" not "It will times it by 2"... So 2
being a power of 2 should give you 2MB. It should fail with say 3MB
or any non power of 2 number.