source of this "blowup"?
Thanks for your help,
Tschak
---(end of broadcast)---
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get th
ould give me a hint which system to use (DB2, Sybase, Oracle,
Informix, Postgres) this would be great...
THX
tschak
---(end of broadcast)---
TIP 5: don't forget to increase your free space map settings
> If you don't need an OID, don't include it. IIRC, bit(4) will be 8
> bytes due to being variable length. If you want to store small numbers,
> maybe smallint (2 bytes) is more useful.
What I acually meant was the OID... Is smallint(2) the smalles size I
can allocate? If I cannot allocate 4Bit o
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(
pipelining I would not need to worry about partitioning the query and
thus distributing the workload.
At least as far as I understand the pipelining feature...
tschak
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will ignore your
r than
7.3).
My question is now wether the result is returned linewise in an newer
version and if yes, wether a program using the
S(erver)P(rogramming)I(interface) can utilize this functionality in
order get a better distribution of the workload?
Thx for your help,
tschak
