Re: proposal: integration bloat tables (indexes) to core - Mailing list pgsql-hackers

From Jim Nasby
Subject Re: proposal: integration bloat tables (indexes) to core
Date
Msg-id bb241e41-f4f6-f09a-032e-e8fc39677fc8@BlueTreble.com
Whole thread Raw
In response to Re: proposal: integration bloat tables (indexes) to core  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: proposal: integration bloat tables (indexes) to core
Re: proposal: integration bloat tables (indexes) to core
List pgsql-hackers
On 6/13/16 12:16 PM, Tom Lane wrote:
> At the same time, I'm pretty suspicious of putting stuff like this in
> core, because the expectations for cross-version compatibility go up
> by orders of magnitude as soon as we do that.

On a first go-round, I don't think we should add entire views, but 
rather functions that serve specific purposes. For table bloat that 
means a function that returns what the heap size should be based on 
pg_stats. For locking, it means providing information about which PID is 
blocking which PID. After that, most everything else is just window 
dressing.
-- 
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com
855-TREBLE2 (855-873-2532)   mobile: 512-569-9461



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: ORDER/GROUP BY expression not found in targetlist
Next
From: Andres Freund
Date:
Subject: Re: Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <