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

[PFC <lists@xxxxxxxxxx>]

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