Re: performance question

Поиск
Список
Период
Сортировка
От Tomasz Myrta
Тема Re: performance question
Дата
Msg-id 3E2C64AB.2070101@klaster.net
обсуждение исходный текст
Ответ на performance question  ("Moritz Lennert" <mlennert@club.worldonline.be>)
Список pgsql-sql
Moritz Lennert wrote:

>Hello,
>
>I have a table with some 2.2 million rows on a Pentium4, 1.8GHz with 512
>MB RAM.
>Some queries I launch take quite a long time, and I'm wondering whether
>this is normal,or whether I can get better performance somehow.
>
>As an example, I have a field which is in char(2), with 23 different
>possible values. 

This field is not too selective. Are there any more fields which are always in where condition? 
If yes, indexing on more than one field should help.

Tomasz Myrta



В списке pgsql-sql по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: performance question
Следующее
От: "Josh Berkus"
Дата:
Сообщение: Re: performance question