Re: Performance query about large tables, lots of concurrent access

> 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.