Ah, I see now that the article you linked to in the OP is written by the
same author and is maybe the very same content. If so, that sure seems
pretty comprehensive to me, though I've also been reading this list, off
and on, for many years, which has probably filled a lot of the gaps left by
the or
What about the many-part explanation posted on the blog that accompanies
explain.depesz.com. Here is the first installment. I seem to remember that
there are 5 or 6 installments.
https://www.depesz.com/2013/04/16/explaining-the-unexplainable/
On Fri, Dec 8, 2017 at 8:44 AM, Gustavo Velasquez
wr
Hi,
On 2017-12-08 10:17:34 -0800, Andres Freund wrote:
> the strtoll is libc functionality triggered by pg_atoi(), something I've
> seen show up in numerous profiles. I think it's probably time to have
> our own optimized version of it rather than relying on libcs.
Attached is a hand-rolled vers
Hi,
On 2017-12-07 20:21:45 -0800, Alex Tokarev wrote:
> I have a set of tables with fairly large number of columns, mostly int with
> a few bigints and short char/varchar columns. I¹ve noticed that Postgres is
> pretty slow at inserting data in such a table. I tried to tune every
> possible settin
Dude,
You can rest assured that at least the Brazilians members will always know
based on your last name you are not the same :-).
What's the point of explaining that anyways? Got curious.
As to what pertains to the topic:
This is another simple yet effective doc:
https://wiki.postgresql.org/i
Em sex, 8 de dez de 2017 às 14:20, Guillaume Lelarge
escreveu:
> Hi,
>
> 2017-12-08 2:12 GMT+01:00 Flávio Henrique :
>
>> Hi experts!
>>
>> I read this nice article about Understanding EXPLAIN [1] weeks ago that
>> opened my mind about the tool, but it seems no enough to explain a lot of
>> plans
Hi,
2017-12-08 2:12 GMT+01:00 Flávio Henrique :
> Hi experts!
>
> I read this nice article about Understanding EXPLAIN [1] weeks ago that
> opened my mind about the tool, but it seems no enough to explain a lot of
> plans that I see in this list.
>
Thanks.
I often read responses to a plan that
