Re: RangeType internal use
От | Noah Misch |
---|---|
Тема | Re: RangeType internal use |
Дата | |
Msg-id | 20150210072625.GA3788028@tornado.leadboat.com обсуждение исходный текст |
Ответ на | Re: RangeType internal use (Tom Lane <tgl@sss.pgh.pa.us>) |
Список | pgsql-hackers |
On Mon, Feb 09, 2015 at 12:37:05PM -0500, Tom Lane wrote: > Robert Haas <robertmhaas@gmail.com> writes: > > Yeah, but people expect to be able to partition on ranges that are not > > all of equal width. I think any proposal that we shouldn't support > > that is the kiss of death for a feature like this - it will be so > > restricted as to eliminate 75% of the use cases. > > Well, that's debatable IMO (especially your claim that variable-size > partitions would be needed by a majority of users). I don't know about user wishes directly, though I do suspect fixed partition stride would cover more than 25% of uses cases. I do know that SQL Server, Oracle and MySQL have variable-stride range partitioning, and none of them have fixed-stride range partitioning. So, like Heikki and Robert, I would bet on variable-stride range partitioning.
В списке pgsql-hackers по дате отправления: