Hello all,
A query ran twice in succession performs VERY poorly the first time as it
iterates through the nested loop. The second time, it rips. Please see SQL,
SLOW PLAN and FAST PLAN below.
I don't know why these nested loops are taking so long to execute.
" -> Nested Loop (cost=0.00..42
> That still is consistent with it being caused by the files being
> discontiguous. Copying them moved all the blocks to be contiguous and
> sequential on disk and might have had the same effect even if you had
> left the settings at 8kB blocks. You described it as "overloading the
> array/drives
On Mon, May 10, 2010 at 8:30 PM, Josh Berkus wrote:
> Ivan,
>
>> Other things could have influenced your result - 260 MB/s vs 300 MB/s is
>> close enough to be influenced by data position on (some of) the drives.
>> (I'm not saying anything about the original question.)
>
> You misread my post. I
Ivan,
> Other things could have influenced your result - 260 MB/s vs 300 MB/s is
> close enough to be influenced by data position on (some of) the drives.
> (I'm not saying anything about the original question.)
You misread my post. It's *87mb/s* vs. 300mb/s. I kinda doubt that's
position on th
As I said, the record size is applied on the file creation :-)
so by copying your data from one directory to another one you've made
the new record size applied on the newly created files :-) (equal to
backup restore if there was not enough space)..
Did you try to redo the same but still keeping
On 05/10/10 20:39, Josh Berkus wrote:
On 5/9/10 1:45 AM, Dimitri wrote:
Josh,
it'll be great if you explain how did you change the records size to
128K? - as this size is assigned on the file creation and cannot be
changed later - I suppose that you made a backup of your data and then
process a
On 5/9/10 1:45 AM, Dimitri wrote:
> Josh,
>
> it'll be great if you explain how did you change the records size to
> 128K? - as this size is assigned on the file creation and cannot be
> changed later - I suppose that you made a backup of your data and then
> process a full restore.. is it so?
Yo
