Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-06-20 Thread Haribabu Kommi
On Thu, May 8, 2014 at 10:00 AM, Jaime Casanova wrote: > Hi, > > This patch implements $subject only when ANALYZE and VERBOSE are on. > I made it that way because for years nobody seemed interested in this > info (at least no one did it) so i decided that maybe is to much > information for most pe

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-09 Thread Jaime Casanova
On Thu, May 8, 2014 at 10:44 PM, Amit Kapila wrote: > On Thu, May 8, 2014 at 12:01 PM, Jaime Casanova wrote: >> On Wed, May 7, 2014 at 10:52 PM, Amit Kapila wrote: >>> >>> Why to capture only for Index Insert/Update and not for Read; is it >>> because Read will be always fast ot implementation c

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-09 Thread Thom Brown
On 8 May 2014 01:00, Jaime Casanova wrote: > Hi, > > This patch implements $subject only when ANALYZE and VERBOSE are on. > I made it that way because for years nobody seemed interested in this > info (at least no one did it) so i decided that maybe is to much > information for most people (actua

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-08 Thread Craig Ringer
On 05/08/2014 08:04 AM, Jaime Casanova wrote: > Maybe is not the right term... i mean: the time that take to update > indexes on an INSERT/UPDATE operation That'd be a big plus IMO, especially for expensive GiST or GIN index updates. -- Craig Ringer http://www.2ndQuadrant.com/

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-08 Thread David G Johnston
Robert Haas wrote > On Thu, May 8, 2014 at 2:31 AM, Jaime Casanova < > jaime@ > > wrote: >> On Wed, May 7, 2014 at 10:52 PM, Amit Kapila < > amit.kapila16@ > > wrote: >>> On Thu, May 8, 2014 at 5:30 AM, Jaime Casanova < > jaime@ > > wrote: >> >>QUERY PLAN >> --

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-08 Thread Amit Kapila
On Thu, May 8, 2014 at 12:01 PM, Jaime Casanova wrote: > On Wed, May 7, 2014 at 10:52 PM, Amit Kapila wrote: >> >> Why to capture only for Index Insert/Update and not for Read; is it >> because Read will be always fast ot implementation complexity? >> > > EXPLAIN ANALYZE already shows that on any

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-08 Thread Jaime Casanova
On Thu, May 8, 2014 at 10:41 AM, Robert Haas wrote: > On Thu, May 8, 2014 at 2:31 AM, Jaime Casanova wrote: >> On Wed, May 7, 2014 at 10:52 PM, Amit Kapila wrote: >>> On Thu, May 8, 2014 at 5:30 AM, Jaime Casanova >>> wrote: Hi, This patch implements $subject only when ANALYZE a

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-08 Thread Robert Haas
On Thu, May 8, 2014 at 2:31 AM, Jaime Casanova wrote: > On Wed, May 7, 2014 at 10:52 PM, Amit Kapila wrote: >> On Thu, May 8, 2014 at 5:30 AM, Jaime Casanova wrote: >>> Hi, >>> >>> This patch implements $subject only when ANALYZE and VERBOSE are on. >>> I made it that way because for years nobod

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-07 Thread Jaime Casanova
On Wed, May 7, 2014 at 10:52 PM, Amit Kapila wrote: > On Thu, May 8, 2014 at 5:30 AM, Jaime Casanova wrote: >> Hi, >> >> This patch implements $subject only when ANALYZE and VERBOSE are on. >> I made it that way because for years nobody seemed interested in this >> info (at least no one did it) s

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-07 Thread Amit Kapila
On Thu, May 8, 2014 at 5:30 AM, Jaime Casanova wrote: > Hi, > > This patch implements $subject only when ANALYZE and VERBOSE are on. > I made it that way because for years nobody seemed interested in this > info (at least no one did it) so i decided that maybe is to much > information for most peo

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-07 Thread Jaime Casanova
On Wed, May 7, 2014 at 7:03 PM, Josh Berkus wrote: > On 05/07/2014 05:00 PM, Jaime Casanova wrote: >> Hi, >> >> This patch implements $subject only when ANALYZE and VERBOSE are on. >> I made it that way because for years nobody seemed interested in this >> info (at least no one did it) so i decide

Re: [HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-07 Thread Josh Berkus
On 05/07/2014 05:00 PM, Jaime Casanova wrote: > Hi, > > This patch implements $subject only when ANALYZE and VERBOSE are on. > I made it that way because for years nobody seemed interested in this > info (at least no one did it) so i decided that maybe is to much > information for most people (act

[HACKERS] [WIP] showing index maintenance on EXPLAIN

2014-05-07 Thread Jaime Casanova
Hi, This patch implements $subject only when ANALYZE and VERBOSE are on. I made it that way because for years nobody seemed interested in this info (at least no one did it) so i decided that maybe is to much information for most people (actually btree indexes are normally very fast). But because