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
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
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'
- 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
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
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
-
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
> 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
- 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
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
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
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
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
[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
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
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
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
[ 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
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,
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
20 matches
Mail list logo
