From: | Jerome Knobl <jknobl(at)mandanet(dot)ch> |
---|---|
To: | dustin sallings <dustin(at)spy(dot)net> |
Cc: | pgsql-general(at)postgreSQL(dot)org |
Subject: | Re: [GENERAL] Optimization problem? |
Date: | 1998-09-01 07:30:44 |
Message-ID: | 35EBA2A4.B979DF15@mandanet.ch |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)spy(dot)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. ____________
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Fleming | 1998-09-01 15:54:38 | ODBC interface |
Previous Message | dustin sallings | 1998-09-01 07:18:45 | Re: [GENERAL] Optimization problem? |