From: Sergei Kornilov <sk@zsrv.org>
To: Matthew Hall <mhall@mhcomputing.net>
To: Jeff Janes <jeff.janes@gmail.com>
To: surrano@gmail.com <surrano@gmail.com>
Cc: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: Re: insert and query performance on big string table with pg_trgm
Date: Wed, 06 Dec 2017 10:23:10 +0300
Message-ID: <313361512544990@web43j.yandex.ru> (raw)
In-Reply-To: <351E3FBB-7DFC-4BB0-841E-E7AB16DD57A3@mhcomputing.net>
References: <F5E9C927-1F84-488B-BD02-01DAFDD369D9@mhcomputing.net>
<CAMkU=1yPVyiyyXOxDyDCA18zqaorkoZrfns-2CZXvGi5uZw8xQ@mail.gmail.com>
<56B84857-06EA-4534-A13F-F7AA3B924446@mhcomputing.net>
<351E3FBB-7DFC-4BB0-841E-E7AB16DD57A3@mhcomputing.net>
> Buffers: shared hit=544 read=6760 dirtied=4034
> I/O Timings: read=69709.611
You has very slow (or busy) disks, not postgresql issue. Reading 6760 * 8KB in 70 seconds is very bad result.
For better performance you need better disks, at least raid10 (not raid5). Much more memory in shared_buffers can help with read performance and so reduce disk utilization, but write operations still will be slow.
Sergei
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: sk@zsrv.org, mhall@mhcomputing.net, jeff.janes@gmail.com, surrano@gmail.com, pgsql-performance@lists.postgresql.org
Subject: Re: insert and query performance on big string table with pg_trgm
In-Reply-To: <313361512544990@web43j.yandex.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox