crosstab

2023-03-09 Thread Rosebrock, Uwe (Environment, Hobart)
Can I pass an array to crosstab row labels Cheers Uwe

Re: Work hours?

2019-08-28 Thread Uwe Seher
of the month/year to a date and feed it into the series.* *Bye Uwe* Am Mi., 28. Aug. 2019 um 00:27 Uhr schrieb stan : > I am just starting to explore the power of PostgreSQL's time and date > functionality. I must say they seem very powerful. > > I need to write a function that, g

Re: postgresql 9.5 has ocuuered OOM

2017-12-20 Thread Uwe
On Wednesday, December 20, 2017 9:59:24 AM PST David G. Johnston wrote: > On Wed, Dec 20, 2017 at 9:44 AM, Uwe <u...@oss4u.com> wrote: > > IIRC work_mem is a PER CONNECTION setting, > > ​The docs for this setting clearly state that a single connection/session > can i

Re: postgresql 9.5 has ocuuered OOM

2017-12-20 Thread Uwe
On Wednesday, December 20, 2017 11:08:51 PM PST mark wrote: > I have set shared_buffers is 1/4 of memory. > work_mem is 2% of memory. > max_connections is 50. > momery size is 16GB. > postgresql process used over 70% of memory and occuered OOM. > what should I do to deal with this problem? IIRC