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 CAMqTPqnrF9_pMY0XYd3h6TxLSf33NtUC4a=8m3tmzu8TW2hvOg@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>)
Responses Re: Why could different data in a table be processed with different performance?  (didier <did447@gmail.com>)
List pgsql-performance
Tree view
> I think reindex will improve the heap access..and maybe the index access too. I don't see why it would be bloated without UPDATE/DELETE, but you could check to see if its size changes significantly after reindex.
I tried REINDEX, and size of PK index changed from 2579 to 1548 MB.
But test don't show any significant improvement from what it was. May be read speed for the "big" range became just slightly faster in average.

Vlad

pgsql-performance by date:

Previous
From: Vladimir Ryabtsev
Date:
Subject: Re: Why could different data in a table be processed with different performance?
Next
From: Andreas Kretschmer
Date:
Subject: Re: Multi-second pauses blocking even trivial activity