Re: [HACKERS] Different execution time for same plan

2011-06-06 Thread Kevin Grittner
First off, this is posted to the wrong list -- this list is for discussion of development of the PostgreSQL product. There is a list for performance questions where this belongs: pgsql-performa...@postgresql.org. I'm moving this to the performance list with a blind copy to the -hackers list so pe

[HACKERS] Different execution time for same plan

2011-06-06 Thread Nick Raj
Hi, I am using postgresql 8.4.6. I have made an index on my data-type that is working fine. I mean output is coming properly. When i execute the query first time, query takes a quite longer time but second time execution of the same query takes very less time (despite execution plan is same) Thi