| From: | Gregory Stark <stark(at)enterprisedb(dot)com> |
|---|---|
| To: | "Alvaro Herrera" <alvherre(at)commandprompt(dot)com> |
| Cc: | "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "Greg Smith" <gsmith(at)gregsmith(dot)com>, "Guillaume Smet" <guillaume(dot)smet(at)gmail(dot)com>, "pgsql-performance" <pgsql-performance(at)postgresql(dot)org>, "Stefan Kaltenbrunner" <stefan(at)kaltenbrunner(dot)cc>, Devrim GÜNDÜZ <devrim(at)commandprompt(dot)com> |
| Subject: | Re: More shared buffers causes lower performances |
| Date: | 2007-12-27 14:51:40 |
| Message-ID: | 87fxxow5qb.fsf@oxford.xeocode.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
"Alvaro Herrera" <alvherre(at)commandprompt(dot)com> writes:
> Tom Lane escribió:
>
>> Currently the docs say that --enable-cassert
>>
>> Enables <firstterm>assertion</> checks in the server, which test for
>> many <quote>cannot happen</> conditions. This is invaluable for
>> code development purposes, but the tests slow things down a little.
>>
>> Maybe we ought to put that more strongly --- s/a little/significantly/,
>> perhaps?
>
> I don't think it will make any difference, because people don't read
> configure documentation. They read configure --help.
Fwiw I think you're all getting a bit caught up in this one context. While the
slowdown is significant when you take out the stopwatch, under normal
interactive use you're not going to notice your queries being especially slow.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
Ask me about EnterpriseDB's On-Demand Production Tuning
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jared Mauch | 2007-12-27 14:58:43 | Re: pg_dump performance |
| Previous Message | Bill Moran | 2007-12-27 13:50:09 | Re: With 4 disks should I go for RAID 5 or RAID 10 |