You will need to provide more information about the data requirement- such
as column types, what you need to search for, and the actual queries and
execution plans.
Purely as a guess, it seems like you haven't tried partial indexes:
http://www.postgresql.org/docs/8.1/interactive/sql-createindex.ht
Hello,
for 4 weeks I have imported (text) data of 50 DVD's from a customer
into my PostgreSQL and now I have a very big problem... The maintable
(called 'timeline' is around 350 GByte in size...
...and searching is the hell!
Since I try to redesign my Dat
