Hi guys,
I have postgresql server with huge amount of data, nearly 2 billion records. each record is at most 50 bytes(4 integer fields). I need to build index on all column to do fast reporting. but indexes becomes bloat after some time. almost 80% of database size is because of its huge indexes. I need some comprehensive external indexing solution so I remove indexes on DB. I found Lucene but it is for full text searching. my fields are all integer. Is there any good solution?