i am trying to use postgresql to process queries on GPU using PG_strom. whenever i try to process queries i got issue:
postmaster has commanded this server process to roll back the current
transaction and exit, because another
server process exited abnormally and possibly corrupted shared memory.
i have checked that i have to increase shared buffer and work memory these are my current configuartions:
shared_buffers = 10GB
work_mem = 1GB
i want to know how can i increase them to its maximum limit as whenever i try to increase them i couldn't connect to postgresql.