Re: Is there a significant difference in Memory settings between 9.5 and 12

On Mon, May 11, 2020 at 10:55 PM Tory M Blue wrote: > > > On Mon, May 11, 2020 at 9:01 PM Thomas Munro > wrote: > >> On Tue, May 12, 2020 at 2:52 PM Tory M Blue wrote: >> > It took the change but didn't help. So 10GB of shared_buffers in 12 is >> still a no go. I'm down to 5GB and it works, but

Re: Is there a significant difference in Memory settings between 9.5 and 12

On Mon, May 11, 2020 at 11:09 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Monday, May 11, 2020, David G. Johnston > wrote: > >> Repost, edited subject by mistake... >> >> On Monday, May 11, 2020, Tory M Blue wrote: >>> >>> And just to repeat. Same exact hardware, same kernel,

Re: Is there a significant difference in Memory settings between 9.5 and 12

On Monday, May 11, 2020, David G. Johnston wrote: > Repost, edited subject by mistake... > > On Monday, May 11, 2020, Tory M Blue wrote: >> >> And just to repeat. Same exact hardware, same kernel, nothing more than >> installing the latest postgres12, copying my config files from 9.5 to 12 >> an

Re: Is there a significant difference in Memory settings between 9.5 and 12

Repost, edited subject by mistake... On Monday, May 11, 2020, Tory M Blue wrote: > > And just to repeat. Same exact hardware, same kernel, nothing more than > installing the latest postgres12, copying my config files from 9.5 to 12 > and running the pg_upgrade. > You’ll want to remove the pg_upg

Re: Is there a significant difference in Memory settings between 9.5 and 12.

On Monday, May 11, 2020, Tory M Blue wrote: > > > And just to repeat. Same exact hardware, same kernel, nothing more than > installing the latest postgres12, copying my config files from 9.5 to 12 > and running the pg_upgrade. > You’ll want to remove the pg_upgrade from the equation and try v12

Re: Is there a significant difference in Memory settings between 9.5 and 12

On Mon, May 11, 2020 at 9:01 PM Thomas Munro wrote: > On Tue, May 12, 2020 at 2:52 PM Tory M Blue wrote: > > It took the change but didn't help. So 10GB of shared_buffers in 12 is > still a no go. I'm down to 5GB and it works, but this is the same hardware, > the same exact 9.5 configuration. So

Re: Is there a significant difference in Memory settings between 9.5 and 12

On Mon, May 11, 2020 at 9:57 PM Tom Lane wrote: > Tory M Blue writes: > > That may be the next step in the lab, but was hoping someone knew of a > > significant difference. > > I think we've made it perfectly clear that we don't. There's something > odd about your situation. > >

Re: Is there a significant difference in Memory settings between 9.5 and 12

Tory M Blue writes: > That may be the next step in the lab, but was hoping someone knew of a > significant difference. I think we've made it perfectly clear that we don't. There's something odd about your situation. regards, tom lane

Re: Is there a significant difference in Memory settings between 9.5 and 12

On Mon, May 11, 2020 at 7:57 PM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Monday, May 11, 2020, Tory M Blue wrote: > >> I'll keep digging, but i'm hesitant to do my multiple TB db's with half of their shared buffer configs, until I understand what 12 is doing different

Re: Is there a significant difference in Memory settings between 9.5 and 12

On Tue, May 12, 2020 at 2:52 PM Tory M Blue wrote: > It took the change but didn't help. So 10GB of shared_buffers in 12 is still > a no go. I'm down to 5GB and it works, but this is the same hardware, the > same exact 9.5 configuration. So I'm missing something. WE have not had to > mess with

Re: Is there a significant difference in Memory settings between 9.5 and 12

On Monday, May 11, 2020, Tory M Blue wrote: > I'll keep digging, but i'm hesitant to do my multiple TB db's with half of >>> their shared buffer configs, until I understand what 12 is doing >>> differently than 9.5 >> >> Maybe run your test suite on 9.6, 10, and 11 to see if it is indeed new to 1

Re: Is there a significant difference in Memory settings between 9.5 and 12

On Mon, May 11, 2020 at 2:08 PM Tory M Blue wrote: > > > On Mon, May 11, 2020 at 1:36 PM Tom Lane wrote: > >> Tory M Blue writes: >> > 12 will not start at 10GB, even though it's the same hardware, same >> config >> > file, same physical box, same everything, just version 12 vs 9.5 >> >> For me

Re: Is there a significant difference in Memory settings between 9.5 and 12

Tory M Blue writes: > Okay the one difference I see in settings is this little gem in 12.. > shared_memory_type mmap Well, v12 is just exposing a switch for something that was hard-wired before. But now I wonder if your 9.5 installation could've been compiled to force it to use SysV shmem instea

Re: Is there a significant difference in Memory settings between 9.5 and 12

On 5/11/20 1:42 PM, Tory M Blue wrote: On Mon, May 11, 2020 at 1:36 PM Tom Lane > wrote: Tory M Blue mailto:tmb...@gmail.com>> writes: > 12 will not start at 10GB, even though it's the same hardware, same config > file, same physical box, same ever

Re: Is there a significant difference in Memory settings between 9.5 and 12

On Mon, May 11, 2020 at 1:36 PM Tom Lane wrote: > Tory M Blue writes: > > 12 will not start at 10GB, even though it's the same hardware, same > config > > file, same physical box, same everything, just version 12 vs 9.5 > > For me, using all-default settings (in particular, shared_buffers = > 12

Re: Is there a significant difference in Memory settings between 9.5 and 12

On Mon, May 11, 2020 at 1:36 PM Tom Lane wrote: > Tory M Blue writes: > > 12 will not start at 10GB, even though it's the same hardware, same > config > > file, same physical box, same everything, just version 12 vs 9.5 > > For me, using all-default settings (in particular, shared_buffers = > 12

Re: Is there a significant difference in Memory settings between 9.5 and 12

Tory M Blue writes: > 12 will not start at 10GB, even though it's the same hardware, same config > file, same physical box, same everything, just version 12 vs 9.5 For me, using all-default settings (in particular, shared_buffers = 128MB), the shared memory block is about 141.6MB using 9.5 and 14