Hi,
   a simple SQL "select ... from tablex where id1=34215670 and
id2=59403938282;
id1 and i2 are bigint and primary key.
      Index Cond: ((tablex.id2 = ' 5940393828299'::bigint) AND (tablex.id1
= ' 34215670  '::bigint))
   Buffers: shared hit=2
 Query Identifier: -1350604566224020319
 Planning:
   Buffers: shared hit=110246         <<< here planning need access a lot
of buffers
 Planning Time: 81.850 ms
 Execution Time: 0.034 ms

   could you help why planning need a lot of shared buffers access ?  this
table has 4 indexes.  and I tested similar SQL with another table has 4
compound indexes and that table only show very small shared buffers hit
when planning.
   this table has a lot of  "update" and "delete" .

Thanks,

James

Reply via email to