pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feed--with-wal-segsize in-effective?
4+ messages / 3 participants
[nested] [flat]
* --with-wal-segsize in-effective?
@ 2010-03-03 17:32 Dhimant Patel <drp4kri@gmail.com>
2010-03-03 18:01 ` Fwd: --with-wal-segsize in-effective? Dhimant Patel <drp4kri@gmail.com>
2010-03-03 23:31 ` Re: --with-wal-segsize in-effective? Alex Hunsaker <badalex@gmail.com>
0 siblings, 2 replies; 4+ messages in thread
From: Dhimant Patel @ 2010-03-03 17:32 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Fwd: --with-wal-segsize in-effective?
2010-03-03 17:32 --with-wal-segsize in-effective? Dhimant Patel <drp4kri@gmail.com>
@ 2010-03-03 18:01 ` Dhimant Patel <drp4kri@gmail.com>
2010-03-03 18:33 ` Re: Fwd: --with-wal-segsize in-effective? Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 1 reply; 4+ messages in thread
From: Dhimant Patel @ 2010-03-03 18:01 UTC (permalink / raw)
To: 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@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.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Fwd: --with-wal-segsize in-effective?
2010-03-03 17:32 --with-wal-segsize in-effective? Dhimant Patel <drp4kri@gmail.com>
2010-03-03 18:01 ` Fwd: --with-wal-segsize in-effective? Dhimant Patel <drp4kri@gmail.com>
@ 2010-03-03 18:33 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 4+ messages in thread
From: Tom Lane @ 2010-03-03 18:33 UTC (permalink / raw)
To: Dhimant Patel <drp4kri@gmail.com>; +Cc: pgsql-admin
Dhimant Patel <drp4kri@gmail.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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: --with-wal-segsize in-effective?
2010-03-03 17:32 --with-wal-segsize in-effective? Dhimant Patel <drp4kri@gmail.com>
@ 2010-03-03 23:31 ` Alex Hunsaker <badalex@gmail.com>
1 sibling, 0 replies; 4+ messages in thread
From: Alex Hunsaker @ 2010-03-03 23:31 UTC (permalink / raw)
To: Dhimant Patel <drp4kri@gmail.com>; +Cc: pgsql-admin
On Wed, Mar 3, 2010 at 10:32, Dhimant Patel <drp4kri@gmail.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.
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-03-03 23:31 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-03-03 17:32 --with-wal-segsize in-effective? Dhimant Patel <drp4kri@gmail.com>
2010-03-03 18:01 ` Dhimant Patel <drp4kri@gmail.com>
2010-03-03 18:33 ` Tom Lane <tgl@sss.pgh.pa.us>
2010-03-03 23:31 ` Alex Hunsaker <badalex@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox