Re: [HACKERS] A multi CUP performance problem

Not exactly, I think. It said that postgresql "Add code to detect an SMP machine and handle spinlocks accordingly", so it is an issue of spinlock handling, not the distribution of execution tree. In SMP enviorment, when using spinlock, when we fail to get the spin lock a

Re: [HACKERS] A multi CUP performance problem

Li YueXin <[EMAIL PROTECTED]> writes: >I found postgresql running on the multi CPU machine doesn't have >better performance than single CPU machine. Can you explain the >reason? That's a rather sweeping statement to make without offering any evidence, I should think. If you gave deta

Re: [HACKERS] invalid tid errors in latest 7.3.4 stable.

Wade Klaver <[EMAIL PROTECTED]> writes: > Stumbled across an odd problem while cleaning data out of a database. I am > getting these "invalid tid" errors. I tried the upgrade from 7.3.2 to > 7.3.4. Hm. We fixed something with a similar symptom as of 7.3.3: http://archives.postgresql.org/pgsql-

Re: [HACKERS] Development Partner

xinsong wu wrote: > Hi, > I am a Ph.D candidate of Institute of Software, the Chinese Academic of > Science, and the major is computer software and theory. My research > interests are mainly focused on database management or other system > software.I want to be a development partner of your project

Re: [HACKERS] A multi CUP performance problem

On Tue, 2003-09-23 at 22:45, Li YueXin wrote: > I found postgresql running on the multi CPU machine doesn't have > better performance than single CPU machine. Can you explain the > reason? In addition to what Christopher Browne suggests, keep in mind that PostgreSQL spawns a separate Unix process

Re: [HACKERS] A multi CUP performance problem

Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Li YueXin) would write: > I found postgresql running on the multi CPU machine doesn't have > better performance than single CPU machine. Can you explain the > reason? And how to resolve the problem? The classic reason for this is that if y

[HACKERS] A multi CUP performance problem

I found postgresql running on the multi CPU machine doesn't have better performance than single CPU machine. Can you explain the reason? And how to resolve the problem? In the Todo list, I read the below message: Add code to detect an SMP machine and handle spinlocks accordingly from d

Re: [HACKERS] pg_dump doesn't dump binary compatible casts

Jan Wieck <[EMAIL PROTECTED]> writes: > braking the application with every dump+restore to remind the programmer > that there's still something he has to fix is the _right thing_. I would hate to be the sysadmin restoring a database after a hardware failure scratching my head to try to figure ou

[HACKERS] Building from CVS issues

Hi All, I'm attempting to build from CVS so I can get into a bit of PG dev work. Are there any special tricks with the CVS build or is this a common error? bison -y -d preproc.y preproc.y:5276: warning: previous rule lacks an ending `;' preproc.y:6294: fatal error: maximum table size (32767) ex

Re: [HACKERS] Building from CVS issues

My bad - I didn't even notice the bison version message. Please ignore this. Rgds, Jason [EMAIL PROTECTED] wrote: > Hi All, > > I'm attempting to build from CVS so I can get into a bit of PG dev work. > Are there any special tricks with the CVS build or is this a common error? > > bison -y -d

[HACKERS] bug in vacuumlo?

Hi, I tried to use vacuumlo of posgres-7.3.4/contrib/vacuumlo and it didn't work for me until I added one line: strcat(buf, " AND c.relname <> 'vacuum_l'"); after strcat(buf, "SELECT c.relname, a.attname "); strcat(buf, "FROM pg_class c, pg_attribute a, pg_type t "); strcat

[HACKERS] invalid tid errors in latest 7.3.4 stable.

Hello folks, Stumbled across an odd problem while cleaning data out of a database. I am getting these "invalid tid" errors. I tried the upgrade from 7.3.2 to 7.3.4. I tried a dumpall/initdb/restore... nadda. Nothing really usefull is coming from the logs either, even though logging is crank

[HACKERS] ecpg build on AIX 4.2.1

I am getting Undefined symbols in build ecpg gmake -C compatlib all gmake[4]: Entering directory `/usr/local/postgres/pgsql/src/interfaces/ecpg/compatlib' ../../../../src/backend/port/aix/mkldexport.sh libecpg_compat.a > libecpg_compat.exp gcc -O2 -pipe -Wall -Wmissing-prototypes -Wmissing-declar

Re: [HACKERS] New SQL standard ...

"Marc G. Fournier" <[EMAIL PROTECTED]> writes: > SQL:2003 Documents New!!! > This set of files represents an almost indistinuishable delta on the > actual SQL 2003 standard. In a few months, the INCITS website will post > the SQL 2003 standard for purchase > is this the same as what we talk about

[HACKERS] New SQL standard ...

Looking at the web site: SQL:2003 Documents New!!! This set of files represents an almost indistinuishable delta on the actual SQL 2003 standard. In a few months, the INCITS website will post the SQL 2003 standard for purchase is this the same as what we talk about as SQL3?? -- Forward

Re: [HACKERS] website announcement for 7.4 beta

Cause no one thought of it? I've gone ahead and submitted something, in the future don't hesitate to submit news items you think are of importance to the community. Robert Treat On Tue, 2003-09-23 at 14:11, Neil Conway wrote: > Is there a reason why there haven't been any 7.4 beta announcements

Re: [HACKERS] [GENERAL] Can't Build 7.3.4 on OS X

Tom Lane writes: > We used to have a similar requirement for some other platforms (AIX > I think), and there was a macro named something like BE_SHLIBS to > include the right platform-dependent stuff for such shlibs. Not sure > what happened to it. Peter, do you remember that? BE_DLLLIBS; see M

[HACKERS] website announcement for 7.4 beta

Is there a reason why there haven't been any 7.4 beta announcements on the main website? -Neil ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] [GENERAL] Can't Build 7.3.4 on OS X

Marko Karppinen <[EMAIL PROTECTED]> writes: >> 3. What's with the WITHOUT_DARWIN_BUNDLE_LOADER hack for ecpg? > The linker doesn't like symbols that are defined both in the shared > object > that's being linked and the bundle_loader binary. ecpg contains symbols > that are in the postgresql bina

Re: [HACKERS] pg_dump doesn't dump binary compatible casts

Jan Wieck <[EMAIL PROTECTED]> writes: > That eliminated, a cast should be dumped if one or more of the three > objects (source, target and function) are not builtin AND all the > non-builtin objects belong to namespaces included in the dump. Where "builtin" is defined as "belongs to pg_catalog s

Re: [HACKERS] pg_dump doesn't dump binary compatible casts

Tom Lane wrote: Jan Wieck <[EMAIL PROTECTED]> writes: I classify this problem as a bug. Objections? The question is not whether it is a bug, the question is what is correct behavior instead. Not yet, but when we have a decision and a fix it'll be the criterium for applying it to 7.4 and maybe b

Re: [HACKERS] [GENERAL] Can't Build 7.3.4 on OS X

On 23.9.2003, at 19:01, Tom Lane wrote: 1. Doesn't this break backward compatibility with Darwin 1.0-1.2? (If so, does anyone care anymore?) No. The two-level namespace feature was added in 10.1, and the -flat_namespace hack was included in pgsql to unbreak the compile on 10.1 and later. This

Re: [HACKERS] Improving REINDEX for system indexes (long)

Hiroshi Inoue wrote: Gaetano Mendola [mailto:[EMAIL PROTECTED] wrote: Hiroshi Inoue wrote: instead. Because it was impossible to make REINDEX transaction-safe then, such flag was needed to suppress inconsistency as less as possible. This mean that the actual REINDEX is not transaction-safe ? No

Re: [HACKERS] [GENERAL] Can't Build 7.3.4 on OS X

Marko Karppinen <[EMAIL PROTECTED]> writes: > While we're on a Mac-related note, I managed to compile PostgreSQL on > Mac OS X 10.2 Jaguar with two-level namespace support. > TwoLevelNamespaces.html> This is quite useful,

Re: [HACKERS] pg_dump doesn't dump binary compatible casts

Jan Wieck <[EMAIL PROTECTED]> writes: > I classify this problem as a bug. Objections? The question is not whether it is a bug, the question is what is correct behavior instead. > IMHO a binary compatible cast should be dumped if one or both namespaces > of the underlying data types is included i

[HACKERS] pg_dump doesn't dump binary compatible casts

The offending source code is in pg_dump.c line 3953, where at the lack of an underlying conversion function and thus no clear namespace relationship pg_dump simply ignores the cast. IMHO a binary compatible cast should be dumped if one or both namespaces of the underlying data types is included

Re: [HACKERS] free(3)-ing variables in pg_dump

Andreas Joseph Krogh <[EMAIL PROTECTED]> writes: > Shall I bother to free(3) them? No. They need to live for the entire pg_dump run, so there's no point in writing code to free them. regards, tom lane ---(end of broadcast)-

Re: [HACKERS] Question on adding new indexes to Postgresql

Zhen Yang <[EMAIL PROTECTED]> writes: > What are the C interface functions in Postgresql to add indexes? You will need to study the source code for the existing index types. There is not much documentation other than the sources for the index access method APIs. regards, t

Re: [HACKERS] free(3)-ing variables in pg_dump

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Tuesday 23 September 2003 16:25, Andrew Dunstan wrote: > Andreas Joseph Krogh wrote: > >Hi. > > > >I'm trying to implement functionallity to dump multiple tables with > > multiple "-t " options. > > excellent. > > >While digging in the source for pg

Re: [HACKERS] free(3)-ing variables in pg_dump

Andreas Joseph Krogh wrote: Hi. I'm trying to implement functionallity to dump multiple tables with multiple "-t " options. excellent. While digging in the source for pg_dump I see that many local static variables are not freed( with free(3)). Is this lazy programming because pg_dump is its

[HACKERS] Question on adding new indexes to Postgresql

Hello, I am posting to ask for some help and suggestions. For a project I am doing in university, I need to add indexing mechanisms to the Postgresql database (R+ tree, bitmap indexes). Version of Postgresql is 7.3.3. I would like to ask how I can integrate the structures and algorithms for the i

[HACKERS] free(3)-ing variables in pg_dump

-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hi. I'm trying to implement functionallity to dump multiple tables with multiple "-t " options. While digging in the source for pg_dump I see that many local static variables are not freed( with free(3)). Is this lazy programming because pg_dump is

Re: [HACKERS] Improving REINDEX for system indexes (long)

> -Original Message- > From: Gaetano Mendola [mailto:[EMAIL PROTECTED] > > Hiroshi Inoue wrote: > > instead. Because it was impossible to make REINDEX transaction-safe > > then, such flag was needed to suppress inconsistency as less > > as possible. > > This mean that the actual REINDEX

Re: [HACKERS] Improving REINDEX for system indexes (long)

Hiroshi Inoue wrote: > instead. Because it was impossible to make REINDEX transaction-safe > then, such flag was needed to suppress inconsistency as less > as possible. This mean that the actual REINDEX is not transaction-safe ? Regards Gaetano Mendola ---(end of broadc

Re: [HACKERS] missing pg_clog files ?

On Mon, Sep 22, 2003 at 02:21:43PM -0400, Alvaro Herrera wrote: > On Mon, Sep 22, 2003 at 05:03:28PM +0100, Patrick Welche wrote: > > On Mon, Sep 22, 2003 at 11:33:30AM -0400, Tom Lane wrote: > > > Patrick Welche <[EMAIL PROTECTED]> writes: > > > > I hope I guessed the right syntax... > > > > % pg_