The query completes fine in psql, but files from Pg::doQuery.
> -----Original Message-----
> From: Matthew [mailto:matt@ctlno.com]
> Sent: Monday, March 15, 1999 12:57 PM
> To: 'James Puckett'; pgsql-general@postgreSQL.org
> Subject: RE: [GENERAL] postgres and PERL
>
>
> 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
> >
>