Re: [GENERAL] Row Size and Indexing

2006-01-15 Thread Martijn van Oosterhout
On Fri, Jan 13, 2006 at 06:48:28AM -0800, tschak wrote: > Hi guys, > > I have some questions about postgres and would be glad if you could > help me... > Here ist what I am planning to do: > Build a database with 1 Billion (10^9) rows describing geometric > properties: > Question Nr ONE --- Con

[GENERAL] Row Size and Indexing

2006-01-14 Thread tschak
Hi guys, I have some questions about postgres and would be glad if you could help me... Here ist what I am planning to do: Build a database with 1 Billion (10^9) rows describing geometric properties: create table steric_descriptor( distance0 bit(4), distance1 bit(4, distance2 bit(4, distance3 bit(