Postgres Pro
Downloads
Home   >   mailing lists

Re: I feel the need for speed. What am I doing wrong? - Mailing list pgsql-hackers

From Tom Lane
Subject Re: I feel the need for speed. What am I doing wrong?
Date
Msg-id 8548.1041902500@sss.pgh.pa.us
Whole thread Raw
In response to I feel the need for speed. What am I doing wrong?  ("Dann Corbit" <DCorbit@connx.com>)
List pgsql-hackers
Tree view 
"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 by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: I feel the need for speed. What am I doing wrong?
Next
From: "Christopher Kings-Lynne"
Date:
Subject: Re: ipv6 build error?