Which query is less expensive / faster?

Поиск
Список
Период
Сортировка
От Postgres Coder
Тема Which query is less expensive / faster?
Дата
Msg-id c2213f3d05022415466c2e7bdc@mail.gmail.com
обсуждение исходный текст
Ответы Re: Which query is less expensive / faster?
Список pgsql-general
Hi all,

I have a couple different ways to get results out of my table
structure, but I'm unsure which way is faster or less expensive to
run:

Option 1:  Query a table of 4 million rows, on 4 indexed columns.  It
will return 1 row:

SELECT field1, field2, field3, field4
FROM tablea
WHERE field1 = $1 AND field2 = $2 AND field3 = $3 AND field4 = $4

Option 2: Query a table of 200,000 rows on 1 indexed column.  It will
return 800 rows:

SELECT *
FROM tableb
WHERE field1 = $1

Which one is going to return results the fastest, with the least
expense to the database server?

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

Предыдущее
От: Ron Mayer
Дата:
Сообщение: Re: [PATCHES] A way to let Vacuum warn if FSM settings are low.
Следующее
От: "Guy Rouillier"
Дата:
Сообщение: Re: basic trigger using OLD not working?