On Mon, Jun 29, 2015 at 10:02 AM, ben.play <benjamin.co...@playrion.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@postgresql.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? 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.
