| From: | Hannu Krosing <hannu(at)tm(dot)ee> |
|---|---|
| To: | "Ross J(dot) Reedstrom" <reedstrm(at)rice(dot)edu> |
| Cc: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>, Sergio Bruder <bruder(at)conectiva(dot)com(dot)br>, pgsql-hackers(at)postgresql(dot)org |
| Subject: | Re: Any tips for this particular performance problem? |
| Date: | 2001-07-11 12:11:26 |
| Message-ID: | 3B4C426E.6EEF45F1@tm.ee |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
"Ross J. Reedstrom" wrote:
>
> Hmm, I've pulled the appropriate file from CVS, now. Seems that v102
> has most the indices, so Stephan's request of example queries is the only
> way we're going to be able to help.
>
> Hmm, on third look, I've grovelled through the PHP for ACID 0.9.6b11
> (since that was in the snort CVS) and I see that ACID creates some tables,
> as well, one of which is missing an index that MySQL gets:
Also, do they run VACUUM ANALYZE after filling the table ?
PostgreSQL could choose very poor plans without it.
-------------
Hannu
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jan Wieck | 2001-07-11 12:19:46 | Re: New SQL Datatype RECURRINGCHAR |
| Previous Message | markMLl.pgsql-general | 2001-07-11 12:06:05 | Re: 2 gig file size limit |