[HACKERS] VARHDRSZ

2003-10-11 Thread Christopher Kings-Lynne
Hi guys, For formatting types pre-7.1, how do I know what the value of VARHDRSZ is? (Given that it's a PHP script, say.) I need to be able to subtract that from the typmod to get the field length. Is it possible? Chris ---(end of broadcast)--- TI

Re: [HACKERS] [PATCHES] fix for strict-alias warnings

2003-10-11 Thread Andrew Dunstan
Bruce Momjian wrote: I understand the desire to deal with this later, but we never seem to focus on compiler issues except during beta. I think I know why we are hitting the warning in tablecmds.c and not in trigger.c. Trigger.c has: ExecCallTriggerFunc(TriggerData *trigdata,

Re: [HACKERS] [PATCHES] fix for strict-alias warnings

2003-10-11 Thread Bruce Momjian
[ Moved to hackers.] Andrew Dunstan wrote: > struct foobar { > int tag; > union { > struct foo foo; > struct bar bar; > } v; > }; > OK, this is very clear. Thanks. > > The proc.c cases were using MemSet, which was checking if the > > int* as aligned for int* access. In fact, w

Re: [HACKERS] [PERFORM] Sun performance - Major discovery!

2003-10-11 Thread Marko Karppinen
On 8.10.2003, at 21:31, Bruce Momjian wrote: Well, this is really embarassing. I can't imagine why we would not set at least -O on all platforms. Looking at the template files, I see these have no optimization set: darwin Regarding Darwin optimizations, Apple has introduced a "-f

Re: [HACKERS] Hacking PostgreSQL to work in Mac OS X 10.3 (Panther 7B85)

2003-10-11 Thread Marko Karppinen
James, we've spent some time lately with Mac OS X related changes to the code base. Please try this again with a fresh CVS copy of PostgreSQL and let us know if there are any further changes you think we'd need to work properly with Panther. Thanks, mk On 11.10.2003, at 04:32, James Wilson wrot

[HACKERS] Hacking PostgreSQL to work in Mac OS X 10.3 (Panther 7B85)

2003-10-11 Thread James Wilson
All, After toying with a few builds of the up coming OS X 10.3 (Panther) release, I've written a doc on how to get postgresql to build using Panther build 7B85 and Xcode build 7B85 (which are rumored to be the gold master and the builds that will be shipping later this month). Two things ne

Re: [HACKERS] pg_resetxlog fixed

2003-10-11 Thread Peter Eisentraut
[EMAIL PROTECTED] writes: > Changed a couple of lines and traslated them in a better way. Installed, and the other one as well. Please send it to pgsql-patches next time. -- Peter Eisentraut [EMAIL PROTECTED] ---(end of broadcast)--- TIP 4: D

Re: [HACKERS] compile warning

2003-10-11 Thread Andrew Dunstan
It has just been pointed out to me that the Freetype guy misconfigured his test settings, so the performance gain was not great. See http://www.freetype.org/pipermail/devel/2003-June/009453.html the other points are valid, though. I think we should be proud of the fact we can do this :-) - other

Re: [HACKERS] compile warning

2003-10-11 Thread Alvaro Herrera
On Sat, Oct 11, 2003 at 12:17:42PM -0400, Andrew Dunstan wrote: > If you don't want to do this we could turn off strict-aliasing. You might > take a performance hit, though - see > http://www.freetype.org/pipermail/devel/2003-June/009452.html for info on > what the FreeType people found. See the

Re: [HACKERS] compile warning

2003-10-11 Thread Alvaro Herrera
On Sat, Oct 11, 2003 at 12:31:35PM -0400, Bruce Momjian wrote: > > Agreed. Patch applied. I was confused because the original posted URL > mentioned unions, which was a different alignment issue from just > structure pointer compatibility. In the article Andrew mentioned, it is said that the un

Re: [HACKERS] compile warning

2003-10-11 Thread Bruce Momjian
Agreed. Patch applied. I was confused because the original posted URL mentioned unions, which was a different alignment issue from just structure pointer compatibility. --- Andrew Dunstan wrote: > > - Original Message

Re: [HACKERS] compile warning

2003-10-11 Thread Andrew Dunstan
- Original Message - From: "Bruce Momjian" <[EMAIL PROTECTED]> To: "Andrew Dunstan" <[EMAIL PROTECTED]> Cc: "PostgreSQL Hackers Mailing List" <[EMAIL PROTECTED]> Sent: Saturday, October 11, 2003 11:26 AM Subject: Re: [HACKERS] compile warning > Andrew Dunstan wrote: > > > > I have a fix

[HACKERS] OpenORB Re: 2-phase commit

2003-10-11 Thread Andrew Piskorski
> From: "Dann Corbit" <[EMAIL PROTECTED]> > Subject: Re: 2-phase commit > Date: Fri, 10 Oct 2003 21:37:53 -0700 > Why not apply the effort to something already done and compatibly > licensed? I'm not sure, what is your point here exactly? To use OpenORB as as a transaction monitor, you'd still n

Re: [HACKERS] compile warning

2003-10-11 Thread Bruce Momjian
Andrew Dunstan wrote: > > I have a fix for this which I will post to patches - essentially you cast > the pointers to (void *) and the compiler doesn't complain. It would be a > pity to turn off strict aliasing altogether, as it is known to improve > performance in some cases. > > Tested on Cygwi

Re: [HACKERS] compile warning

2003-10-11 Thread Andrew Dunstan
I have a fix for this which I will post to patches - essentially you cast the pointers to (void *) and the compiler doesn't complain. It would be a pity to turn off strict aliasing altogether, as it is known to improve performance in some cases. Tested on Cygwin/GCC 3.3.1 cheers andrew -

Re: [HACKERS] pg_ctl reload - is it safe?

2003-10-11 Thread Bruno Wolff III
On Fri, Oct 10, 2003 at 23:07:59 -0400, Michael Brusser <[EMAIL PROTECTED]> wrote: > Env: Postgres 7.3.4 on Unix > > I have a script to create a new database user and update pg_hba.conf. Do you run multiple databases with not all users having access to all databases? If any valid use will have

Re: [HACKERS] compile warning

2003-10-11 Thread Andrew Dunstan
- Original Message - From: "Manfred Spraul" <[EMAIL PROTECTED]> > > The kernel is still compiled with -fno-strict-aliasing - I'm not sure if > there are outstanding problems, or if it's just a safety precaution. > We should probably do likewise, at least until this is cleaned up, if that

Re: [HACKERS] 2-phase commit

2003-10-11 Thread Jeroen T. Vermeulen
On Fri, Oct 10, 2003 at 09:37:53PM -0700, Dann Corbit wrote: > Why not apply the effort to something already done and compatibly > licensed? > > This: > http://dog.intalio.com/ots.html > > Appears to be a Berkeley style licensed: > http://dog.intalio.com/license.html > > Transaction monitor. I'

Re: [HACKERS] performance difference between pgsql and SQL

2003-10-11 Thread Gavin Sherry
On Sat, 11 Oct 2003, Bill Shui wrote: > Hi, > > I am using postgreSQL 7.3.4 > > I have a single table in the databasse. > > mytable(id, tag, parent, label) > all in int8. > > hash index is built for id and btree index for all attributes. > Hash indexes are generally a bad idea in 7.3. > select

[HACKERS] performance difference between pgsql and SQL

2003-10-11 Thread Bill Shui
Hi, I am using postgreSQL 7.3.4 I have a single table in the databasse. mytable(id, tag, parent, label) all in int8. hash index is built for id and btree index for all attributes. now, I have over 9 million tuples in the table. The problem is when I access the database through psql interface