* David F. Skoll <d...@roaringpenguin.com>: > On Fri, 29 Jul 2011 21:56:03 +0200 > Patrick Ben Koetter <p...@state-of-mind.de> wrote: > > > I am interested in write performance. How far could > > you take it before PSQL topped out? Any special hardware in use? > > We're not writing very much to PostgreSQL. For each message, we > write a small row containing the internal incident ID and how to train > it. (The actual Bayes tokens are not stored in PostgreSQL. We have > a special-purpose storage manager to handle that.)
That's where your product an SA differ, right? SA writes more to PostgreSQL e.g. it also stores Bayes tokens in PostgreSQL. > So no special PosgreSQL hardware required. We have sites peaking at > 15-20 million messages/day and PostgreSQL is not heavily loaded. That's ~230 msg/sec. Ever took it to 500 msg/sec? p@rick -- state of mind () http://www.state-of-mind.de Franziskanerstraße 15 Telefon +49 89 3090 4664 81669 München Telefax +49 89 3090 4666 Amtsgericht München Partnerschaftsregister PR 563
