| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Dann Corbit" <DCorbit(at)connx(dot)com> |
| Cc: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: I feel the need for speed. What am I doing wrong? |
| Date: | 2003-01-07 01:21:40 |
| Message-ID: | 8548.1041902500@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
"Dann Corbit" <DCorbit(at)connx(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2003-01-07 01:25:52 | Re: [HACKERS] I feel the need for speed. What am I doing wrong? |
| Previous Message | Nigel J. Andrews | 2003-01-07 00:57:45 | Re: [HACKERS] I feel the need for speed. What am I doing wrong? |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Christopher Kings-Lynne | 2003-01-07 01:23:42 | Re: ipv6 build error? |
| Previous Message | Dann Corbit | 2003-01-07 01:10:41 | Re: I feel the need for speed. What am I doing wrong? |