| From: | Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl> |
|---|---|
| To: | Joseph Shraibman <jks(at)selectacast(dot)net> |
| Cc: | Dann Corbit <DCorbit(at)connx(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: psql performance |
| Date: | 2005-04-15 03:45:27 |
| Message-ID: | 20050415034527.GA7142@dcc.uchile.cl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Apr 14, 2005 at 11:05:37PM -0400, Joseph Shraibman wrote:
> It doesn't matter what the query is. The problem happens before it even
> runs the query.
This is most certainly a problem with the shell or the terminal. I have
seen this effect somewhere else, but I can't reproduce it with psql in
an xterm.
> Incidentally when I did that I only got back one row. What's up with that?
Try with "union all" instead of plain union.
--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Doing what he did amounts to sticking his fingers under the hood of the
implementation; if he gets his fingers burnt, it's his problem." (Tom Lane)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Michael Fuhr | 2005-04-15 03:46:48 | Re: psql performance |
| Previous Message | Tom Lane | 2005-04-15 03:44:56 | Re: psql performance |