Re: [GENERAL] Doubts on startup costs

2014-03-31 Thread Rajeev rastogi
tify the sender by phone or email immediately and delete it! From: pgsql-general-ow...@postgresql.org [mailto:pgsql-general-ow...@postgresql.org] On Behalf Of Jayadevan M Sent: 30 March 2014 20:45 To: pgsql-general@postgresql.org Subject: [GENERAL] Doubts on startup costs Hi, A few academic

[GENERAL] Doubts on startup costs

2014-03-30 Thread Jayadevan M
Hi, A few academic questions related PostgreSQL query planner and output - In the output of EXPLAIN for SQL statements I have seen so far, the startup cost for the innermost node/leaf has been 0. Are there situations where it may be non-zero? The startup costs for outer nodes will always be equa