Re: [GENERAL] Copying Blobs between two tables using Insert stmt

her reference to the same file. So a simple INSERT INTO table_a SELECT * FROM table_b; will do the trick in your example. -- Diogo Biazus [EMAIL PROTECTED] http://www.softa.com.br http://www.postgresql.org.br -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to

Re: [GENERAL] Survey: renaming/removing script binaries (createdb, createuser...)

(replace initdb with pg_ctl new functionality) e) What is initdb? My start/stop script does it automatically. d 4) How do you perform VACUUM? - a) vacuumdb - shell command b) VACUUM - SQL command c) autovacuum d) What is vacuum? c -- Diogo Biazus [EMAIL PROTECTED

Re: [GENERAL] Wich hardware suits best for large full-text indexed

, my pgsql is version 7.3.4 (I was obviosly mistaken when I wrote 7.4.3 in a previous email) I used to do clustering in some tables, but is a expensive operation as said... -- Diogo Biazus [EMAIL PROTECTED] http://www.ikono.com.br ---(end of broadcast

Re: [GENERAL] Wich hardware suits best for large full-text indexed

osusuario_codgrupousuario_ix on tiposdocumento_gruposusuario  (cost=0.00..13.85 rows=542 width=8) ->  Hash  (cost=1.40..1.40 rows=40 width=19)    ->  Seq Scan on fontes  (cost=0.00..1.40 rows=40 width=19) -- Diogo Biazus [EMAIL PROTECTED] http://www.ikono.com.br

[GENERAL] Wich hardware suits best for large full-text indexed databases

of a more cost eficient solution? How to get a better performance without having to invest some astronomicaly high amount of money? TIA, -- Diogo Biazus [EMAIL PROTECTED] http://www.ikono.com.br ---(end of broadcast)--- TIP 1: subscribe and unsubscribe