| From: | "Dave Dutcher" <dave(at)tridecap(dot)com> |
|---|---|
| To: | 'Piñeiro' <apinheiro(at)igalia(dot)com>, <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Re: Performance problem with Sarge compared with Woody |
| Date: | 2006-09-11 19:02:17 |
| Message-ID: | 002801c6d5d4$cd869490$8300a8c0@tridecap.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
> -----Original Message-----
> From: pgsql-performance-owner(at)postgresql(dot)org
> [mailto:pgsql-performance-owner(at)postgresql(dot)org] On Behalf Of Piñeiro
> Subject: [PERFORM] Performance problem with Sarge compared with Woody
> a week ago we migrate a Woody(postgre 7.2.1) server to Sarge(postgre
> 7.4.7). To migrate the database we use a dump, using pg_dump with this
> options:
> pg_dump -U <username> -c -F p -O -v -f <filename> <DBname>
>
> We have a search, that using woody take about 1-2 minutes, but with
> sarge it is executing about 2 hours, and at least it crashes, with a
> message about a temporal file and no more disk space ( i have
> more than
> a GB of free disk space).
>
> Any idea ?
The first question is did you run ANALYZE on the new database after
importing your data?
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jeff Davis | 2006-09-11 19:11:49 | Re: Performance problem with Sarge compared with Woody |
| Previous Message | Piñeiro | 2006-09-11 18:14:13 | Performance problem with Sarge compared with Woody |