Postgres Pro
Downloads
Home   >   mailing lists

Slow select query - Mailing list psycopg

From Glenn Pierce
Subject Slow select query
Date
Msg-id CAM5ipV8rkrBtg7LXCqQJNMMDg+dH772Xf0qUsQaiUTLigsYOQw@mail.gmail.com
Whole thread Raw
Responses Re: Slow select query  (Adrian Klaver <adrian.klaver@aklaver.com>)
List psycopg
Tree view
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

psycopg by date:

Previous
From: Glenn Pierce
Date:
Subject: Slow select query
Next
From: Adrian Klaver
Date:
Subject: Re: Slow select query