| From: | Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> |
|---|---|
| To: | "Scott Marlowe" <scott(dot)marlowe(at)gmail(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Greg Smith" <gsmith(at)gregsmith(dot)com>, "PostgreSQL General ML" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Performance problem. Could it be related to 8.3-beta4? |
| Date: | 2008-01-06 19:46:33 |
| Message-ID: | a595de7a0801061146k76207afficb020f527ce2f3f@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
2008/1/6, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>:
> On Jan 6, 2008 5:06 AM, Clodoaldo <clodoaldo(dot)pinto(dot)neto(at)gmail(dot)com> wrote:
> >
> > Then I rebuilt and reinstalled postgresql with the xlog_seg_size set
> > to the default 16MB and did initdb. Now the time is 7,642 sec.
> >
> > I'm lost. It looks like 1GB xlog_seg_size is indeed faster than 16MB
> > but again it is slower than the production server which uses the
> > default xlog_seg_size.
>
> How fast was it the second time you ran it?
You mean the new server with 16MB xlog_seg_size? Yes, I did run it
twice and both took about the same time. In all tests (all
configurations) I did an analyze before running so I think that is the
real time.
Regards, Clodoaldo Pinto Neto
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2008-01-07 02:22:09 | Re: Index trouble with 8.3b4 |
| Previous Message | Hannes Dorbath | 2008-01-06 19:42:00 | Index trouble with 8.3b4 |