| From: | Sonam Sharma <sonams1209(at)gmail(dot)com> |
|---|---|
| To: | Thomas Munro <thomas(dot)munro(at)gmail(dot)com> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Shared memory error |
| Date: | 2020-06-04 13:00:18 |
| Message-ID: | CAM-M3T=YopyEaJ_cJ=pq+d0hDJ+5F0z6xZfmjx=DMVtKhF1uaA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
The dynamic_shared_memory_type was set to POSIX . Because of this it was
using tmpfs /dev/shm. When the query was running I saw the file system was
filling. So I extended the file system and luckily the query worked for
that time
On Thu, Jun 4, 2020, 5:12 PM Thomas Munro <thomas(dot)munro(at)gmail(dot)com> wrote:
> >> Do you see any other errors around this one, in the PostgreSQL logs?
> > No , only this is the error from db and jdbc end .. and queries are
> failing
>
> If you need a workaround right now you could always set
> max_parallel_workers_per_gather=0 so that it doesn't try to use
> parallel query. That could make some queries run more slowly.
>
> When you say you extended the /dev/shm filesystem, what are the mount
> options, or how did you configure it? It's interesting that the
> problem went away for a while when you did that.
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Matt Zagrabelny | 2020-06-04 14:21:27 | Re: Can we get SQL Server-like cross database queries |
| Previous Message | Thomas Munro | 2020-06-04 11:42:00 | Re: Shared memory error |