Re: Database Performance problem

On Mon, 2003-01-20 at 05:11, joepie Platteau wrote:
> A question about the performance of postgresql...
>
> Situation :
> I created a Postgresql Database with 2 tables : T-Persons and T-Address
> In both tables are almost 70000 records.
> I also created the same Database in MsAccess (and put it on the same
> server) with the same tables (and data)
>
> I connect these tables from my MsAccess2000 - frontend and run the
> following query :
>
> SELECT [T-persons].[Id-person], [T-address].Street, [T-address].Number
> FROM [T-persons] INNER JOIN [T-addres] ON [T-persons].[ID-address] =
> [T-address].[ID-address];
>
> When I run this query
>  1. with the tables of Postgresql, it takes approx. 58 seconds.
>  2. with the tables of MsAccess, it takes approx. 6 seconds.
>  3. directly (without connection to Access) on the server, it takes 5
> seconds

Sounds like you're using SQL Server, w/ Access as the front-end.

>
> I already tried optimising the Postgresql with Vacuum and I also created
> an index on the field "ID-address" in T-persons.
> All this doesn't help.  I also have the latest version of ODBC.
>
> Are there any other possibilities to make this run faster?
> I tried to make the query as Pass-through query, but this also doesn't
> help a lot...(52 seconds)

Sooooo,

What version of Pg are you using?
What OS, and it's version?
What are the table definitions?
What does postgresql.conf look like?  (Please eliminate comments.)
http://www.tuxedo.org/~esr/faqs/smart-questions.html

--
+------------------------------------------------------------+
| Ron Johnson, Jr.     mailto:ron.l.johnson@cox.net          |
| Jefferson, LA  USA   http://members.cox.net/ron.l.johnson  |
|                                                            |
| "Basically, I got on the plane with a bomb. Basically, I   |
|  tried to ignite it. Basically, yeah, I intended to damage |
|  the plane."                                               |
|    RICHARD REID, who tried to blow up American Airlines    |
|                  Flight 63                                 |
+------------------------------------------------------------+