| From: | Russell Smith <mr-russ(at)pws(dot)com(dot)au> |
|---|---|
| To: | Kim <kim(at)myemma(dot)com> |
| Cc: | pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: unusual performance for vac following 8.2 upgrade |
| Date: | 2007-01-11 18:07:23 |
| Message-ID: | 45A67CDB.1000706@pws.com.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers pgsql-performance |
Kim wrote:
<snip>
> OS: Solaris 10
> write transactions/hr: 1.5 million
> size of pg_class: 535,226
> number of relations: 108,694
>
That is a huge pg_class. I remember some discussion recently about
problems with 8.2 and the way it scans pg_class. I also believe it's
fixed in 8.2.1. Are you running that. If not, I suggest you upgrade
and see if the fault still exists.
Regards
Russell Smith
> Thanks to all,
>
> Kim
>
> ---------------------------(end of broadcast)---------------------------
> TIP 7: You can help support the PostgreSQL project by donating at
>
> http://www.postgresql.org/about/donate
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Bruce Momjian | 2007-01-11 18:17:42 | Re: pgindent infelicity |
| Previous Message | Tom Lane | 2007-01-11 18:06:09 | Re: Checkpoint request failed on version 8.2.1. |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carlos H. Reimer | 2007-01-11 18:17:06 | Improving SQL performance |
| Previous Message | Kim | 2007-01-11 17:20:13 | unusual performance for vac following 8.2 upgrade |