Optimization levels when compiling PostgreSQL...

Поиск
Список
Период
Сортировка
Искать
От
Sean Chittenden
Тема
Optimization levels when compiling PostgreSQL...
Дата
Msg-id
20020909212720.GF26147@ninja1.internal
Список
Дерево обсуждения
Optimization levels when compiling PostgreSQL... Sean Chittenden <sean@chittenden.org>
Re: Optimization levels when compiling PostgreSQL... Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimization levels when compiling PostgreSQL... Sean Chittenden <sean@chittenden.org>
Re: Optimization levels when compiling PostgreSQL... Bruce Momjian <pgman@candle.pha.pa.us>
Re: Optimization levels when compiling PostgreSQL... Florian Weimer <Weimer@CERT.Uni-Stuttgart.DE>
Re: Optimization levels when compiling PostgreSQL... Neil Conway <neilc@samurai.com>
Re: Optimization levels when compiling PostgreSQL... Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimization levels when compiling PostgreSQL... Sean Chittenden <sean@chittenden.org>
Re: Optimization levels when compiling PostgreSQL... Tom Lane <tgl@sss.pgh.pa.us>
Re: Optimization levels when compiling PostgreSQL... Sean Chittenden <sean@chittenden.org>
Re: Optimization levels when compiling PostgreSQL... Peter Eisentraut <peter_e@gmx.net>
Re: Optimization levels when compiling PostgreSQL... Curt Sampson <cjs@cynic.net>
Re: Optimization levels when compiling PostgreSQL... Bruce Momjian <pgman@candle.pha.pa.us>
Re: Optimization levels when compiling PostgreSQL... Sean Chittenden <sean@chittenden.org>
Re: Optimization levels when compiling PostgreSQL... Bruce Momjian <pgman@candle.pha.pa.us>
Re: Optimization levels when compiling PostgreSQL... Sean Chittenden <sean@chittenden.org>
Re: Optimization levels when compiling PostgreSQL... Neil Conway <neilc@samurai.com>
Re: Optimization levels when compiling PostgreSQL... Sean Chittenden <sean@chittenden.org>
Re: Optimization levels when compiling PostgreSQL... Peter Eisentraut <peter_e@gmx.net>
Re: Optimization levels when compiling PostgreSQL... Curt Sampson <cjs@cynic.net>
Re: Optimization levels when compiling PostgreSQL... Lamar Owen <lamar.owen@wgcr.org>
Re: Optimization levels when compiling PostgreSQL... Curt Sampson <cjs@cynic.net>
Re: Optimization levels when compiling PostgreSQL... Bruce Momjian <pgman@candle.pha.pa.us>
In an attempt to beef up the PostgreSQL port for FreeBSD, I've added
an option for adding additional optimization, similar to what MySQL
does by compiling the server with -O6.  I'm only compiling at -O3 with
the flag at the moment, however I wanted to ping the idea around to
make sure this isn't some land-mine that doesn't show up in the
regression tests.  My database hardware is in transition to a new
data center so I can't test this on my own at the moment.  :-/

The size difference between -O and -O3 is only 200K or so... does
anyone think that it'd be safe to head to -O6 on a wide scale?  I
don't want to cream the FreeBSD user base with a bogus recommendation.

I figure this is a database and 200KB doesn't amount to bo-diddly
compared to my data sizes so this seems acceptable in that dept.  I'm
even thinking about going so far as to have flex required for the
build dependencies and setting -Cf or -CF for building the scanner
(need to check the archives for which turned out to be faster).

I'm also tinkering with the idea of automatically turn off fsync if
optimize is set.  Objections?  -sc

-- 
Sean Chittenden
В списке pgsql-hackers по дате отправления
От: Sean Chittenden
Дата:
От: Laurette Cisneros
Дата:
Сообщение: Re:
FAQ