| From: | Merlin Moncure <mmoncure(at)gmail(dot)com> |
|---|---|
| To: | pin007(at)gmail(dot)com |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: Streaming replication performance |
| Date: | 2011-08-12 16:47:24 |
| Message-ID: | CAHyXU0zCVv24bzEeM8rANLK3ZyGo2VO43DS0ZwomNfkn9GsfTA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Thu, Aug 11, 2011 at 9:46 AM, Antonin Faltynek <pin007(at)gmail(dot)com> wrote:
> Hi all,
>
> I'm testing Streamin replication with one hot standby node and I'm
> experiencing high delay of hot standby node.
>
> When I reach aprox. 50 transactions per second where every transaction
> includes only simple "UPDATE status SET number = number + 1 WHERE name =
> 'iterations'", the standby server falls behind master and the delay is several
> minutes. In comparison, Slony1 have no issues with the same test and its delay
> is only several seconds.
>
> Am I missing some configuration that affects speed of streaming replicaiton?
hm -- how are you determining the standby is behind? are you running
any other queries on the standby?
merlin
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Waldo Nell | 2011-08-12 16:54:46 | Re: Recommended optimisations slows down PostgreSQL 8.4 |
| Previous Message | Waldo Nell | 2011-08-12 16:44:18 | Re: pgpool master or slave goes down java access error |