Re: Global Sequences
От
Andres Freund
Тема
Re: Global Sequences
Дата
Msg-id
201210161515.54895.andres@2ndquadrant.com
Ответ на
Re: Global Sequences (Andrew Dunstan)
Список
Дерево обсуждения
Global Sequences Simon Riggs <simon@2ndQuadrant.com>
Re: Global Sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: Global Sequences Simon Riggs <simon@2ndQuadrant.com>
Re: Global Sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: Global Sequences Markus Wanner <markus@bluegap.ch>
Re: Global Sequences Simon Riggs <simon@2ndQuadrant.com>
Re: Global Sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: Global Sequences Robert Haas <robertmhaas@gmail.com>
Re: Global Sequences Tom Lane <tgl@sss.pgh.pa.us>
Re: Global Sequences Simon Riggs <simon@2ndQuadrant.com>
Re: Global Sequences Simon Riggs <simon@2ndQuadrant.com>
Re: Global Sequences Simon Riggs <simon@2ndQuadrant.com>
Re: Global Sequences Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: Global Sequences Simon Riggs <simon@2ndquadrant.com>
Re: Global Sequences Dimitri Fontaine <dimitri@2ndQuadrant.fr>
Re: Global Sequences Josh Berkus <josh@agliodbs.com>
Re: Global Sequences Stephen Frost <sfrost@snowman.net>
Re: Global Sequences Josh Berkus <josh@agliodbs.com>
Re: Global Sequences Stephen Frost <sfrost@snowman.net>
Re: Global Sequences Michael Paquier <michael.paquier@gmail.com>
Re: Global Sequences Markus Wanner <markus@bluegap.ch>
Re: Global Sequences Simon Riggs <simon@2ndQuadrant.com>
Re: Global Sequences Markus Wanner <markus@bluegap.ch>
Re: Global Sequences Simon Riggs <simon@2ndQuadrant.com>
Re: Global Sequences Markus Wanner <markus@bluegap.ch>
Re: Global Sequences Simon Riggs <simon@2ndQuadrant.com>
Re: Global Sequences Yeb Havinga <yebhavinga@gmail.com>
Re: Global Sequences Peter Eisentraut <peter_e@gmx.net>
Re: Global Sequences Andrew Dunstan <andrew@dunslane.net>
Re: Global Sequences Andres Freund <andres@2ndquadrant.com>
Re: Global Sequences Simon Riggs <simon@2ndQuadrant.com>
Re: Global Sequences Peter Eisentraut <peter_e@gmx.net>
Re: Global Sequences Simon Riggs <simon@2ndQuadrant.com>
Re: Global Sequences Daniel Farina <daniel@heroku.com>
Re: Global Sequences Daniel Farina <daniel@heroku.com>
Re: Global Sequences Christopher Browne <cbbrowne@gmail.com>
Re: Global Sequences Stephen Frost <sfrost@snowman.net>
Re: Global Sequences Simon Riggs <simon@2ndQuadrant.com>
On Tuesday, October 16, 2012 02:58:11 PM Andrew Dunstan wrote: > On 10/16/2012 08:54 AM, Peter Eisentraut wrote: > > Option 4 is of course to use UUIDs. > > Yeah, I was wondering what this would really solve that using UUIDs > wouldn't solve. Large indexes over random values perform notably worse than mostly/completely ordered ones as they can be perfectly packed. Beside the fact that uuids have 2/4 times the storage overhead of int4/int8. That has influences both in query and modification performance. Also, not allowing plainly numeric pk's makes porting an application pretty annoying... Greetings, Andres -- Andres Freund http://www.2ndQuadrant.com/PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-hackers по дате отправления
