Bad query performance with more conditions?
От | kaifeng.zhu |
---|---|
Тема | Bad query performance with more conditions? |
Дата | |
Msg-id | AANLkTimfZAklVjQ5bQMXjyFEY6EWE3SutaD1Qkww-lar@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: Bad query performance with more conditions?
Re: Bad query performance with more conditions? |
Список | pgsql-general |
Hi All, I have a table named emails which created by following script: create table emails ( email_id bigserial primary key, email_msg_id char(36) not null, email_sender text not null) The table has more than 10 million of records and I have already created indexes on email_msg_id and email_sender Following script finished very quickly (less than 1 seconds): select * from emails where email_msg_id = '4dba381b-f55e-02d3-4b4a-95e2e98178e2' limit 1 But a similar script cost more than ten seconds: select * from emails where email_msg_id = '4dba381b-f55e-02d3-4b4a-95e2e98178e2' and email_sender_text = 'sender@domain.com' limit 1 Both those scripts returns 0 rows of records indeed. Any comment are highly appreciated.
В списке pgsql-general по дате отправления: