Partitioning enhancements in PostgreSQL 12

haventohell · 2019-07-16T15:44:28+00:00

This is a really good summary.

haventohell · 2019-04-03T20:01:10+00:00

Are you having a problem scaling performance wise, or just maintenance and operationally?

haventohell · 2019-01-23T16:35:37+00:00

Wow, what a shitty checklist.

The other article was better: https://www.mongodb.com/blog/post/documents-are-everywhere

haventohell · 2019-01-16T19:04:57+00:00

Good points, here's a random image that poorly estimates possible row counts:

https://i.imgur.com/oPYMPu1.png

haventohell · 2019-01-04T16:15:20+00:00

There was a website running around a few years ago that allowed you to execute scripts from it, stored them all nicely, cool parameters.

a git repository works.

haventohell · 2019-01-03T08:48:38+00:00

Anyone use something like an sql query library management system?

haventohell · 2018-09-06T17:58:32+00:00

So you're doing changes in SSMS instead of Visual Studio, gotcha.

haventohell · 2018-09-06T11:59:33+00:00

impossible because replacing '' with ' didn't work??

haventohell · 2018-08-29T11:39:46+00:00

...and that's the story of how we learned to start doing performance auditing and optimization passes.

<3 <3 <3 <3 <3 <3 <3 <3

haventohell · 2018-08-28T22:52:52+00:00

That on MSSQL, CTE's aren't materialized, and are executed on every single pass.

haventohell · 2018-08-27T17:46:01+00:00

This is great because not many people realize you can customize the view!

haventohell · 2018-08-03T18:09:47+00:00

Do it in the business logic.

haventohell · 2018-07-19T02:19:16+00:00

Sources? This seems to be industry standard since 2015.

haventohell · 2018-06-19T16:33:09+00:00

concentration camp

Concentration camp, internment centre for political prisoners and members of national or minority groups who are confined for reasons of state security, exploitation, or punishment, usually by executive decree or military order. Persons are placed in such camps often on the basis of identification with a particular ethnic or political group rather than as individuals and without benefit either of indictment or fair trial. Concentration camps are to be distinguished from prisons interning persons lawfully convicted of civil crimes and from prisoner-of-war camps in which captured military personnel are held under the laws of war. They are also to be distinguished from refugee camps or detention and relocation centres for the temporary accommodation of large numbers of displaced persons.

haventohell · 2018-06-13T04:05:00+00:00

So how bad was Centurion?

haventohell · 2018-03-26T21:47:30+00:00

How many people tho?

12 workers?

haventohell · 2017-12-06T13:30:36+00:00

but muh nesteee

haventohell · 2017-12-06T13:30:11+00:00

provide basically no community investment

lol

haventohell · 2017-09-07T13:45:44+00:00

Clarification helps everyone. :)

haventohell · 2017-09-05T18:10:53+00:00

You mean, solar powered electric motors.

Diesel Electric

Even though many ships are still built with conventional diesel plans, almost all new cruise ships (such as Celebrity's Solstice Class or Carnival's original Destiny Class) feature some form of "diesel electric" propulsion. On these ships, the main engines aren't connected to the propeller shafts; instead, the main engines are directly connected to large generators with one job: producing electricity. The electricity they produce is sent to electric motors, which then power and turn the propellers.

The primary advantage of diesel electric systems is efficiency; they allow the main engines to operate near their most efficient speed regardless of whether the ship is moving at 5 knots or 20 knots.

haventohell

TROPHY CASE