Vikram Kalsi <[EMAIL PROTECTED]> writes:
> Will icc be supported in any future release of pgsql?
Only if someone steps forward with patches. Do you want to do it?
My immediate reaction is that if icc doesn't actually cope with gcc
asm syntax then it has no business being treated as equivalent to
Hi,
I am trying to compile postgresql-8.0.1 with icc-8.1.028 on a Linux
RHEL AS3 SMP Itanium2 machine and I get an error as follows-
The complete config.log and make.log is online at
http://www.cse.psu.edu/~kalsi/files/
-
Tom,
I should be able to run more OLTP benchmarks, and a DSS benchmark, within the
next week. Please wait until I complete those before considering an 8.0.2
release with the new code.The machine and setup Mark is testing on is
kind of end-of-the-curve; I have some more middle-of-the-road
In the CTID docs:
http://www.postgresql.org/docs/8.0/interactive/ddl-system-columns.html
It mentions that VACUUM FULL will change the ctid, but I think it should
mention that CLUSTER will as well. Are there any other commands that
will? Mention UPDATE? We occasionally get people wanting to use
Tom Lane wrote:
> Mark Wong <[EMAIL PROTECTED]> writes:
> > On Wed, Mar 02, 2005 at 03:15:54PM -0500, Tom Lane wrote:
> >> Thanks. This seems odd though, since it appears to level out at
> >> something above 4K TPM. Your previous run
> >> http://www.osdl.org/projects/dbt2dev/results/dev4-010/311/
Michael Adler <[EMAIL PROTECTED]> writes:
> Looking at the "Response Time Charts"
> 8.0.1/ARC
> http://www.osdl.org/projects/dbt2dev/results/dev4-010/309/rt.html
> 20050301 with 2Q patch
> http://www.osdl.org/projects/dbt2dev/results/dev4-010/313/rt.html
> It seems like the average response tim
Mark Wong <[EMAIL PROTECTED]> writes:
> On Wed, Mar 02, 2005 at 03:15:54PM -0500, Tom Lane wrote:
>> Thanks. This seems odd though, since it appears to level out at
>> something above 4K TPM. Your previous run
>> http://www.osdl.org/projects/dbt2dev/results/dev4-010/311/
>> shows it dropping to 3
Hi all:
I have a question.
How to add table in slony.
I try to add table in already being database that using slony . but it's not
realize table's replication.
I used postgresql version 7.4.2 and slony version 1.0
Can you help me . Thanks
Yours,
Qu TianLian
---(end
Oliver Jowett wrote:
Francisco Figueiredo Jr. wrote:
After some testing, I could send an Execute message with 2 as the manx
number of rows. After the second execute I get the following:
portal "" does not exist
Severity: ERROR
Code: 34000
I noticed that I could only get it working if I explicitly c
Tom Lane wrote:
> Bruce Momjian writes:
> > Tom Lane wrote:
> >> First line of thought: we surely must not insert a snprintf into
> >> libpq.so unless it is 100% up to spec *and* has no performance issues
> >> ... neither of which can be claimed of the CVS-tip version.
>
> > Agreed, and we have t
Between those two runs, the vm parameters are the same.
Mark
On Wed, Mar 02, 2005 at 11:04:21AM -0500, Dave Cramer wrote:
> OK. I doubt that it impacts the results of the particular test, but it
> is non-intuitive (in my mind at least)
> Did you change anything else between 263 and 264? From the
> Bruce Momjian writes:
>> Tom Lane wrote:
>>> First line of thought: we surely must not insert a snprintf into
>>> libpq.so unless it is 100% up to spec *and* has no performance issues
>>> ... neither of which can be claimed of the CVS-tip version.
>
>> Agreed, and we have to support all the 64-b
On Wed, Mar 02, 2005 at 03:15:54PM -0500, Tom Lane wrote:
> Mark Wong <[EMAIL PROTECTED]> writes:
> > Ah, ok. I've reapplied the 2Q patch to CVS from 20050301:
> > http://www.osdl.org/projects/dbt2dev/results/dev4-010/313/
>
> > I ran it for 3 hours, just in case, and the charts suggest it fl
Mark Wong <[EMAIL PROTECTED]> writes:
> Ah, ok. I've reapplied the 2Q patch to CVS from 20050301:
> http://www.osdl.org/projects/dbt2dev/results/dev4-010/313/
> I ran it for 3 hours, just in case, and the charts suggest it flattens
> out after 2 hours.
Thanks. This seems odd though, since
On Wed, Mar 02, 2005 at 07:21:41AM -0800, Mark Wong wrote:
> Ah, ok. I've reapplied the 2Q patch to CVS from 20050301:
> http://www.osdl.org/projects/dbt2dev/results/dev4-010/313/
>
> I ran it for 3 hours, just in case, and the charts suggest it flattens
> out after 2 hours.
Looking at the
Bruce Momjian writes:
> Tom Lane wrote:
>> First line of thought: we surely must not insert a snprintf into
>> libpq.so unless it is 100% up to spec *and* has no performance issues
>> ... neither of which can be claimed of the CVS-tip version.
> Agreed, and we have to support all the 64-bit speci
Gavin Sherry wrote:
On Tue, 1 Mar 2005, Joshua D. Drake wrote:
Hello,
I am looking at having one of our guys write up the code to allow
logging as insert statements. I have a couple of questions.
What would we like the postgresql.conf option to be? I was thinking
log_statements_as_inserts = (t/f)
>
> Yes, strangly the Window's linker is fine because libpqdll.def defines
> what symbols are exported. I don't think Unix has that capability.
A non-static "public" function in a Windows DLL is not available for
dynamic linking unless explicitly declared as dll export. This behavior is
completel
OK. I doubt that it impacts the results of the particular test, but it
is non-intuitive (in my mind at least)
Did you change anything else between 263 and 264? From the table it
appears that you are changing vm parameters
as well as database configuration parameters between runs ?
Dave
Mark Wong
Yes, those parameters are based on a series of test results here:
http://www.osdl.org/projects/dbt2dev/results/pgsql/rc4.html
Run 264 provided the best results, so I'm trying to continue with the
database parameters used there.
Mark
On Wed, Mar 02, 2005 at 10:41:57AM -0500, Dave Cramer w
I was just looking at the config parameters, and you have the shared
buffers set to 60k, and the effective cache set to 1k
Dave
Mark Wong wrote:
On Tue, Mar 01, 2005 at 05:17:07PM -0500, Tom Lane wrote:
Mark Wong <[EMAIL PROTECTED]> writes:
On Tue, Mar 01, 2005 at 04:57:11PM -0500, T
Tom Lane wrote:
> Bruce Momjian writes:
> > Have we considered what is going to happen to applications when they use
> > our snprintf instead of the one from the operating system?
>
> Hmm ...
>
> First line of thought: we surely must not insert a snprintf into
> libpq.so unless it is 100% up to
On Tue, Mar 01, 2005 at 05:17:07PM -0500, Tom Lane wrote:
> Mark Wong <[EMAIL PROTECTED]> writes:
> > On Tue, Mar 01, 2005 at 04:57:11PM -0500, Tom Lane wrote:
> >> Curious. The immediate question is "does it ever flatten out, and
> >> if so at what TPM rate compared to 8.0.1?" Could you run the
>
> The big question is why our own vsnprintf() is not being called from
> snprintf() in our port file.
>
I have seen this "problem" before, well, it isn't really a problem I guess.
I'm not sure of the gcc compiler options, but
On the Microsoft compiler if you specify the option "/Gy" it sep
--On Freitag, Februar 25, 2005 12:02:47 -0500 Tom Lane <[EMAIL PROTECTED]>
wrote:
I wouldn't mind seeing people be a little more vocal on the hackers list
about what they plan to be doing, just so that there's not duplication
of effort.
Jaime Casanova and me are still working on view update rules
On Wed, 2 Mar 2005 09:24:32 +0100, Joerg Hessdoerfer
<[EMAIL PROTECTED]> wrote:
> don't know if PG borrowed the code from here, but according to the manpage
> FreeBSD 5.3 seems to have a quite complete implementation, see
> http://www.freebsd.org/cgi/man.cgi?query=snprintf&apropos=0&sektion=3&manpa
Seems to me that a better approach is a script which, given the log file
format, is able to parse and allow the user to format the insert
themselves.
Seems like a cool functionality that could be added to PQA...
Chris
---(end of broadcast)---
TIP 3: i
27 matches
Mail list logo
