Re: Using 128-bit integers for sum, avg and statistics aggregates

Поиск
Список
Период
Сортировка
Искать
От
Andres Freund
Тема
Re: Using 128-bit integers for sum, avg and statistics aggregates
Дата
Msg-id
50949B74-A45E-4D00-A4D2-373CD88B5E29@2ndquadrant.com
Ответ на
Список
Дерево обсуждения
[WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Alvaro Herrera <alvherre@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Oskari Saarenmaa <os@ohmu.fi>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Peter Eisentraut <peter_e@gmx.net>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates David Rowley <dgrowleyml@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@anarazel.de>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Tom Lane <tgl@sss.pgh.pa.us>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@anarazel.de>
Re: Using 128-bit integers for sum, avg and statistics aggregates Petr Jelinek <petr@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates David Rowley <dgrowleyml@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Robert Haas <robertmhaas@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates David Rowley <dgrowleyml@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Tom Lane <tgl@sss.pgh.pa.us>
Re: Using 128-bit integers for sum, avg and statistics aggregates Heikki Linnakangas <hlinnakangas@vmware.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Tom Lane <tgl@sss.pgh.pa.us>
Re: Using 128-bit integers for sum, avg and statistics aggregates Jim Nasby <Jim.Nasby@BlueTreble.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Claudio Freire <klaussfreire@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Petr Jelinek <petr@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Peter Geoghegan <pg@heroku.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Petr Jelinek <petr@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates David Fetter <david@fetter.org>
Re: Using 128-bit integers for sum, avg and statistics aggregates Petr Jelinek <petr@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Petr Jelinek <petr@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Peter Geoghegan <pg@heroku.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Peter Geoghegan <pg@heroku.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Petr Jelinek <petr@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Petr Jelinek <petr@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Peter Geoghegan <pg@heroku.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Peter Geoghegan <pg@heroku.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Peter Geoghegan <pg@heroku.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Peter Geoghegan <pg@heroku.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Tom Lane <tgl@sss.pgh.pa.us>
Re: Using 128-bit integers for sum, avg and statistics aggregates Michael Paquier <michael.paquier@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates David Rowley <dgrowleyml@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Michael Paquier <michael.paquier@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Michael Paquier <michael.paquier@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Petr Jelinek <petr@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Petr Jelinek <petr@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Michael Paquier <michael.paquier@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates David Rowley <dgrowley@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Peter Geoghegan <pg@heroku.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Peter Geoghegan <pg@heroku.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Michael Paquier <michael.paquier@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: Using 128-bit integers for sum, avg and statistics aggregates Robert Haas <robertmhaas@gmail.com>
Re: Using 128-bit integers for sum, avg and statistics aggregates Michael Paquier <michael.paquier@gmail.com>
Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Merlin Moncure <mmoncure@gmail.com>
Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Arthur Silva <arthurprs@gmail.com>
Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Heikki Linnakangas <hlinnakangas@vmware.com>
Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Andres Freund <andres@2ndquadrant.com>
Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Tom Lane <tgl@sss.pgh.pa.us>
Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Heikki Linnakangas <hlinnakangas@vmware.com>
Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Heikki Linnakangas <hlinnakangas@vmware.com>
Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
Re: [WIP Patch] Using 128-bit integers for sum, avg and statistics aggregates Andreas Karlsson <andreas@proxel.se>
On March 22, 2015 10:34:04 AM GMT+01:00, Michael Paquier  wrote:
>On Sun, Mar 22, 2015 at 6:22 PM, Andres Freund 
>wrote:
>> On March 22, 2015 6:17:28 AM GMT+01:00, Michael Paquier
> wrote:
>>>On Sun, Mar 22, 2015 at 12:32 AM, Tom Lane  wrote:
>>>> Andres Freund  writes:
>>>>> Pushed with that additional change. Let's see if the buildfarm
>>>thinks.
>>>>
>>>> jacana, apparently alone among buildfarm members, does not like it.
>>>
>>>All the windows nodes don't pass tests with this patch, the
>difference
>>>is in the exponential precision: e+000 instead of e+00.
>>
>> That's due to a different patch though, right? When I checked earlier
>only jacana had problems due to this, and it looked like random memory
>was being output. It's interesting that that's on the one windows (not
>cygwin) critter that does the 128bit dance...
>
>Yes, sorry, the e+000 stuff is from 959277a. This patch has visibly
>broken that:
>http://buildfarm.postgresql.org/cgi-bin/show_log.pl?nm=jacana&dt=2015-03-21%2003%3A01%3A21

That's the stuff looking like random memory that I talk about above...

-- 
Please excuse brevity and formatting - I am writing this on my mobile phone.

Andres Freund	                   http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Training & Services


В списке pgsql-hackers по дате отправления
От: David Rowley
Дата:
От: Michael Paquier
Дата:
FAQ