Home > mailing lists

Slow select query - Mailing list psycopg

From	Glenn Pierce
Subject	Slow select query
Date	March 31, 2014 23:16:27
Msg-id	CAM5ipV-JyKRmg8-V5ZBELFLL-LttrwVehZ1EKYv3B05Y+4u9Dg@mail.gmail.com Whole thread Raw
Responses	Re: Slow select query (Federico Di Gregorio <fog@dndg.it>)
List	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

psycopg by date:

From: Federico Di Gregorio
Date: 21 March 2014, 15:32:04
Subject: Re: Server-side prepare and execute

From: Glenn Pierce
Date: 01 April 2014, 01:10:51
Subject: Slow select query