[GENERAL] optimizing advice

2009-12-01 Thread Rüdiger Sörensen
dear all, I am building a database that will be really huge and grow rapidly. It holds data from satellite observations. Data is imported via a java application. The import is organized via files, that are parsed by the application; each file hods the data of one orbit of the satellite. One of

[GENERAL] Q: inheritance

2008-12-04 Thread Rüdiger Sörensen
hi, I think I misunderstand the concept of inheritance. I was under the impression that inheriting from an existing table inherits all of the parent's columns. But: create table t1 (id serial primary key); create table t2 (num int) inherits (t1); create table t3 (t1 int references t1(id)); inse