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 on some
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.
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.
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
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 Testproject 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 upload
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
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 stuff
-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-Michel
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,
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
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
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 to true
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,
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.) and/or
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
15 matches
Mail list logo