_fact;
Table "public.daily_area_fact"
Column | Type | Modifiers
---+-+---
time_id | integer | not null
ccid | integer | not null
area_id | integer | not null
uu_id | integer | not null
geo_id| integer | not null
imps | integer |
n this database, then yes, table scans are going to be huge, thus
why it's taking so long, plus dedupping on unique user id :)
and you're right, i should put this on the performance mailing list... see you
there :)
thanks guys.
____
Mark Jensen
- Or
http://www.postgresql.org/files/documentation/books/aw_pgsql/node210.html
just a simple command to copy data to and from tables/files.
Mark Jensen
- Original Message
From: Andrus <[EMAIL PROTECTED]>
To: pgsql-general@postgresql.org
Sent: Wed
