| From: | John Smith <john_smith_45678(at)yahoo(dot)com> |
|---|---|
| To: | Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: UPDATE slow |
| Date: | 2003-02-05 06:21:48 |
| Message-ID: | 20030205062148.69643.qmail@web40709.mail.yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On the linux box it's 2.8 secs with only one index (on clicks) and no fk's. W/O, it's 1.8 secs. Both were done after 'vacuum analyze' and 'reindex table stats'.
John
Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com> wrote:
On Tue, 4 Feb 2003, John Smith wrote:
> That works - updates on foo take about 1.4 seconds. I dropped all the
> indexes and fk's on stats and updates there take about 2.8 seconds.
> These are on the cygwin machine.
The 2.8 seconds is on stats after dropping the fks and indexes? But
it didn't help on the linux box?
Have you done a vacuum/reindex recently?
---------------------------------
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now
| From | Date | Subject | |
|---|---|---|---|
| Next Message | John Smith | 2003-02-05 06:41:34 | Re: UPDATE slow |
| Previous Message | John Smith | 2003-02-05 06:08:08 | Re: UPDATE slow |