Re: [GENERAL] Optimization problem? - Mailing list pgsql-general

From Jerome Knobl
Subject Re: [GENERAL] Optimization problem?
Date
Msg-id 35EBA2A4.B979DF15@mandanet.ch
Whole thread Raw
In response to Re: [GENERAL] Optimization problem?  (dustin sallings <dustin@spy.net>)
List pgsql-general
I add some index (hash table), that why my queries take about 20 seconds (I
try with index, and I stop the process after 1 hour).

JK

dustin sallings wrote:

> On Tue, 1 Sep 1998, Jerome Knobl wrote:
>
> // I'm working with a table with about 650'000 rows. It's working
> // pretty well, my queries take about 20 seconds.
> //
> // I would like to know to optimize it ?
>
>         Given the information provided, I'd recommend buying a SQL book.
> You also might want to add an index or two (the SQL book would tell you
> all about it).
>
> --
> SA, software.net         My girlfriend asked me which one I like better.
> pub  1024/3CAE01D5 1994/11/03 Dustin Sallings <dustin@spy.net>
> |    Key fingerprint =  87 02 57 08 02 D0 DA D6  C8 0F 3E 65 51 98 D8 BE
> L_______________________ I hope the answer won't upset her. ____________




pgsql-general by date:

Previous
From: dustin sallings
Date:
Subject: Re: [GENERAL] Optimization problem?
Next
From: Mark Fleming
Date:
Subject: ODBC interface