Postgres Pro
Downloads
Home   >   mailing lists

Re: Message queue table - strange performance drop with changing limit size. - Mailing list pgsql-performance

From Dimitri Fontaine
Subject Re: Message queue table - strange performance drop with changing limit size.
Date
Msg-id m2hbr4y9qt.fsf@hi-media.com
Whole thread Raw
In response to Message queue table - strange performance drop with changing limit size.  (Jesper Krogh <jesper@krogh.cc>)
List pgsql-performance
Tree view 
Jesper Krogh <jesper@krogh.cc> writes:
> I have a "message queue" table, that contains in the order of 1-10m
> "messages". It is implemented using TheSchwartz:
> http://search.cpan.org/~bradfitz/TheSchwartz-1.07/lib/TheSchwartz.pm

One way to approach queueing efficiently with PostgreSQL is to rely on
PGQ. New upcoming 3.0 version (alpha1 has been released) contains the
basics for having cooperative consumers, stable version (2.1.10) only
allows multiple consumers to all do the same work (think replication).

  http://wiki.postgresql.org/wiki/Skytools
  http://wiki.postgresql.org/wiki/PGQ_Tutorial

Regards,
--
dim

pgsql-performance by date:

Previous
From: Jesper Krogh
Date:
Subject: Re: Message queue table - strange performance drop with changing limit size.
Next
From: Greg Smith
Date:
Subject: Re: Message queue table - strange performance drop with changing limit size.