From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Arthur Silva <arthurprs(at)gmail(dot)com>, "ben(dot)play" <benjamin(dot)cohen(at)playrion(dot)com> |
Cc: | "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Which replication is the best for our case ? |
Date: | 2015-06-29 16:44:34 |
Message-ID: | 559175F2.50205@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 06/29/2015 08:23 AM, Arthur Silva wrote:
> On Mon, Jun 29, 2015 at 10:02 AM, ben.play <benjamin(dot)cohen(at)playrion(dot)com
> <mailto:benjamin(dot)cohen(at)playrion(dot)com>> wrote:
>
> Hi guys,
>
> We have a PG database with more than 400 GB of data.
> At this moment, a cron runs each ten minutes and updates about 10
> 000 lines
> with complex algorithms in PHP.
>
> Each time the cron runs, the website is almost down because some queries
> have to make an update on the FULL table...
>
> Therefore, I'm asking if it's possible to duplicate my main database
> on a
> slave server in order to run these cron on this second server... then,
> replicate these changes on the main database (master).
>
> Which replication is the best in this case ?
>
> http://www.postgresql.org/docs/9.3/static/warm-standby.html ?
>
> Do you have any links or tutorial which explain this kind of operation ?
>
> Thanks a lot !
>
>
>
> --
> View this message in context:
> http://postgresql.nabble.com/Which-replication-is-the-best-for-our-case-tp5855685.html
> Sent from the PostgreSQL - general mailing list archive at Nabble.com.
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org
> <mailto:pgsql-general(at)postgresql(dot)org>)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>
>
> Hello Adrian, can you give us one example of such FULL table update queries?
Actually it is the OP(Ben) that is going to have to supply that.
>
> By website down you mean slowed to a halt or read-only mode (due to the
> update locks)?
>
> Either way it doesn't look like replication is going to solve your problem.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Arthur Silva | 2015-06-29 16:57:09 | Re: Which replication is the best for our case ? |
Previous Message | Colin Lieberman | 2015-06-29 15:59:41 | Re: Re: Get the difference between two timestamp cells but in a special format in PostgreSQL |