| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Adam Michalunio - ONET(dot)PL" <amichalu(at)poczta(dot)onet(dot)pl> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Is cache disable ??? |
| Date: | 2000-07-05 02:07:08 |
| Message-ID: | 29574.962762828@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Adam Michalunio - ONET.PL" <amichalu(at)poczta(dot)onet(dot)pl> writes:
> 1) We build db with amount of 100MB of data. It is one table with 4 fields:=
> 3 numeric, 1 datetime. We've created indexes on all 4 fields and we trying=
> with statement SELECT * from maindat WHERE knd01=3D1928372 AND org01=3D200=
> AND date=3D... etc.=20
> We got about 5 times slower performance with compare to MS SQL 7.0.=20
Not enough info here. What is the exact declaration of the table and
each index? What is the exact query, and what does EXPLAIN show for it?
Also, if you haven't run a VACUUM ANALYZE on the table, it may help to
do that.
regards, tom lane
| From | Date | Subject | |
|---|---|---|---|
| Next Message | XWorkers | 2000-07-05 02:32:50 | ODBC & Log |
| Previous Message | Tom Lane | 2000-07-05 02:01:58 | createlang and PGLIB (was Re: [GENERAL] sequential test error) |