Re: Why could different data in a table be processed with different performance?
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Why could different data in a table be processed with different performance?
From
: Vladimir Ryabtsev <greatvovan@xxxxxxxxx>
Date
: Mon, 24 Sep 2018 19:31:06 -0700
Cc
: pgsql-performance@xxxxxxxxxxxxxxxxxxxx
In-reply-to
: <
20180925021954.GW2471@telsasoft.com
>
References
: <CAMqTPq=aFwfiqv=P9EDs+UxeOgfe03kyQ0uvtUHvSxvfSvYR+w@mail.gmail.com> <
4dbb8bea-bea3-74d8-a537-36bb9864cb9f@portavita.eu
> <
CAMqTPqkMDEkvx7jUquUCCkwgwYdcS-byzimjap2osxYWqp1KjA@mail.gmail.com
> <
e8d93055-9643-0ad2-d8bd-3f4fc344bf51@portavita.eu
> <
CAMqTPqnUB54YXQutPKPWdoUKEZOnV58WndfTvZagrNLiTr6RHw@mail.gmail.com
> <
20180924233423.GV2471@telsasoft.com
> <CAMqTPq=f2fQ8tnUu3UxrvfogiDCn+04HWFX8fpZkDoeYQ7ktTQ@mail.gmail.com> <
20180925021954.GW2471@telsasoft.com
>
> If it does an index scan, I think that will badly fail to keep the same order of heap TIDs - it'll be inserting rows in ID order rather than in (I guess) reverse ID order.
According to the plan, it's gonna be seq. scan with filter.
Vlad
References
:
Why could different data in a table be processed with different performance?
From:
Vladimir Ryabtsev
Re: Why could different data in a table be processed with different performance?
From:
Fabio Pardi
Re: Why could different data in a table be processed with different performance?
From:
Vladimir Ryabtsev
Re: Why could different data in a table be processed with different performance?
From:
Fabio Pardi
Re: Why could different data in a table be processed with different performance?
From:
Vladimir Ryabtsev
Re: Why could different data in a table be processed with different performance?
From:
Justin Pryzby
Re: Why could different data in a table be processed with different performance?
From:
Vladimir Ryabtsev
Re: Why could different data in a table be processed with different performance?
From:
Justin Pryzby
Prev by Date:
Re: Why could different data in a table be processed with different performance?
Next by Date:
Re: Why could different data in a table be processed with different performance?
Previous by thread:
Re: Why could different data in a table be processed with different performance?
Next by thread:
Re: Why could different data in a table be processed with different performance?
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
