[PERFORM] psql -A (unaligned format) eats too much memory

Hi, I just noticed that psql's unformatted output uses too much memory. Is it normal? It seems that psql draws all records of a query off the server before it displays or writes the output. I would expect this only with formatted output. Problem is, I have an export that produces 500'000+ record

Re: [PERFORM] psql -A (unaligned format) eats too much memory

Hi, answering to myself. :-) Zoltan Boszormenyi írta: Hi, I just noticed that psql's unformatted output uses too much memory. Is it normal? It seems that psql draws all records of a query off the server before it displays or writes the output. I would expect this only with formatted output. P

Re: [PERFORM] Bulk loading/merging

On 06/02/2006, Michael Artz wrote: hmm, I don't quite understand what you are saying and I think my basic misunderstanding is how to use the UPDATE ... WHERE EXISTS to merge data in bulk.  Assuming that I bulk COPYed the data into a temporary table, I'd need to issue an UPDATE for each ro

Re: [PERFORM] INSERT OR UPDATE WITHOUT SELECT

am 30.05.2006, um 17:47:47 -0300 mailte [EMAIL PROTECTED] folgendes: > Hi, > > Is there a command to Insert a record If It does not exists and a update if > It exists? Not a single command, but a solution: http://developer.postgresql.org/docs/postgres/plpgsql-control-structures.html#PLPGSQL-E