Re: proposal: integration bloat tables (indexes) to core

Поиск
Список
Период
Сортировка
От Jim Nasby
Тема Re: proposal: integration bloat tables (indexes) to core
Дата
Msg-id bb241e41-f4f6-f09a-032e-e8fc39677fc8@BlueTreble.com
обсуждение исходный текст
Ответ на Re: proposal: integration bloat tables (indexes) to core  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: proposal: integration bloat tables (indexes) to core  (Pavel Stehule <pavel.stehule@gmail.com>)
Re: proposal: integration bloat tables (indexes) to core  (Vik Fearing <vik@2ndquadrant.fr>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: ERROR: ORDER/GROUP BY expression not found in targetlist
Следующее
От: Andres Freund
Дата:
Сообщение: Re: Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold <