| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com>, <carlos(dot)reimer(at)opendb(dot)com(dot)br>, "Pgsql-General\(at)Postgresql(dot)Org" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: RES: 8.2.4 selects make applications wait indefinitely |
| Date: | 2007-10-12 06:44:27 |
| Message-ID: | 87fy0gde7o.fsf@oxford.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:
> BTW, have you looked into the theory that it's triggered by total
> data volume rather than number of columns? That is, try selecting
> all the columns but use LIMIT to reduce the number of rows fetched?
Or conversely select the first or second half of the columns but put two
copies of them in the column list.
Are the client and server on two separate machines? Is it possible you have a
network issue between these two machines (like pmtud problems, for example)?
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
| From | Date | Subject | |
|---|---|---|---|
| Next Message | longlong | 2007-10-12 08:15:36 | Re: silent install |
| Previous Message | Richard Huxton | 2007-10-12 06:25:26 | Re: silent install |