[SQL] operating "inet" type

2005-04-12 Thread Ilya A. Kovalenko
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

[SQL] choosing index to use

2005-05-16 Thread Ilya A. Kovalenko
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] VACUUM FULL vs dump & restore

2005-09-23 Thread Ilya A. Kovalenko
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