Stephan Vollmer <svollmer@xxxxxx> writes: > Unfortunately, I'm not able to investigate it further myself as I'm > quite a Postgres newbie. But I could provide someone else with the > example table. Maybe someone else could find out why it is so slow. I'd be willing to take a look, if you'll send me the dump file off-list. > I dropped all unnecessary columns and trimmed the table down to > 235,000 rows. The dumped table (compressed with RAR) is 7,1 MB. I > don't have a website to upload it but I could send it to someone via > e-mail. Don't have RAR --- gzip or bzip2 is fine ... regards, tom lane