[SQL] VACUUM FULL vs dump & restore

Greetings, What advantages I lose, when using dump-truncate-restore (table or whole DB) instead of performing VACUUM FULL ? In both cases I have no access to data, but first is much faster (by subjective estimate). Thank you, Ilya A. Kovalenko (mailto:[EMAIL PROTECTED

[SQL] choosing index to use

y switches to another index. How to make such without index removing ? PostgreSQL 8.0.2, OpenBSD 3.7, i386 Thank you. Ilya A. Kovalenko Special EQ SW section JSC Oganer-Service Details: CREATE TABLE traffic_stat ( time timestamptz NOT NULL, clientinet NOT NULL, remoteine

[SQL] operating "inet" type

ot;inet" type w/o any ways to work w/ it. Parsing "inet" converted text can't be, seriously, taken as alternative, but using numeric types to store addresses (and ignore native "inet" type) really, can. I'm using PostgreSQL 7.4.3, Can 8.0.1 do more ? Thank you