Re: [HACKERS] Hash Functions

Поиск
Список
Период
Сортировка
Искать
От
Peter Eisentraut
Тема
Re: [HACKERS] Hash Functions
Дата
в 02:36:07
Msg-id
7b19f4e4-a672-517c-44b4-9a6388061593@2ndquadrant.com
Ответ на
Список
Дерево обсуждения
[HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Joe Conway <mail@joeconway.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Hash Functions Joe Conway <mail@joeconway.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Hash Functions Kenneth Marshall <ktm@rice.edu>
Re: [HACKERS] Hash Functions Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions amul sul <sulamul@gmail.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions amul sul <sulamul@gmail.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions amul sul <sulamul@gmail.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions amul sul <sulamul@gmail.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Hash Functions amul sul <sulamul@gmail.com>
Re: [HACKERS] Hash Functions amul sul <sulamul@gmail.com>
Re: [HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Joe Conway <mail@joeconway.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Hash Functions Alvaro Herrera <alvherre@2ndquadrant.com>
Re: [HACKERS] Hash Functions Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Hash Functions David Fetter <david@fetter.org>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Hash Functions Kenneth Marshall <ktm@rice.edu>
Re: [HACKERS] Hash Functions Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Amit Kapila <amit.kapila16@gmail.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] Hash Functions Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Hash Functions Peter Geoghegan <pg@bowt.ie>
Re: [HACKERS] Hash Functions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Greg Stark <stark@mit.edu>
Re: [HACKERS] Hash Functions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Hash Functions Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions Bruce Momjian <bruce@momjian.us>
Re: [HACKERS] Hash Functions Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Hash Functions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Andres Freund <andres@anarazel.de>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions David Fetter <david@fetter.org>
Re: [HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions David Fetter <david@fetter.org>
Re: [HACKERS] Hash Functions Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions Amit Langote <Langote_Amit_f8@lab.ntt.co.jp>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Tom Lane <tgl@sss.pgh.pa.us>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
[HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions Robert Haas <robertmhaas@gmail.com>
Re: [HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions Ashutosh Bapat <ashutosh.bapat@enterprisedb.com>
Re: [HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions Mark Dilger <hornschnorter@gmail.com>
Re: [HACKERS] Hash Functions David Fetter <david@fetter.org>
Re: [HACKERS] Hash Functions Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Hash Functions Thomas Munro <thomas.munro@enterprisedb.com>
Re: [HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
Re: [HACKERS] Hash Functions Jeff Davis <pgsql@j-davis.com>
On 5/16/17 11:10, Jeff Davis wrote:
> I concur at this point. I originally thought hash functions might be
> made portable, but I think Tom and Andres showed that to be too
> problematic -- the issue with different encodings is the real killer.

I think it would be OK that if you want to move a hash-partitioned table
to a database with a different encoding, you have to do dump/restore
through the parent table.  This is quite similar to what you have to do
now if you want to move a range-partitioned table to a database with a
different locale.

-- 
Peter Eisentraut              http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services


В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
От: Andrew Dunstan
Дата:
FAQ