On Mon, Feb 3, 2014 at 1:35 PM, Pweaver (Paul Weaver)
wrote:
> We have been running into a (live lock?) issue on our production Postgres
> instance causing queries referencing a particular table to become extremely
> slow and our application to lock up.
Livelock? Really? That would imply that the
On Thu, Jan 30, 2014 at 2:43 PM, Dattaram Porob
wrote:
>
> Looks like this memory is being used to cache the query plan. Any ideas, why
> it is occupying such a huge heap in 9.2.6 as compared to 9.1.3 ? I know that
> the same SQL function occupies around 25MB heap in 9.1.3.
>
> Any thoughts/commen
Hi,
I am not sure if it is bug or not but I found some strange behaviour. Maybe
it is the same as described on
http://www.postgresql.org/message-id/14616.1244317...@sss.pgh.pa.us ?). If
yes - I'm sorry for the trouble, but I think that my example is more
obvious.
Tested on PostgreSQL 9.2.4
We have been running into a (live lock?) issue on our production Postgres
instance causing queries referencing a particular table to become extremely
slow and our application to lock up.
This tends to occur on a particular table that gets a lot of queries
against it after a large number of deletes
