RES: select on 1milion register = 6s
От | Bruno Rodrigues Siqueira |
---|---|
Тема | RES: select on 1milion register = 6s |
Дата | |
Msg-id | 002f01c7d16c$0bf4e360$e900a8c0@brunolaptop обсуждение исходный текст |
Ответ на | Re: select on 1milion register = 6s (Hervé Piedvache <bill.footcow@gmail.com>) |
Список | pgsql-performance |
Yes, i do. -----Mensagem original----- De: pgsql-performance-owner@postgresql.org [mailto:pgsql-performance-owner@postgresql.org] Em nome de Hervé Piedvache Enviada em: sábado, 28 de julho de 2007 16:57 Para: pgsql-performance@postgresql.org Cc: Bruno Rodrigues Siqueira Assunto: Re: [PERFORM] select on 1milion register = 6s Do you have analyzed your table before doing this ? Le samedi 28 juillet 2007, Bruno Rodrigues Siqueira a écrit : > Friends, > > > > > > > > Who can help me? My SELECT in a base with 1 milion register, > using expression index = 6seconds. > > > > > > Please, I don't know how to makes it better. > > > > > > Thanks -- Hervé Piedvache ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match
В списке pgsql-performance по дате отправления: