всего в табличке 1186 строк, но там овердофига posix'а (593 строки, т. е. ровно половина %)
> select * from (select utc_offset, count(*) from pg_timezone_names where name not like '%posix%' group by utc_offset order by utc_offset) as t order by count desc;
utc_offset | count
------------+-------
-04:00:00 | 65
02:00:00 | 57
03:00:00 | 49
-03:00:00 | 45
-05:00:00 | 42
00:00:00 | 38
01:00:00 | 32
-06:00:00 | 29
08:00:00 | 29
10:00:00 | 22
-07:00:00 | 22
07:00:00 | 14
05:00:00 | 14
12:00:00 | 13
04:00:00 | 13
11:00:00 | 11
-08:00:00 | 11
06:00:00 | 11
09:00:00 | 10
13:00:00 | 8
-10:00:00 | 8
09:30:00 | 6
-09:00:00 | 6
-02:00:00 | 6
-11:00:00 | 6
14:00:00 | 3
05:30:00 | 3
06:30:00 | 2
05:45:00 | 2
03:30:00 | 2
-01:00:00 | 2
10:30:00 | 2
-02:30:00 | 2
13:45:00 | 2
-12:00:00 | 1
08:45:00 | 1
04:30:00 | 1
11:30:00 | 1
-04:30:00 | 1
-09:30:00 | 1
так и живём %)
