Re: Consecutive Query Executions with Increasing Execution Time

2019-12-16 Thread Sam Gendler
On Mon, Dec 16, 2019 at 2:48 PM Tom Lane wrote: > unless you suppose it actually > throttled to below base freq, which surely shouldn't happen that fast. > Might be worth watching the CPU frequency while doing the test though. > Wouldn't expect to see such linear progression if that were the cas

Re: Distributing data over "spindles" even on AWS EBS, (followup to the work queue saga)

2019-03-19 Thread Sam Gendler
You do have a finite amount of bandwidth per-instance. On c5.xlarge, it is 3500 Mbit/sec, no matter how many iops you buy. Keep an eye on yur overall EBS bandwidth utilization. On Sun, Mar 17, 2019 at 11:42 AM Gunther wrote: > On 3/14/2019 11:11, Jeremy Schneider wrote: > > On 3/14/19 07:53, Gu

Re: Learning EXPLAIN

2017-12-08 Thread Sam Gendler
y the original blog posts. On Fri, Dec 8, 2017 at 8:47 PM, Sam Gendler wrote: > 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.d

Re: Learning EXPLAIN

2017-12-08 Thread Sam Gendler
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