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

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

Upgraded from 9.5 to 12 and 12 would not start with the current configured Shared Buffers. Same hardware, same config file. Which tells me something has changed, are there new default settings in the 12 postgresql.conf file that are not being called out in my 9.5 config file that could be the cau