Re: [GENERAL] please help understand freeing shared buffers

2012-01-06 Thread Filip RembiaƂkowski
2012/1/6 Tom Lane : > =?UTF-8?Q?Filip_Rembia=C5=82kowski?= writes: >> Among following queries, only THREE runs fast enough for me. >> I can't understand the logic behind this. > > I'm not sure why you'd expect real answers when you haven't shown us > what the query is doing, it is an UDF, encapsu

Re: [GENERAL] please help understand freeing shared buffers

2012-01-06 Thread Tom Lane
=?UTF-8?Q?Filip_Rembia=C5=82kowski?= writes: > Among following queries, only THREE runs fast enough for me. > I can't understand the logic behind this. I'm not sure why you'd expect real answers when you haven't shown us what the query is doing, but my first thought is that the discrepancy comes

[GENERAL] please help understand freeing shared buffers

2012-01-06 Thread Filip RembiaƂkowski
Among following queries, only THREE runs fast enough for me. I can't understand the logic behind this. I once thought that shared buffers replacement is independent from whether the backend which used it is still alive. But is it true? Seems like shared buffers are "returned to the pool" or "fr