Re: [GENERAL] index duplicates primary key, but is used more?

Hello, I suggest you log all execution plan in your db log through using auto_explain extension. And then analyze the stats about your concerned indexes . No hint syntax in Postgresql. Which indexes and join method would be adopt all depend on optimizer whose behaviour is

Re: [GENERAL] index duplicates primary key, but is used more?

jonathan vanasco writes: > What I noticed when checking stats earlier, is that although > `idx_test_foo_id_asc` is the same as the PKEY... it was used about 10x more > than the pkey. > Does anyone know of this is just random (perhaps due to the name being sorted > earlier)

[GENERAL] index duplicates primary key, but is used more?

i'm doing a performance audit and noticed something odd. we tested a table a while back, by creating lots of indexes that match different queries (30+). for simplicity, here's a two column table: CREATE TABLE foo (id INT PRIMARY KEY value