Suya Huang <shu...@connexity.com> writes:
> Thank you Tom very much, thatâs the piece of information I miss.
> So, should I expect that the nested loop join would be much faster if I cache
> both tables (use pg_prewarm) into memory as it waives the disk read?
pg_prewarm is not going to magically fix things if your table is bigger
than RAM, which it apparently is.
regards, tom lane
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
