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 CAMqTPqmRwpy2_hgD=Fic7VVgjEcp4D2O0RCyBPitoUMEqpcApQ@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
> Does your LVM have readahead
> ramped up ?  Try lvchange -r 65536 data/postgres (or similar).

Changed this from 256 to 65536.
If it is supposed to take effect immediately (no server reboot or other changes), then I've got no changes in performance. No at all.

Vlad

pgsql-performance by date:

Previous
From: "Sam R."
Date:
Subject: Re: To keep indexes in memory, is large enough effective_cache_sizeenough?
Next
From: Vladimir Ryabtsev
Date:
Subject: Re: Why could different data in a table be processed with different performance?