Re: Which replication is the best for our case ?

Поиск
Список
Период
Сортировка
От Arthur Silva
Тема Re: Which replication is the best for our case ?
Дата
Msg-id CAO_YK0XF90mGCXDaV5XGFwmv6kAPBG=a4YC9O2zp1HwgtZpUDQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Which replication is the best for our case ?  ("ben.play" <benjamin.cohen@playrion.com>)
Список pgsql-general

On Wed, Jul 1, 2015 at 7:08 AM, ben.play <benjamin.cohen@playrion.com> wrote:
In fact, the cron job will :
-> select about 10 000 lines from a big table (>100 Gb of data). 1 user has
about 10 lines.
-> each line will be examinate by an algorithm
-> at the end of each line, the cron job updates a few parameters for the
user (add some points for example)
-> Then, it inserts a line in another table to indicate to the user each
transaction.

All updates and inserts can be inserted ONLY by the cron job ...
Therefore ... the merge can be done easily : no one can be update these new
datas.

But ... how big company like Facebook or Youtube can calculate on (a)
dedicated server(s) without impacting users ?



--
View this message in context: http://postgresql.nabble.com/Which-replication-is-the-best-for-our-case-tp5855685p5856062.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


I'm assuming this query is really HUGE,
otherwise I can't see why it'd bring your database to halt, specially with that amount of main memory.

That aside, I don't see why you can't send inserts in small batches back to the master DB.

Regards.

В списке pgsql-general по дате отправления:

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: Which replication is the best for our case ?
Следующее
От: Jack Christensen
Дата:
Сообщение: Text to interval conversion can silently truncate data