Stephan Vollmer <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend