Postgres Pro
Downloads
Home   >   mailing lists

Re: Using postgresql in situation with high write/read ratio - Mailing list pgsql-general

From Sergey Konoplev
Subject Re: Using postgresql in situation with high write/read ratio
Date
Msg-id AANLkTimU-+HrjwJReUtzxbrUq305vXXgCRwaanU-voqq@mail.gmail.com
Whole thread Raw
In response to Using postgresql in situation with high write/read ratio  (Odd Man <valodzka@gmail.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Thom Brown
Date:
Subject: Re: Using postgresql in situation with high write/read ratio
Next
From: akp geek
Date:
Subject: pg_toast_temp & pg_temp schemas