Re: Query error: could not resize shared memory segment

2018-01-02 Thread Thomas Munro
rror is working as designed. You could figure out how to fix the mount options, or you could disable parallelism with max_parallel_workers_per_gather = 0. -- Thomas Munro http://www.enterprisedb.com

Re: Error when compiling postgresql 9.6.7 with Visual Studio 15.5.6

2018-02-19 Thread Thomas Munro
solveLocaleName("foo", output_buffer, output_buffer_size) would be the same as locale->locinfo->local_name[LC_TYPE] on the result of _create_locale(LC_CTYPE, "foo"). https://msdn.microsoft.com/en-us/library/windows/desktop/dd319112(v=vs.85).aspx -- Thomas Munro http://www.enterprisedb.com

Re: Query error: could not resize shared memory segment

2018-02-23 Thread Thomas Munro
On Wed, Jan 3, 2018 at 6:34 PM, Tom Lane wrote: > Thomas Munro writes: >> On Wed, Jan 3, 2018 at 6:13 PM, Thuc Nguyen Canh >> wrote: >>> mount | grep /dev/shm >>> => shm on /dev/shm type tmpfs (rw,nosuid,nodev,noexec,relatime,size=65536k) > >> Bi

Re: Unexpected behavior with transition tables in update statement trigger

2018-02-26 Thread Thomas Munro
lance the attached seems to fix the problem, but I'll need to look more carefully tomorrow. -- Thomas Munro http://www.enterprisedb.com named-tuplestore-scan-select.patch Description: Binary data

Re: Naive question about multithreading/multicore

2024-10-12 Thread Thomas Munro
On Sun, Oct 13, 2024 at 6:31 AM Marc SCHAEFER wrote: > template1=> SELECT COUNT(*) FROM pg_class a, pg_class b, pg_class c; > > I see only one 100% CPU PostgreSQL process. If you set set min_parallel_table_scan_size = 0 then it uses parallelism, and completes much faster. The planner generally w

Re: Getting PSQL in Windows to support TAB/Autocomplete via modified readline...

2024-10-07 Thread Thomas Munro
Hi Kirk, Just as an FYI since you were working in this area, Tom has just knocked off one of the blockers for tab completion on Windows, namely that MSVC didn't like the overgrown if-then-else code in tab-complete.c[1]. That is now fixed in PostgreSQL's master branch[2][3][4] (v18 to be). [1] h

Re: Running docker in postgres, SHM size of the docker container in postgres 16

2024-11-19 Thread Thomas Munro
On Wed, Nov 20, 2024 at 11:22 AM Koen De Groote wrote: > Why would that be? It's the exact same data. The install is about 50GB in > size. Is there something wrong with postgres 16, or did some settings > significantly change, that I need to know about? I went over all the > changelogs, nothing

Re: Issues with EPOCH-s, TIMESTAMP(TZ)-s and leap seconds.

2025-01-27 Thread Thomas Munro
On Tue, Jan 28, 2025 at 10:02 AM Nem Tudom wrote: > Any help, advice, recommendations, URL-s, references &c. appreciated. As others have said, we're using the POSIX AKA Unix time scale, as almost all general purpose computer systems do. It's based on the UTC time scale (the one that has SI secon

<    1   2   3