Hi,
I have a question about partition table query performance in postgresql, it's
an old version 8.3.21, I know it's already out of support. so any words about
the reason for the behavior would be very much appreciated.
I have a partition table which name is test_rank_2014_monthly and it has 7
Huang, Suya wrote
Hi,
I have a question about partition table query performance in postgresql,
it's an old version 8.3.21, I know it's already out of support. so any
words about the reason for the behavior would be very much appreciated.
I have a partition table which name is
Huang, Suya suya.hu...@au.experian.com writes:
I have a question about partition table query performance in postgresql, it's
an old version 8.3.21, I know it's already out of support. so any words about
the reason for the behavior would be very much appreciated.
I have a partition table
-Original Message-
From: Tom Lane [mailto:t...@sss.pgh.pa.us]
Sent: Thursday, August 21, 2014 12:13 AM
To: Huang, Suya
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] query on parent partition table has bad performance
Huang, Suya suya.hu...@au.experian.com writes:
I have
Huang, Suya suya.hu...@au.experian.com writes:
For the first point you made, you're right. The real execution time varies a
lot from the explain analyze, the query on parent table are just as fast as
it is on the child table. is this a bug of explain analyze command? While we
reading the
