| From: | Korisk <Korisk(at)yandex(dot)ru> |
|---|---|
| To: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
| Cc: | Sergey Konoplev <gray(dot)ru(at)gmail(dot)com>, "pgsql-performance(at)postgresql(dot)org" <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: hash aggregation |
| Date: | 2012-10-11 15:15:13 |
| Message-ID: | 53981349968513@web6f.yandex.ru |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"IOS scan" ?
Index Only Scan
What's your seq_page_cost and random_page_cost?
hashes=# SELECT name, setting, reset_val FROM pg_settings WHERE setting <> reset_val;
name | setting | reset_val
-------------------------+----------------+-----------
archive_command | (disabled) |
enable_bitmapscan | off | on
enable_indexscan | off | on
enable_seqscan | off | on
log_file_mode | 0600 | 384
random_page_cost | 0.1 | 4
seq_page_cost | 0.1 | 1
transaction_isolation | read committed | default
unix_socket_permissions | 0777 | 511
(9 rows)
Postgresql 9.2.1 was configured and built with default settings.
Thank you.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sergey Konoplev | 2012-10-11 17:55:09 | Re: hash aggregation |
| Previous Message | Andrea Suisani | 2012-10-11 14:40:14 | Re: Two identical systems, radically different performance |