Hi,
>
> There's a performance improvement submitted here:
> http://archives.postgresql.org/message-id/a778a7260810280033n43f70d36x8c437eacf9a54...@mail.gmail.com
>
> But I haven't been following the development of it closely, so you'll
> have to read the thread to see whether it will meet your ne
On Thursday 29 January 2009 02:43:18 you wrote:
> On Tue, 2009-01-27 at 12:53 -0500, Gabi Julien wrote:
> > I have merged the last hot standby patch (v9g) to 8.4 devel and I am
> > pleased with the experience. This is promising stuff.
>
> Thanks,
>
> > Perhaps it is a bit too soon to
> > ask questi
On Tue, 2009-01-27 at 12:53 -0500, Gabi Julien wrote:
> I have merged the last hot standby patch (v9g) to 8.4 devel and I am pleased
> with the experience. This is promising stuff.
Thanks,
> Perhaps it is a bit too soon to
> ask questions here but here it is:
Thanks very much for the bug r
On Wednesday 28 January 2009 18:35:18 Gabi Julien wrote:
> On Tuesday 27 January 2009 21:47:36 you wrote:
> > Hi,
> >
> > On Wed, Jan 28, 2009 at 4:28 AM, Gabi Julien
>
> wrote:
> > > Yes, the logs are shipped every minute but the recevory is 3 or 4 times
> > > longer.
> >
> > Are you disabling fu
On Tuesday 27 January 2009 21:47:36 you wrote:
> Hi,
>
> On Wed, Jan 28, 2009 at 4:28 AM, Gabi Julien
wrote:
> > Yes, the logs are shipped every minute but the recevory is 3 or 4 times
> > longer.
>
> Are you disabling full_page_writes? It may slow down recovery several
> times.
It looks like yo
On Tuesday 27 January 2009 16:25:44 you wrote:
> On Tue, 2009-01-27 at 14:28 -0500, Gabi Julien wrote:
> > Could this help? If the logs are smaller then I could potentially afford
> > shipping then at a higher frequency.
>
> See if there are times during which the recovery process isn't doing
> any
Hi,
On Thu, Jan 29, 2009 at 12:23 AM, Jason Long
wrote:
> Is pg_clearxlogtail going to be in contrib or integrated in some other way?
I also hope so. The related topic was discussed before.
http://archives.postgresql.org/pgsql-hackers/2009-01/msg00639.php
Regards,
--
Fujii Masao
NIPPON TELEGR
Fujii Masao wrote:
Hi,
On Wed, Jan 28, 2009 at 4:28 AM, Gabi Julien wrote:
Yes, the logs are shipped every minute but the recevory is 3 or 4 times
longer.
Are you disabling full_page_writes? It may slow down recovery several times.
Thanks I will take a look at it. Also, I came a
Hi,
On Wed, Jan 28, 2009 at 4:28 AM, Gabi Julien wrote:
> Yes, the logs are shipped every minute but the recevory is 3 or 4 times
> longer.
Are you disabling full_page_writes? It may slow down recovery several times.
> Thanks I will take a look at it. Also, I came across the record log shipping
On Tue, 2009-01-27 at 14:28 -0500, Gabi Julien wrote:
> Could this help? If the logs are smaller then I could potentially afford
> shipping then at a higher frequency.
>
See if there are times during which the recovery process isn't doing
anything (i.e. just waiting for WAL data). If so, somethi
On Tuesday 27 January 2009 13:13:32 you wrote:
> On Tue, 2009-01-27 at 12:53 -0500, Gabi Julien wrote:
> > I have merged the last hot standby patch (v9g) to 8.4 devel and I am
> > pleased with the experience. This is promising stuff. Perhaps it is a bit
> > too soon to ask questions here but here
On Tue, 2009-01-27 at 12:53 -0500, Gabi Julien wrote:
> I have merged the last hot standby patch (v9g) to 8.4 devel and I am pleased
> with the experience. This is promising stuff. Perhaps it is a bit too soon to
>
> ask questions here but here it is:
>
> 1. Speed of recovery
>
> With a arch
On Tue, 2009-01-27 at 12:58 -0500, Merlin Moncure wrote:
> you can manually throw pg_switch_xlog(), In practice, this is more of
> an issue on development boxes than anything if you server is at all
> busy.
>
That won't speed up recovery, that will just force the WAL segment to be
archived. It's
On 1/27/09, Gabi Julien wrote:
> I have merged the last hot standby patch (v9g) to 8.4 devel and I am pleased
> with the experience. This is promising stuff. Perhaps it is a bit too soon to
> ask questions here but here it is:
>
> 1. Speed of recovery
>
> With a archive_timeout of 60 seconds,
I have merged the last hot standby patch (v9g) to 8.4 devel and I am pleased
with the experience. This is promising stuff. Perhaps it is a bit too soon to
ask questions here but here it is:
1. Speed of recovery
With a archive_timeout of 60 seconds, it can take about 4 minutes before I see
th
15 matches
Mail list logo
