Postgres Pro
Downloads
Home   >   mailing lists

Re: Searching in varchar column having 100M records - Mailing list pgsql-performance

From Sergei Kornilov
Subject Re: Searching in varchar column having 100M records
Date
Msg-id 27574631563364400@iva5-fb4da115b4b5.qloud-c.yandex.net
Whole thread Raw
In response to Searching in varchar column having 100M records  (mayank rupareliya <mayankjr03@gmail.com>)
Responses Re: Searching in varchar column having 100M records
List pgsql-performance
Tree view 
Hello

Please recheck with track_io_timing = on in configuration. explain (analyze,buffers) with this option will report how
manytime we spend during i/o
 

>   Buffers: shared hit=2 read=31492

31492 blocks / 65 sec ~ 480 IOPS, not bad if you are using HDD

Your query reads table data from disks (well, or from OS cache). You need more RAM for shared_buffers or disks with
betterperformance.
 

regards, Sergei

pgsql-performance by date:

Previous
From: mayank rupareliya
Date:
Subject: Searching in varchar column having 100M records
Next
From: Tomas Vondra
Date:
Subject: Re: Searching in varchar column having 100M records