| From: | Bruno Wolff III <bruno(at)wolff(dot)to> |
|---|---|
| To: | Ravi T Ramachandra <ravi(dot)ramachandra(at)wipro(dot)com> |
| Cc: | pgsql-admin(at)postgresql(dot)org, Sandeep Bhasin <sandeep(dot)bhasin(at)wipro(dot)com> |
| Subject: | Re: Performance Issues |
| Date: | 2003-09-08 13:13:19 |
| Message-ID: | 20030908131319.GB14906@wolff.to |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
On Mon, Sep 08, 2003 at 11:43:42 +0530,
Ravi T Ramachandra <ravi(dot)ramachandra(at)wipro(dot)com> wrote:
>
> SELECT * FROM TABLE A WHERE COL1 = 1 AND COL2 = 'ABC'.
>
> We have created index definition as follows
>
> CREATE INDEX IDX ON A(COL1, COL2);
>
> Explain on the above statement shows it is sequential scan. The
> process size for the postmaster shows as 4MB (is this normal ?)
While Nathan's advice may be useful for you, it probably isn't causing the
problem you are seeing. Your problem is most likely that COL isn't
an INTEGER (aka INT or INT4). Try using single quotes around '1'.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruno Wolff III | 2003-09-08 13:15:50 | Re: Are 50 million rows a problem for postgres ? |
| Previous Message | Bruno Wolff III | 2003-09-08 13:09:52 | Re: Problem about Backup |