| From: | Wes <wespvp(at)syntegra(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Postgresql-General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Vacuum time degrading |
| Date: | 2005-03-08 15:44:21 |
| Message-ID: | BE530855.833C%wespvp@syntegra.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
Well, the good news is that the 2.24.29 kernel solved the kswapd problem.
That bad news is that it didn't help the vacuum time. In fact, the vacuum
time is now over 6 hours instead of 5 hours. Whether that is a direct
result of the 2.24.29 kernel, or a coincidence, I don't know at this time.
I guess the next step is to try reindexing a couple of the big indexes and
see if that helps.
Wes
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Scott Marlowe | 2005-03-08 15:47:29 | Re: postgresql vs mysql performance comparison |
| Previous Message | FERREIRA William (COFRAMI) | 2005-03-08 15:23:37 | Move cursor |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2005-03-08 16:52:39 | Re: ERROR: unrecognized node type in PostgresMain( ) |
| Previous Message | Klaus Naumann | 2005-03-08 13:57:59 | Re: About b-tree usage |