[PERFORM] query plan estimate

2013-03-31 Thread pg noob
Hi all, I'm looking at this query plan, an excerpt of which is shown here, and I am just wondering how the estimated cost for the Nested Loop is calculated? -> Nested Loop (*cost=0.00..2888.16* rows=240 width=16) (actual time=0.034..2.180 rows=91 loops=1) Output: public.mg.lctime, public.

[PERFORM] pg_buffercache

2012-11-01 Thread pg noob
Hi all, I was wondering if it is safe to install pg_buffercache on production systems? Thank you.

[PERFORM] deadlock_timeout affect on performance

2012-10-02 Thread pg noob
Hi all, I have a question about the deadlock_timeout in regards to performance. Right now we have this timeout set at its default of 1s. My understanding of it is that this means that every 1 second the server will check for deadlocks. What I am wondering is how much of a performance improvement w