On Thu, Oct 18, 2012 at 3:18 PM, Gezeala M. Bacuño II wrote:
> You may disable full_page_writes, but as you can see from my previous
> post, disabling it did not do the trick. My zfs' USED property
> continues to increase.
I think we need somebody to compile with WAL_DEBUG defined and try to
repr
You may disable full_page_writes, but as you can see from my previous
post, disabling it did not do the trick. My zfs' USED property
continues to increase.
On Wed, Oct 17, 2012 at 3:55 PM, ichbinrene wrote:
> I'm experiencing the exact same issue:
>
> PostgreSQL 9.1.6 on i686-pc-linux-gnu, compil
I'm experiencing the exact same issue:
PostgreSQL 9.1.6 on i686-pc-linux-gnu, compiled by gcc (GCC) 4.4.6 20120305
(Red Hat 4.4.6-4), 32-bit
CentOS release 6.3 (Final)
I might also turn full_page_writes off but I fear for data integrity in case
of a crash .
--
View this message in context:
On Fri, Sep 7, 2012 at 11:40 AM, Gezeala M. Bacuño II wrote:
> adding pgsql-bugs list in case OP posts back.
>
> On Fri, Sep 7, 2012 at 11:29 AM, Pavan Deolasee
> wrote:
>> (Adding -hackers. Did not realize it got dropped)
>>
>> On Fri, Sep 7, 2012 at 11:25 PM, Gezeala M. Bacuño II
>> wrote:
>>>
adding pgsql-bugs list in case OP posts back.
On Fri, Sep 7, 2012 at 11:29 AM, Pavan Deolasee
wrote:
> (Adding -hackers. Did not realize it got dropped)
>
> On Fri, Sep 7, 2012 at 11:25 PM, Gezeala M. Bacuño II
> wrote:
>>
>> On Fri, Sep 7, 2012 at 7:17 AM, Pavan Deolasee
>> wrote:
>> >
>> >
>>
On Fri, Sep 7, 2012 at 12:15 PM, Gezeala M. Bacuño II wrote:
> The instance is cloned solely for
> backup purposes with zero modifications and autovacuum disabled.
>
For your restricted use case, it might be worthwhile to
turn full_page_writes OFF before starting the server. That should
definit
On Fri, Sep 7, 2012 at 12:15 PM, Gezeala M. Bacuño II wrote:
>
> From pg_controldata right after starting the instance:
> Latest checkpoint location: 4441/5E681F38
> Prior checkpoint location:4441/5E67D140
> Latest checkpoint's REDO location:4441/5E681F38
> Latest checkp
On Thu, Sep 6, 2012 at 8:48 PM, Pavan Deolasee wrote:
>
>
> On Fri, Sep 7, 2012 at 2:43 AM, Alvaro Herrera
> wrote:
>>
>> Excerpts from Boy de Laat's message of jue sep 06 17:24:35 -0300 2012:
>> >
>> > At the time my backup starts i see much WAL logs being generated?
>>
>> I guess we'd need to s
On Fri, Sep 7, 2012 at 2:43 AM, Alvaro Herrera wrote:
> Excerpts from Boy de Laat's message of jue sep 06 17:24:35 -0300 2012:
> >
> > At the time my backup starts i see much WAL logs being generated?
>
> I guess we'd need to see what the generated WAL logs are, either with
> xlogdump or XLOG_DEBU
Excerpts from Boy de Laat's message of jue sep 06 17:24:35 -0300 2012:
>
> At the time my backup starts i see much WAL logs being generated?
I guess we'd need to see what the generated WAL logs are, either with
xlogdump or XLOG_DEBUG turned on ...
--
Álvaro Herrerahttp://www.2nd
On Thu, Sep 6, 2012 at 5:07 PM, Alvaro Herrera wrote:
> How about secondary effects -- say pg_dump reads a lot of data into
> buffers that were previously dirty and those get evicted. Could page
> eviction cause lots of WAL to be emitted?
No. Simon's proposed checksum patch would have that effe
Excerpts from Tom Lane's message of jue sep 06 17:23:07 -0300 2012:
> Heikki Linnakangas writes:
> > On 06.09.2012 13:07, Robert Haas wrote:
> >> On Thu, Sep 6, 2012 at 3:55 PM, Tom Lane wrote:
> >>> Doesn't hint-bit setting cause WAL traffic these days?
>
> >> I sure as heck don't think so.
>
On Thu, Sep 6, 2012 at 4:23 PM, Tom Lane wrote:
> Heikki Linnakangas writes:
>> On 06.09.2012 13:07, Robert Haas wrote:
>>> On Thu, Sep 6, 2012 at 3:55 PM, Tom Lane wrote:
Doesn't hint-bit setting cause WAL traffic these days?
>
>>> I sure as heck don't think so.
>
>> It does not. HOT page
At the time my backup starts i see much WAL logs being generated?
Met vriendelijke groet,
Boy de Laat
Verzonden via iPhone
Op 6 sep. 2012 om 21:44 heeft "Robert Haas" het
volgende geschreven:
> On Wed, Sep 5, 2012 at 9:57 AM, wrote:
> > The following bug has been logged on the website:
> >
Heikki Linnakangas writes:
> On 06.09.2012 13:07, Robert Haas wrote:
>> On Thu, Sep 6, 2012 at 3:55 PM, Tom Lane wrote:
>>> Doesn't hint-bit setting cause WAL traffic these days?
>> I sure as heck don't think so.
> It does not. HOT page pruning does, however. It could be that..
Sorry, I was th
On Thu, Sep 6, 2012 at 4:08 PM, Heikki Linnakangas wrote:
> On 06.09.2012 13:07, Robert Haas wrote:
pg_dump doesn't modify any data, so I don't see how it could be
causing WAL logs to get generated.
>>>
>>> Doesn't hint-bit setting cause WAL traffic these days?
>>
>> I sure as heck don't
On 06.09.2012 13:07, Robert Haas wrote:
On Thu, Sep 6, 2012 at 3:55 PM, Tom Lane wrote:
Robert Haas writes:
On Wed, Sep 5, 2012 at 9:57 AM, wrote:
So it would be nice if there is an option to disable WAL logging while
running pg_dump.
pg_dump doesn't modify any data, so I don't see how i
On Thu, Sep 6, 2012 at 3:55 PM, Tom Lane wrote:
> Robert Haas writes:
>> On Wed, Sep 5, 2012 at 9:57 AM, wrote:
>>> So it would be nice if there is an option to disable WAL logging while
>>> running pg_dump.
>
>> pg_dump doesn't modify any data, so I don't see how it could be
>> causing WAL log
Robert Haas writes:
> On Wed, Sep 5, 2012 at 9:57 AM, wrote:
>> So it would be nice if there is an option to disable WAL logging while
>> running pg_dump.
> pg_dump doesn't modify any data, so I don't see how it could be
> causing WAL logs to get generated.
Doesn't hint-bit setting cause WAL t
On Wed, Sep 5, 2012 at 9:57 AM, wrote:
> The following bug has been logged on the website:
>
> Bug reference: 7521
> Logged by: Boy de Laat
> Email address: b...@atsc.nl
> PostgreSQL version: 9.1.4
> Operating system: CentOS 6.2 x86_64
> Description:
>
> I've setup some slave
The following bug has been logged on the website:
Bug reference: 7521
Logged by: Boy de Laat
Email address: b...@atsc.nl
PostgreSQL version: 9.1.4
Operating system: CentOS 6.2 x86_64
Description:
I've setup some slave replication and just to be sure i use pg_dump as a
21 matches
Mail list logo
