Re: Questions about 2 databases.

Поиск
Список
Период
Сортировка
От PFC
Тема Re: Questions about 2 databases.
Дата
Msg-id opsnh5vvs2th1vuj@localhost
обсуждение исходный текст
Ответ на Questions about 2 databases.  (jelle <jellej@pacbell.net>)
Список pgsql-performance

> My web app does lots of inserts that aren't read until a session is
> complete. The plan is to put the heavy insert session onto a ramdisk
> based pg-db and transfer the relevant data to the master pg-db upon
> session completion. Currently running 7.4.6.

    From what you say I'd think you want to avoid making one write
transaction to the main database on each page view, right ?
    You could simply store the data in a file, and at the end of the session,
read the file and do all the writes in one transaction.

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

Предыдущее
От: Josh Berkus
Дата:
Сообщение: Re: Postgres on RAID5
Следующее
От: PFC
Дата:
Сообщение: Re: Postgres on RAID5