I got one huge query to run on postgresql 10.6.
The server got 64GB ram.
The pgadmin4 always show out of memory for this query.
The ulimit of memory for postgres user is unlimited.
However, the swap is not using by postgresql all the time.