Can you post make and model of the SSD concerned? In general the cheaper
consumer grade ones cannot do sustained read/writes at anything like
their quoted max values.
regards
Mark
On 17/07/18 17:00, Neto pr wrote:
Dear,
Some of you can help me understand this.
This query plan is executed i
Can you show the configuration of postgresql.conf?
Query configuration method:
Select name, setting from pg_settings where name ~ 'buffers|cpu|^enable';
On 2018年07月17日 13:17, Benjamin Scherrey wrote:
What's the on disk cache size for each drive? The better HDD
performance problem won't be susta
What's the on disk cache size for each drive? The better HDD performance
problem won't be sustained with large amounts of data and several different
queries.
- - Ben Scherrey
On Tue, Jul 17, 2018, 12:01 PM Neto pr wrote:
> Dear,
> Some of you can help me understand this.
>
> This query plan i
Dear,
Some of you can help me understand this.
This query plan is executed in the query below (query 9 of TPC-H
Benchmark, with scale 40, database with approximately 40 gb).
The experiment consisted of running the query on a HDD (Raid zero).
Then the same query is executed on an SSD (Raid Zero).
Tom and Jeff,
Thanks very much for the suggestions!
Here's what I've found so far after playing around for a few more days:
What is your default_statistics_target? What can you tell us about the
> distribution of parent_id? (exponential, power law, etc?). Can you show
> the results for select
