"Tim Yardley" <lst@openwrt.org> writes:
> postgres=# select count(*) from pg_timezone_names where utc_offset != '00:00';
> count
> -------
> 0
> postgres=# select count(*) from pg_timezone_names where utc_offset != '00:00';
> count
> -------
> 504
> postgres=# select count(*) from pg_timezone_names where utc_offset != '00:00';
> count
> -------
> 0
That's just bizarre ... IIRC the output of that view is computed by
scanning the timezone directories, and you wouldn't expect that to
change.
Can you strace the backend while it's doing this and see if there's a
difference in the series of kernel calls issued?
regards, tom lane