Slow select query

From: Glenn Pierce <glennpierce(at)gmail(dot)com>
To: psycopg(at)postgresql(dot)org
Subject: Slow select query
Date: 2014-03-31 20:10:27
Message-ID: CAM5ipV8rkrBtg7LXCqQJNMMDg+dH772Xf0qUsQaiUTLigsYOQw@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: psycopg

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 ?

Thanks

Responses

Browse psycopg by date

  From Date Subject
Next Message Glenn Pierce 2014-03-31 20:16:04 Slow select query
Previous Message Federico Di Gregorio 2014-03-21 12:31:57 Re: Server-side prepare and execute