Re: UPDATES hang every 5 minutes

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: UPDATES hang every 5 minutes
Дата
Msg-id 46BCA8E4.1010902@pinpointresearch.com
обсуждение исходный текст
Ответ на Re: UPDATES hang every 5 minutes  (Marc Rossi <marc_rossi@yahoo.com>)
Список pgsql-general
> It seems to me that the real solution is for me to stop using the database as an IPC system to pass somewhat
time-criticaldata between processes.  Given the time constraints I'm working under this unfortunately was the quickest
route.

At least for the first 5 minutes. :) I was wondering about that 1,500
updates/second. PostgreSQL is probably not the optimal solution for IPC.

If you are trying to deal with passing this data among machines,
memcached may be a good solution. Pretty easy to configure and clients
for lots of languages. Blazing fast, too.

Cheers,
Steve


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

Предыдущее
От: Raymond O'Donnell
Дата:
Сообщение: Re: Timestamp in pg_dump output, was Re: How I can know a back up database is up to date
Следующее
От: Mary Ellen Fitzpatrick
Дата:
Сообщение: PITR for postgresql-7.3