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

Re: bad performance for Access, ODBC and Postgres

From: Eric HAGENBACH <eric(dot)hagenbach(at)vif(dot)tm(dot)fr>
To: Jean-Max Reymond <jmreymond(at)gmail(dot)com>
Cc: pgsql-odbc(at)postgresql(dot)org
Subject: Re: bad performance for Access, ODBC and Postgres
Date: 2004-07-29 12:57:25
Message-ID: 4108F435.80803@vif.tm.fr (view raw or flat)
Thread:
Lists: pgsql-odbc
Jean-Max Reymond a écrit :

>Hi,
>I have very poor access whith a front end Access 2003, ODBC and Postgres 7.4.3.
>Much time to find a record in a table ff 13000 records with indexs.
>Sniffing the network, I can see a lot of traffic and the CPU of
>postmaster is about 30% (P4, 2.8 GHz). It seems that all the data's
>are backed on the client side and then, analyzed.
>Does it exist an option to improve the performances ?
>thanks,
>
>  
>
Maybe you can use the EXPLAIN command to see what query plan the system 
creates for your query (you can see the where condition,  which index is 
used, ...)

Eric.

In response to

Responses

pgsql-odbc by date

Next:From: Jean-Max ReymondDate: 2004-07-29 13:18:52
Subject: Re: bad performance for Access, ODBC and Postgres
Previous:From: Jean-Max ReymondDate: 2004-07-29 12:34:01
Subject: bad performance for Access, ODBC and Postgres

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