Using PG 9.0 and given 2 queries (messageq_current is a view on the
messageq_table):
select entity_id from messageq_current
where entity_id = 123456;
select entity_id from messageq_current
where incoming = true
and inactive = false
and staff_ty = 2
and staff_id = 2
order by entity_id desc
limit
This has been reposted to this list from the pgsql-hackers list, at
the request of Josh Berkus. Hopefully there will be more interest
here.
-- Forwarded message --
From: Peter Geoghegan
Date: 29 July 2012 16:39
Subject: Help me develop new commit_delay advice
To: PG Hackers
Man
Russell Keane wrote:
> Clearly the statistics are off somehow but I really don't know
> where to start.
>
> Any help you can give me would be very much appreciated.
It would help to know your more about your hardware and PostgreSQL
configuration. The latter can probably best be communicated
