There is parallel sequence scanning coming in 9.6 --
http://rhaas.blogspot.com/2015/11/parallel-sequential-scan-is-committed.html
And there is the GPU extension - https://wiki.postgresql.org/wiki/PGStrom
If those aren't options, you'll want your table as much in memory as
possible so your scan d
Hi All!
Is Postgres use shared_buffers during seq_scan?
In what way i can optimize seq_scan on big tables?
Thanks!
Artem Tomyuk wrote:
> Is Postgres use shared_buffers during seq_scan?
> In what way i can optimize seq_scan on big tables?
If the estimated table size is less than a quarter of shared_buffers,
the whole table will be read to the shared buffers during a sequential scan.
If the table is larger tha