| From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
|---|---|
| To: | Glenn Pierce <glennpierce(at)gmail(dot)com>, psycopg(at)postgresql(dot)org |
| Subject: | Re: Slow select query |
| Date: | 2014-03-31 23:17:27 |
| Message-ID: | 5339F787.5020201@aklaver.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | psycopg |
On 03/31/2014 01:10 PM, Glenn Pierce wrote:
> Hi I have a query that returns a fair amount of data ~ 730000 rows.
> In pgadmin The query after multiple runs takes around 5-6 seconds.
>
> When try to get all the data through psycopg it takes around 20 seconds.
>
> I have turned of ssl for postgres.
>
> Does anyone no any reasons why this is or is this normal behavior ?
Are running this under the same circumstances?
In other words are pgAdmin and your psycopg code on the same machine
pointing at the same server?
Also what is your psycopg code doing besides running the query, if anything?
Lastly how are measuring completion in each case?
>
> Thanks
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Federico Di Gregorio | 2014-04-02 08:37:59 | Re: Slow select query |
| Previous Message | Glenn Pierce | 2014-03-31 20:16:04 | Slow select query |