Re: insert and query performance on big string table with pg_trgm

From: Sergei Kornilov <sk(at)zsrv(dot)org>
To: Matthew Hall <mhall(at)mhcomputing(dot)net>, Jeff Janes <jeff(dot)janes(at)gmail(dot)com>, "surrano(at)gmail(dot)com" <surrano(at)gmail(dot)com>
Cc: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: insert and query performance on big string table with pg_trgm
Date: 2017-12-06 07:23:10
Message-ID: 313361512544990@web43j.yandex.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

> 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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Laurenz Albe 2017-12-06 08:20:38 Re: Different plan chosen when in lateral subquery
Previous Message Vitaliy Garnashevich 2017-12-06 07:06:52 Re: Bitmap scan is undercosted?