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

Поиск
Список
Период
Сортировка
От Sergei Kornilov
Тема Re: insert and query performance on big string table with pg_trgm
Дата
Msg-id 313361512544990@web43j.yandex.ru
обсуждение исходный текст
Ответ на Re: insert and query performance on big string table with pg_trgm  (Matthew Hall <mhall@mhcomputing.net>)
Ответы Re: insert and query performance on big string table with pg_trgm  (Matthew Hall <mhall@mhcomputing.net>)
Список 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
withread performance and so reduce disk utilization, but write operations still will be slow.
 

Sergei


В списке pgsql-performance по дате отправления:

Предыдущее
От: Vitaliy Garnashevich
Дата:
Сообщение: Re: Bitmap scan is undercosted?
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Different plan chosen when in lateral subquery