I wrote:
> ... and see how the patch does that way?
BTW, please do look at "vmstat 1" while running the test case
corresponding to your number of processors. It's hard to tell from the
runtime alone whether the patch is fully accomplishing its goal of
reducing wasted cycles. If you see user CPU
"Lee, Patricia S." <[EMAIL PROTECTED]> writes:
> Is there any documentation out there regarding the process used by the
> postgreSQL development team on how Autoconf is used to create template
> files for configuration of different operating systems (e.g. MinGW on
> Windows, Red Hat Linux, etc.) an
Is there any documentation out there regarding the process used by the
postgreSQL development team on how Autoconf is used to create template
files for configuration of different operating systems (e.g. MinGW on
Windows, Red Hat Linux, etc.) and/or different hardware systems (e.g.
Intel processor,
"huaxin zhang" <[EMAIL PROTECTED]> wrote
>I need a way to tell how many pages loaded from disk for a particular
> index seek operation.
By pages loaded, you mean physically or logically? In either ways, I would
suggest you to take a look at _bt_getbuf().
>
> What I did is to set a global flag t
Tom Lane wrote:
I probably should have broken down the spindelay patch into multiple
components. But it's only a small change --- could you try simplifying
the patched line
if ((--spins % MAX_SPINS_PER_DELAY) == 0)
to
if (--spins == 0)
and see how the patch does that way?
I'll do tomorrow
"Michael Paesold" <[EMAIL PROTECTED]> writes:
> It seems to me the slock-no-cmpb is a win in any case. The spin-delay patch
> does not really help much on this machine. That seems to match Stephen
> Frost's results with EM64T, if I read them correctly.
Yeah, it's interesting that you both see sl
Tom Lane wrote:
Comments and testing invited.
I have tested the patches on a Dual Xeon 2,4 GHz w/ HT (no EM64T).
(Configured with
"CFLAGS='-O2 -mcpu=pentium4 -march=pentium4' --enable-casserts").
The results were pretty stable (around .2 seconds). I would not trust the
numbers for N=2, linux
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-hackers-
> [EMAIL PROTECTED] On Behalf Of Tino Wildenhain
> Sent: Monday, September 12, 2005 3:04 AM
> To: [EMAIL PROTECTED]
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Materialized Views in PostgreSQL
>
> Jean-
On Mon, Sep 12, 2005 at 09:06:03AM +0200, Martijn van Oosterhout wrote:
>
> The new gcc visibility stuff gives you way of shrinking the symbol
> table and improving performance.
And you really should start with making use of static, which has
about the same effect, except that the visibility stuf
Jean-Michel,
> Are there any plans to integrate materialized views written in plain C in
> the future. This can help gain a lot of time in Web applications.
We actually have some university code implementing materialized view handling
in the planner code. However, I keep not getting around to
Tom,
> The files for the updated test case are attached if anyone else wants
> to try it. They are:
I've added you to the "Performance Test"project on Pgfoundry (same login as
GBorg). Could you post the test files and patch there? I can get the
people at Sun to test on Sparc.
You can uploa
Jean-Michel Pouré schrieb:
Dear friends and all,
Johnathan Gardner did a wonderful job on materialized views:
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
Are there any plans to integrate materialized views written in plain C in the
future. This can help gain a lot of
Dear friends and all,
Johnathan Gardner did a wonderful job on materialized views:
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
Are there any plans to integrate materialized views written in plain C in the
future. This can help gain a lot of time in Web applications.
F
Dear friends and all,
Johnathan Gardner did a wonderful job on materialized views:
http://jonathangardner.net/PostgreSQL/materialized_views/matviews.html
Are there any plans to integrate materialized views written in plain C in the
future. This can help gain a lot of time in Web applications.
F
On Sun, Sep 11, 2005 at 10:32:51PM -0400, Tom Lane wrote:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > ... mixing -fpic and -fPIC libraries is a problem.
>
> Is it? I would think having two options would be essentially unworkable
> if so.
The thing is, on i386 it makes no difference, it's only o
15 matches
Mail list logo
