Postgres Pro
Downloads
Home   >   mailing lists

Re: insert and query performance on big string table with pg_trgm - Mailing list pgsql-performance

From Sergei Kornilov
Subject Re: insert and query performance on big string table with pg_trgm
Date
Msg-id 313361512544990@web43j.yandex.ru
Whole thread Raw
In response to Re: insert and query performance on big string table with pg_trgm  (Matthew Hall <mhall@mhcomputing.net>)
Responses Re: insert and query performance on big string table with pg_trgm  (Matthew Hall <mhall@mhcomputing.net>)
List pgsql-performance
Tree view 
>    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
withread performance and so reduce disk utilization, but write operations still will be slow.
 

Sergei

pgsql-performance by date:

Previous
From: Vitaliy Garnashevich
Date:
Subject: Re: Bitmap scan is undercosted?
Next
From: Laurenz Albe
Date:
Subject: Re: Different plan chosen when in lateral subquery