Postgres Pro
Downloads
Home   >   mailing lists

Re: Why could different data in a table be processed with different performance? - Mailing list pgsql-performance

From Vladimir Ryabtsev
Subject Re: Why could different data in a table be processed with different performance?
Date
Msg-id CAMqTPqks=FTmxVCoQQfPa=7DxTe1V3eLnJZrXq0B+AgdrPzYWQ@mail.gmail.com
Whole thread Raw
In response to Re: Why could different data in a table be processed with differentperformance?  (Justin Pryzby <pryzby@telsasoft.com>)
List pgsql-performance
Tree view
> 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

pgsql-performance by date:

Previous
From: Justin Pryzby
Date:
Subject: Re: Why could different data in a table be processed with differentperformance?
Next
From: Justin Pryzby
Date:
Subject: Re: Why could different data in a table be processed with differentperformance?