[GENERAL] tablespace and backup
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
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: