Re: [rfc] overhauling pgstat.stat - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: [rfc] overhauling pgstat.stat
Date
Msg-id 20130905052914.GA6067@eldon.alvh.no-ip.org
Whole thread Raw
In response to Re: [rfc] overhauling pgstat.stat  (Satoshi Nagayasu <snaga@uptime.jp>)
Responses Re: [rfc] overhauling pgstat.stat
Re: [rfc] overhauling pgstat.stat
List pgsql-hackers
Satoshi Nagayasu wrote:

> But, for now, I think we should have a real index for the
> statistics data because we already have several index storages,
> and it will allow us to minimize read/write operations.
> 
> BTW, what kind of index would be preferred for this purpose?
> btree or hash?

I find it hard to get excited about using the AM interface for this
purpose.  To me it makes a lot more sense to have separate, much
simpler code.  We don't need any transactionality, user defined types,
user defined operators, or anything like that.

-- 
Álvaro Herrera                http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services



pgsql-hackers by date:

Previous
From: wangshuo@highgo.com.cn
Date:
Subject: Re: Is it necessary to rewrite table while increasing thescale of datatype numeric?
Next
From: Atri Sharma
Date:
Subject: Re: [rfc] overhauling pgstat.stat