Re: Using postgresql in situation with high write/read ratio

Hi,

On 13 August 2010 00:09, Odd Man <valodzka@gmail.com> wrote:
> replaced with version two that uses partitions, truncate, copy and cleanup
> of old data once daily.

It makes me think that you have developed some rotation mechanism to
process incoming data. If so there is a batch-processing queue-based
solution called PgQ (start w/ it
http://wiki.postgresql.org/wiki/PGQ_Tutorial). The technology is
rather fast and smart IMHO.

--
Sergey Konoplev

Blog: http://gray-hemp.blogspot.com /
Linkedin: http://ru.linkedin.com/in/grayhemp /
JID/GTalk: gray.ru@gmail.com / Skype: gray-hemp / ICQ: 29353802