Slow select query

From: Glenn Pierce <glennpierce(at)gmail(dot)com>
To: psycopg <psycopg(at)postgresql(dot)org>
Subject: Slow select query
Date: 2014-03-31 20:16:04
Message-ID: CAM5ipV-JyKRmg8-V5ZBELFLL-LttrwVehZ1EKYv3B05Y+4u9Dg@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 Adrian Klaver 2014-03-31 23:17:27 Re: Slow select query
Previous Message Glenn Pierce 2014-03-31 20:10:27 Slow select query