[GENERAL] tablespace and backup

2006-05-09 Thread Michelle Konzack
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

Re: [GENERAL] tablespace and backup

2006-05-09 Thread A.M.
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: