Re: [PERFORM] 60 core performance with 9.3

2014-07-31 Thread Alvaro Herrera
Matt Clarkson wrote: > The LWLOCK_STATS below suggest that ProcArrayLock might be the main > source of locking that's causing throughput to take a dive as the client > count increases beyond the core count. > Any thoughts or comments on these results are welcome! Do these results change if you u

Re: [PERFORM] [ADMIN] Setting a default format for timestamp

2014-07-31 Thread Scott Whitney
_Where_ do you want that default format? Are you asking about a field? psql output? The O/S? What you're asking might be as simple as "datestyle," if you're just talking the output mask: http://www.postgresql.org/docs/9.1/static/runtime-config-client.html DateStyle ( string ) Sets the di

[PERFORM] Setting a default format for timestamp

2014-07-31 Thread Ferrell, Denise CTR NSWCDD, Z11
Hi All, Using PostgreSQL 9.3 on Linux Red-Hat platform. How would I go about setting a default format for the timestamp? I've set the default for TimeZone to UTC. Thank you in advance for any information. DF -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To m