It could be that the database is failing to complete the query, we had a
similar problem with ODBC. Run the query in psql and see what it does.
It was telling us that we were out of memory and had to specify the -B
option to specify more memory.
> -----Original Message-----
> From: James Puckett [SMTP:jpuckett@surfsouth.com]
> Sent: Sunday, March 14, 1999 8:11 PM
> To: pgsql-general@postgreSQL.org
> Subject: [GENERAL] postgres and PERL
>
>
>
> I have written a program which queries a fairly large table with
> "GROUP BY"
> & "ORDER BY".
>
> The queries are taking a while to complete. It seems like the
> connection to
> the database
> is timing out before the results are returned. Any suggestions?
>
> -James
>