| From: | Matthew <matt(at)ctlno(dot)com> |
|---|---|
| To: | "'James Puckett'" <jpuckett(at)surfsouth(dot)com>, pgsql-general(at)postgreSQL(dot)org |
| Subject: | RE: [GENERAL] postgres and PERL |
| Date: | 1999-03-15 17:56:38 |
| Message-ID: | A043233669F9D111B99700A0C92376CA0DD6AB@srv.ctlno.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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(at)surfsouth(dot)com]
> Sent: Sunday, March 14, 1999 8:11 PM
> To: pgsql-general(at)postgreSQL(dot)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
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | James Puckett | 1999-03-15 18:31:58 | RE: [GENERAL] postgres and PERL |
| Previous Message | Bruce Momjian | 1999-03-15 16:50:34 | Re: [GENERAL] Bug with sequences in 6.4.2 |