Re: [GENERAL] Accessing pg_timezone_names system view

2007-08-17 Thread Magnus Hagander
On Fri, Aug 17, 2007 at 11:51:52PM +1000, Naz Gassiep wrote: > I was wondering if there is any reason that accessing the system view > pg_timezone_names is extremely slow relative to other queries. The > following query: > >SELECT * FROM pg_timezone_names; > > Executes in between 29ms and 3

[GENERAL] Accessing pg_timezone_names system view

2007-08-17 Thread Naz Gassiep
I was wondering if there is any reason that accessing the system view pg_timezone_names is extremely slow relative to other queries. The following query: SELECT * FROM pg_timezone_names; Executes in between 29ms and 32ms on my server. It takes about the same when I put a WHERE name =