From: Nimesh Satam <nimesh.zedo@gmail.com>
To: pgsql-performance@postgresql.org
To: nimesh@zedo.com
Subject: Append Cost in query planners
Date: Sun, 28 Oct 2007 20:52:53 +0530
Message-ID: <965aa3ed0710280822x4d1ffc9dh74f67740fdcff5cb@mail.gmail.com> (raw)
All,
We are trying to implement partition on one tables on date basis. the
overall cost and timming and cost of the query is increasing on the Append
of the child table output. As shown below:
*-> Append (cost=0.00..112217.92 rows=2752906 width=52) (actual time=
2454.207..20712.021 rows=2752905 loops=1)
-> Seq Scan on trm (cost=0.00..28570.35 rows=1 width=52) (actual time=
2423.374..2423.374 rows=0 loops=1)
Filter: ((sqldate >= '2007-06-01 00:00:00'::timestamp without time zone)
AND (sqldate <= '2007-06-03 00:00:00'::timestamp without time zone))
-> Seq Scan on trm_d20070601 trm (cost=0.00..29203.41 rows=961094
width=52) (actual time=30.825..3027.217 rows=961094 loops=1)
Filter: ((sqldate >= '2007-06-01 00:00:00'::timestamp without time zone)
AND (sqldate <= '2007-06-03 00:00:00'::timestamp without time zone))
-> Seq Scan on trm_d20070602 trm (cost=0.00..27442.52 rows=903168
width=52) (actual time=11.142..2687.422 rows=903168 loops=1)
Filter: ((sqldate >= '2007-06-01 00:00:00'::timestamp without time zone)
AND (sqldate <= '2007-06-03 00:00:00'::timestamp without time zone))
-> Seq Scan on trm_d20070603 trm (cost=0.00..27001.64 rows=888643
width=52) (actual time=13.697..2568.012 rows=888643 loops=1)
Filter: ((sqldate >= '2007-06-01 00:00:00'::timestamp without time zone)
AND (sqldate <= '2007-06-03 00:00:00'::timestamp without time zone))*
Can someone let me know, how we can reduce the overall cost and time of the
append operation, and what parameters in the confirguration needs to be
changed?
Let me know if you need any further information to improve the query plan.
Regards,
Nimesh.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: nimesh.zedo@gmail.com, nimesh@zedo.com
Subject: Re: Append Cost in query planners
In-Reply-To: <965aa3ed0710280822x4d1ffc9dh74f67740fdcff5cb@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox