Re: Why could different data in a table be processed with different performance?

From: Vladimir Ryabtsev <greatvovan(at)gmail(dot)com>
To: pryzby(at)telsasoft(dot)com
Cc: f(dot)pardi(at)portavita(dot)eu, pgsql-performance(at)lists(dot)postgresql(dot)org
Subject: Re: Why could different data in a table be processed with different performance?
Date: 2018-09-28 09:16:46
Message-ID: CAMqTPqmRwpy2_hgD=Fic7VVgjEcp4D2O0RCyBPitoUMEqpcApQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Vladimir Ryabtsev 2018-09-28 09:56:24 Re: Why could different data in a table be processed with different performance?
Previous Message Sam R. 2018-09-28 04:45:25 Re: To keep indexes in memory, is large enough effective_cache_size enough?