Re: [PERFORM] pkey is not used on productive database

2011-10-04 Thread Scott Marlowe
On Mon, Oct 3, 2011 at 11:48 AM, Soporte @ TEKSOL S.A. wrote: > Hi, > > I need help to understand the issue on a productive database for a select > that takes more time than expected. > 1-  On a development database I ran the query (select) and I can see on > Explain Analyze pgAdmin use all t

Re: [PERFORM] pkey is not used on productive database

2011-10-04 Thread hubert depesz lubaczewski
On Mon, Oct 03, 2011 at 02:48:10PM -0300, Soporte @ TEKSOL S.A. wrote: > Hi, > > > > I need help to understand the issue on a productive database for a select > that takes more time than expected. > > > > 1- On a development database I ran the query (select) and I can see on > Explain

[PERFORM] pkey is not used on productive database

2011-10-04 Thread Soporte @ TEKSOL S.A.
Hi, I need help to understand the issue on a productive database for a select that takes more time than expected. 1- On a development database I ran the query (select) and I can see on Explain Analyze pgAdmin use all the indexes and primary keys defined. Dev db has almost 10% of produ