| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Stephan Vollmer <svollmer(at)gmx(dot)de> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Creation of tsearch2 index is very slow |
| Date: | 2006-01-20 17:09:13 |
| Message-ID: | 25034.1137776953@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Stephan Vollmer <svollmer(at)gmx(dot)de> 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tony Caduto | 2006-01-20 17:12:33 | what am I doing wrong with this query? |
| Previous Message | Martijn van Oosterhout | 2006-01-20 17:04:52 | Re: Creation of tsearch2 index is very slow |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jim C. Nasby | 2006-01-20 17:12:14 | Re: Autovacuum / full vacuum (off-topic?) |
| Previous Message | Martijn van Oosterhout | 2006-01-20 17:04:52 | Re: Creation of tsearch2 index is very slow |