On Fri, Feb 29, 2008 at 1:08 AM, Greg Smith <[EMAIL PROTECTED]> wrote:
> On Fri, 29 Feb 2008, Sam Mason wrote:
>
> > Just out of interest, why doesn't it do the following?
> >
> > BEGIN;
> > create table xlog_switch as
> >select '0123456789ABCDE' from generate_series(1,100);
> > RO
On Fri, 29 Feb 2008, Sam Mason wrote:
Just out of interest, why doesn't it do the following?
BEGIN;
create table xlog_switch as
select '0123456789ABCDE' from generate_series(1,100);
ROLLBACK;
I'm not 100% sure here what happens when you do the above, and it depends
on version, but
On Thu, Feb 28, 2008 at 04:35:44PM -0500, Greg Smith wrote:
> Courtesy of Simon (
> http://archives.postgresql.org/pgsql-general/2007-06/msg00015.php ) you
> can force 16MB worth of WAL activity that doesn't leave any changes behind
> with:
>
> create table xlog_switch as
> select '0123456789AB
On Thu, 28 Feb 2008, Greg Smith wrote:
Nope; you'd want to play with XLOG_SEG_SIZE to change this. Have to
dump/initdb/reload your database as well to do it. Really just not a good
idea.
Thanks for the insight there. I figured changing the code would be
dangerous. I'm glad I asked, and than
On Thu, 28 Feb 2008, John Evans wrote:
How can I change the WAL log size from 16MB to something smaller?
Ideally, I would like to shoot for 8MB or even 4MB. The only thing that
I've found is to hack the code to change all instances of
YY_READ_BUF_SIZE from 16777216 to 4194304, but I'm not sure
On Feb 28, 2008, at 1:58 PM, Alan Hodgson wrote:
On Thursday 28 February 2008, Erik Jones <[EMAIL PROTECTED]> wrote:
Or, even simpler:
SELECT pg_switch_xlog();
The original poster is using 8.1.
Ah, I didn't realize that was only available in >= 8.2, thanks for
the clarification.
Erik J
On Thursday 28 February 2008, Erik Jones <[EMAIL PROTECTED]> wrote:
> Or, even simpler:
>
> SELECT pg_switch_xlog();
The original poster is using 8.1.
--
Alan
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
On Feb 28, 2008, at 12:51 PM, Alan Hodgson wrote:
On Thursday 28 February 2008, John Evans <[EMAIL PROTECTED]> wrote:
I've heard that upgrading to 8.2 or 8.3 will allow me to setup a
timeout value for WAL log creation, but upgrading at this time is
not an
option for various reasons.
On Thursday 28 February 2008, John Evans <[EMAIL PROTECTED]> wrote:
>I've heard that upgrading to 8.2 or 8.3 will allow me to setup a
> timeout value for WAL log creation, but upgrading at this time is not an
> option for various reasons.
>
>Any insight that you can provide will be greatly
All,
I've done some searching in the mailing list archives, and the
Internet in general, and come up with a blank. Here's my setup:
I'm working on setting up a replication system between two 8.1.11
servers using WAL log shipping via rsync. Nothing special there, but
the problem that I'm havi
10 matches
Mail list logo
