| From: | "James Puckett" <jpuckett(at)optilinkcomm(dot)net> |
|---|---|
| To: | <pgsql-general(at)postgreSQL(dot)org> |
| Subject: | RE: [GENERAL] postgres and PERL |
| Date: | 1999-03-15 18:31:58 |
| Message-ID: | NCBBKHMFIKPBJOAPELFNMEHICAAA.jpuckett@optilinkcomm.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
The query completes fine in psql, but files from Pg::doQuery.
> -----Original Message-----
> From: Matthew [mailto:matt(at)ctlno(dot)com]
> Sent: Monday, March 15, 1999 12:57 PM
> To: 'James Puckett'; pgsql-general(at)postgreSQL(dot)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(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 | Bruce Momjian | 1999-03-15 18:50:25 | Re: [GENERAL] Soundex functions for triggers? |
| Previous Message | Matthew | 1999-03-15 17:56:38 | RE: [GENERAL] postgres and PERL |