Re: I feel the need for speed. What am I doing wrong?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: I feel the need for speed. What am I doing wrong?
Дата
Msg-id 8548.1041902500@sss.pgh.pa.us
обсуждение исходный текст
Ответ на I feel the need for speed. What am I doing wrong?  ("Dann Corbit" <DCorbit@connx.com>)
Список pgsql-hackers
"Dann Corbit" <DCorbit@connx.com> writes:
> Creating the following index had no effect on performance!
> create unique index i1 on "CNX_DS2_53_SIS_STU_OPT_FEE_TB" ("RT_REC_KEY",
> "cnxarraycolumn", "CRC");

What does EXPLAIN ANALYZE have to say about the query?  If you set
enable_seqscan = 0, does the explain result change?
        regards, tom lane


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

Предыдущее
От: "Dann Corbit"
Дата:
Сообщение: Re: I feel the need for speed. What am I doing wrong?
Следующее
От: "Christopher Kings-Lynne"
Дата:
Сообщение: Re: ipv6 build error?