bigato

26 ms·

241.
by bigato 10y ago
What if you made an index on (date, tenant) instead?
242.
by bigato 10y ago
If you had built composite index instead, wouldn't it work just the same towards improving the performance? Well I can see that an composite index would occupy more space while partitioning wouldn't, and that should be something t
243.
by bigato 10y ago
I didn't know what latch is, so I googled it and found a nice explanation: https://oracle2amar.wordpress.com/2010/07/09/what-are-latche... "A latch is a type of a lock that can be very quickly acqu
244.
by bigato 10y ago
Supposing the case in which all partitions are on the same disk and that you manage to index your data well enough according to your usage that postgres does not need to do full table scans, are there any additional performance benefits on
245.
by bigato 10y ago
The most impressive change is: "Garbage collection pauses should be significantly shorter than they were in Go 1.7, usually under 100 microseconds and often as low as 10 microseconds. [...] More work remains for Go 1.9.".
246.
by bigato 10y ago
Any advances in energy production or energy storage make me very excited because I consider those are the most important challenges for human race survival, because we are destroying the climate using fossil fuels. Advances in energy storag
247.
by bigato 10y ago
Any ideas if it would be expensive to produce batteries using this technology?
248.
by bigato 10y ago
I look forward to the day I'll be allowed to use ttk (tcl/tk) compiled to WASM instead of html/css to build interfaces.
249.
by bigato 10y ago
webassembly is not javascript
250.
by bigato 10y ago
Popularity is not exactly what attracts most hackers nowadays; it's profit. Yes, in the common case, the more popular the system, the more profit can be made by hacking it. But if a system is running on a few, but very strategic places
251.
by bigato 10y ago
I am saying only what I said, if you doubt you can read it again above. The numbers you are referring to[1] do not mention lives saved but rather head injuries by transportation modes. They say nothing about seriousness of the injury. And I
252.
by bigato 10y ago
This other article has a bit more information about this helmet: http://www.bbc.com/news/technology-38004215
253.
by bigato 10y ago
It looks light, practical and cool if you ask me.
254.
by bigato 10y ago
Wearing a helmet decreases the possible damages to your head on a hit, and nothing else changes that fact.
255.
by bigato 10y ago
The fact they were forced to pay for the study does not imply they had any saying on how it was conducted.
256.
by bigato 10y ago
If you are not a programmer, I don't know who else is.
257.
by bigato 10y ago
It's pretty clear if you read webassembly design docs.
258.
by bigato 10y ago
Exactly! In some cases like in recursive queries, CTEs may be the only way to achieve some result. In almost all other cases, people use them just because they apparently can't reason about joins, or don't like to do so. I frequen
259.
by bigato 10y ago
> Sometimes I understand the problem perfectly well, but a single beautiful query is not performant enough. > It wouldn't improve performance, but it might improve readability without denigrating performance. These two statements
260.
by bigato 10y ago
Care to elaborate on what situation would a CTE improve performance? Because the OP itself mentioned CTEs degrading performance.
261.
by bigato 10y ago
> CTEs >First, yes they can be an optimisation boundary. But they can also make your query much more read-able and prevent you from doing the wrong thing because you couldn’t reason about a query. In my experience, CTEs may be simpler
262.
by bigato 10y ago
> It makes commenting out columns painless. No it does not. If you have to comment out the first column you'll have to remove the comma from the second column. It's the same problem that happens if you put the commas at the end
263.
by bigato 10y ago
A computer will learn how to speak from reddit, hahahaha. What could possibly go wrong?
264.
by bigato 10y ago
You could, like in the first paragraph of the link.
265.
by bigato 10y ago
You will pry pgadmin3 from my cold dead hands.
266.
by bigato 10y ago
The one request I make is, please do not give in to complexity in order to accommodate to all users' requests.
267.
by bigato 10y ago
> But Tcl/Tk is the most easiest GUI toolkit ever, too bad the resulting UI does not look professional. ttk does
268.
by bigato 10y ago
They removed Linux emulation support in 6.0.
269.
by bigato 10y ago
dwm works just fine
270.
by bigato 10y ago
That means that for each five months working, you build up reserves enough to last you one month without working. It's not a lot, but it's something. Now make some effort to push it to a 33% savings rate, and for each three months

More ›