Re: psql performance

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[@]dcc.uchile.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)