Skip site navigation (1) Skip section navigation (2)

Re: Is cache disable ???

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: (view raw, whole thread or download thread mbox)
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

In response to

pgsql-general by date

Next:From: XWorkersDate: 2000-07-05 02:32:50
Subject: ODBC & Log
Previous:From: Tom LaneDate: 2000-07-05 02:01:58
Subject: createlang and PGLIB (was Re: [GENERAL] sequential test error)

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group