I found the answer here:
http://www.postgresql.org/docs/current/interactive/using-explain.html
Thanks!
--
View this message in context:
http://postgresql.nabble.com/Is-my-understanding-of-bitmap-index-scans-and-recheck-cond-correct-tp5831616p5831662.html
Sent from the PostgreSQL - general ma
I think that when the query planner chooses to use an index to satisfy a
range scan, it verifies how the order of index keys is correlated with
physical order of rows in the table. If correlation is low, than the planner
wants to make sure that it reads each page only once.
So, first PG scans the
Thank you Tom, that's exactly what I meant. I believe the term "clustering
factor" is well-known:
http://use-the-index-luke.com/glossary/index-clustering-factor
What is the right word to use instead in Postgres universe?
--
View this message in context:
http://postgresql.nabble.com/Is-cluste
I believe that tables' clustering factors are stored in pg_stats.correlation.
Here is how I came to this conclusion:
create table narrow_table as
with numbers as(
select generate_series as n from generate_series(0,1048575))
select n as seq_number,
(n/1024) + ((n%1024)<<10) as rand_number
from nu
This worked, thank you!
--
View this message in context:
http://postgresql.nabble.com/How-to-connect-to-postgres-app-on-Mac-from-PgAdmin-tp5831604p5831609.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
--
Sent via pgsql-general mailing list (pgsql-general@postgre
I've installed postgres.app on my Mac. It did not prompt me for any password.
I am trying to connect to it via PgAdmin, from the same Mac laptop,
providing localhost as hostname, postgres as username, and no password.
I am getting "FATAL: role postgres does not exist".
Which credentials should
