| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | George Papastamatopoulos <George(dot)Papastamatopoulos(at)lawlex(dot)com(dot)au> |
| Cc: | pgsql-performance(at)postgresql(dot)org, Paul Smith <Paul(dot)Smith(at)lawlex(dot)com(dot)au> |
| Subject: | Re: FW: Query Plan problem |
| Date: | 2003-06-02 05:31:27 |
| Message-ID: | 2115.1054531887@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
George Papastamatopoulos <George(dot)Papastamatopoulos(at)lawlex(dot)com(dot)au> writes:
>> ... WHERE tblUser.id IN
>> ('102','103','104','105','106','107','108','109','110','111','112','113','
>> 114','115','116','117','118','119','120','121','122','123','124','125','12
> ...
What's the datatype of tblUser.id? What indexes do you have on the
table?
Also, are both databases built with the same locale/encoding support
and initdb-time choices? What are they?
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Mindaugas Riauba | 2003-06-02 05:33:38 | Degrading performance |
| Previous Message | George Papastamatopoulos | 2003-06-02 04:56:18 | FW: Query Plan problem |