Question: Does anyone have any idea what bottleneck I am hitting? An index's performance should in theory scale as the log of the number of rows - what am I missing here?

        These can help people on the list to help you :

        - Your hardware config (CPU, RAM, disk) ?
        - EXPLAIN ANALYZE from slow queries ?
        - VACUUM and ANALYZE : yes ? how often ?
        - VACUUM VERBOSE output

for huge bits of text with long line length, mail sucks, upload to a web host or something.

---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?

              http://www.postgresql.org/docs/faq

Reply via email to