The question: To prevent memory grant (excessive) problems I want to change my DB compatibility level to 150 How can I be sure I won’t have a problem ? Is there any script/tool to check my DB for 150? The Solutions: Below are the methods you can try. The first solution is probably the best. … Read more
In SSD, overwriting a data file means SSD has to first erase it and then write data. This can change the data layout in the SSD for the data file.
I understand the downsides of using the parameter setting
Hi I have to update monthly my database using this big dump (100gb)
I don’t have the control over how it’s done I only receive a .zip with a lot of .gz
i want to speed up the restoring since I only really need 1 table.
I have a nvme for my disk, but it’s only getting written at like 200 mb/s but it’s capable of a lot more.
I think this is because it’s CPU bound the decompression of the .gz and I can’t find a way to paralyze the decompression.
the postgres version is 10.20
how can i check where is the table stored, in what file i mean.
The Cost Threshold for Parallelism Setting on one of our servers is set at what is generally considered too low (15) and we are considering increasing to 50 in hope to reduce CPU as it is becoming high.
I have a database about books and book sales.
The tables look like this:
We’re building an Angular app, and we’re trying to figure out how to get some benchmarks on how long it takes to render various pages. I’ve read about performance.timing here, but that seems to only be useful with non-single page applications as when I navigate to new views in our app, the timing numbers do not change.
I would like to know the best way to design an angular app regarding performance, for building an HTML template with reusable widgets like header, sidebar, footer, etc. Basically the main content is the central DIV which will have its content varying between routes, header and footer will be almost always the same, sidebar can vary in certain pages.
From this question and this answer, it seems that using expressions will cause the value to be evaluated from scratch every time. But I’ve searched the documentation and tutorials, and I haven’t found a reference for this statement.
I’m familiar with angular’s digest cycle and how it affects performance with long lists and large model values. I’m just curious if you have any workaround for the problem specifically for my case.
I’m building an app which may or may not require user to enter large text such as error log in the textarea, but due to angular inherent issue associated with 2-way data binding on large model its causing my app to hang.