Re: [HACKERS] PostgreSQL Core Team

Congrats Magnus!!! Thanks for the smart work and keep it up... -- Thanks & Regards, Ashesh Vashi EnterpriseDB INDIA: Enterprise PostgreSQL Company *http://www.linkedin.com/in/asheshvashi* On Thu, Apr 28, 2011 at 12:18 AM, D

[HACKERS] VX_CONCURRENT flag on vxfs( 5.1 or later) for performance for postgresql?

Dear all When database files are on a VxFS filesystem, performance can be significantly improved by setting the VX_CONCURRENT cache advisory on the file according to vxfs document, my question is that have any tested by this? #include ioctl(fd, VX_SETCACHE, VX_CONCURRENT); Regards HSIEN WEN

Re: [HACKERS] PostgreSQL Core Team

Congratulations!!! --- Koichi Dave Page : I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and ongoing maintenance of

Re: [HACKERS] PostgreSQL Core Team

Congratulations Magnus. On Thu, Apr 28, 2011 at 7:37 AM, Pavel Golub wrote: > Hello. > > Congratulations! > > You wrote: > > DP> I'm pleased to announce that effective immediately, Magnus Hagander > DP> will be joining the PostgreSQL Core Team. > > DP> Magnus has been a contributor to PostgreSQL

Re: [HACKERS] PostgreSQL Core Team

Hello. Congratulations! You wrote: DP> I'm pleased to announce that effective immediately, Magnus Hagander DP> will be joining the PostgreSQL Core Team. DP> Magnus has been a contributor to PostgreSQL for over 12 years, and DP> played a major part in the development and ongoing maintenance of t

Re: [HACKERS] [ANNOUNCE] PostgreSQL Core Team

Grattis Magnus! ;-) --On 27 april 2011 19.48.48 +0100 Dave Page wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and on

Re: [HACKERS] Fail to search in array, produced by subquery - is it a bug?

> > well, if you *had* to use any you could rewrite that as: Using ANY I'll reduce number of subqueries, there are also some array overlappings, which works fine with same subquery - i.e. when " && " instead of " = ANY ". There is not full qi\uery in my first message of course. > SELECT * > FRO

Re: [HACKERS] unknown conversion %m

Andrew Dunstan writes: > What I'm thinking of doing is to set up something like: > #define PG_PRINTF_CHECK __printf__ BTW, gcc 2.95.3 documents "printf", and not "__printf__". Suggest not including the underscores, since that's apparently a johnny-come-lately spelling. It's not like any of t

Re: [HACKERS] unknown conversion %m

Andrew Dunstan writes: > What I'm thinking of doing is to set up something like: > #define PG_PRINTF_CHECK __printf__ > and on Windows redefine it to __gnu_printf__, and then set all the > formats to use PG_PRINTF_CHECK. > Sound OK? +1 ... those __attribute__ declarations are messy enough

Re: [HACKERS] unknown conversion %m

On 04/28/2011 12:15 AM, Tom Lane wrote: I'd suggest adjusting the elog.h declarations to use gnu_printf only on Windows, and printf elsewhere, for the moment. Maybe we can migrate towards using gnu_printf on other platforms later. Yeah. In fact, if I adjust most of

Re: [HACKERS] Proposal - asynchronous functions

It sounds like there is interest in this feature, can it get added to the TODO list? -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] improvements to pgtune

> Every time I've gotten pulled into discussions of setting parameters > based on live monitoring, it's turned into a giant black hole--absorbs a > lot of energy, nothing useful escapes from it. I credit completely > ignoring that idea altogether, and using the simplest possible static > sett

Re: [HACKERS] unknown conversion %m

Andrew Dunstan writes: > OK, having gone a long way down this hole, I think I have the answer. > Using an attribute of 'gnu_printf' instead of just 'printf' on the > elog.h functions clears all those warnings. > The manual at >

Re: [HACKERS] make world fails

Peter Eisentraut writes: > On ons, 2011-04-27 at 17:54 -0300, Alvaro Herrera wrote: >> I take it that if I have a manpages/docbook.xsl in that path, it uses >> that instead of trying to fetch it from sourceforge. > Exactly. > If you don't want to depend on net access, you can do something like >

Re: [HACKERS] Best way to construct Datum out of a string?

=?ISO-8859-15?Q?Yves_Wei=DFig?= writes: > Am 27.04.2011 16:11, schrieb Heikki Linnakangas: >> What kind of a Datum do you want it to be? What data type? See >> CStringGetDatum, or perhaps CStringGetTextDatum(). Or perhaps you want >> to call the input function of some other datatype, with InputFun

Re: [HACKERS] XML with invalid chars

On Wed, Apr 27, 2011 at 11:22:37PM -0400, Andrew Dunstan wrote: > On 04/27/2011 05:30 PM, Noah Misch wrote: >> To make things worse, the dump/reload problems seems to depend on your >> version >> of libxml2, or something. With git master, a CentOS 5 system with >> 2.6.26-2.1.2.8.el5_5.1 accepts t

Re: [HACKERS] XML with invalid chars

On 04/27/2011 05:30 PM, Noah Misch wrote: I'm not sure what to do about the back branches and cases where data is already in databases. This is fairly ugly. Suggestions welcome. We could provide a script in (or linked from) the release notes for testing the data in all your xml columns. Ye

Re: [HACKERS] Predicate locking

27.04.2011 18:38, Heikki Linnakangas пишет: On 27.04.2011 12:24, Vlad Arkhipov wrote: 27.04.2011 17:45, Nicolas Barbier: 2011/4/27 Vlad Arkhipov: I'm currently need predicate locking in the project, so there are two ways to get it by now: implement it by creating special database records to l

Re: [HACKERS] improvements to pgtune

Daniel Farina wrote: It seems like in general it lacks a feedback mechanism to figure things out settings from workloads, instead relying on Greg Smith's sizable experience to do some arithmetic and get you off the ground in a number of common cases. To credit appropriately, the model used

Re: [HACKERS] improvements to pgtune

Shiv wrote: On the program I hope to learn as much about professional software engineering principles as PostgreSQL. My project is aimed towards extending and hopefully improving upon pgtune. If any of you have some ideas or thoughts to share. I am all ears!! Well, first step on the software

Re: [HACKERS] Introduction

Thank you for your compliment (about the name). Its quite sad though that the word Shiv does not exist in the Indian-English lexicon. So people just think of the God and not of a knife! I do have some ideas and heuristics in mind. I wanted to give out a small hello to the community for now. I will

Re: [ANNOUNCE] [HACKERS] PostgreSQL Core Team

My Congratulations too ;)!!! Enviado desde mi iPhone El 27/04/2011, a las 18:50, Hiroshi Saito escribió: > Congratulations!! > > (2011/04/28 3:48), Dave Page wrote: >> I'm pleased to announce that effective immediately, Magnus Hagander >> will be joining the PostgreSQL Core Team. >> >> M

Re: [HACKERS] [ANNOUNCE] PostgreSQL Core Team

Magnus, congratulations! In my short two years around PostgreSQL your name has been synonymous with super intelligence and a great attitude. All the best Sean On Apr 27, 2011, at 1:48 PM, Dave Page wrote: > I'm pleased to announce that effective immediately, Magnus Hagander > will be joining

Re: [HACKERS] unknown conversion %m

On 04/27/2011 11:58 AM, Andrew Dunstan wrote: On 04/27/2011 11:02 AM, Tom Lane wrote: So the question to ask is not why gcc doesn't complain about %m elsewhere, but why it does complain in your Windows installation. I'm guessing that the mingw people hacked it. If you're lucky, they might

Re: [HACKERS] PostgreSQL Core Team

Congratulations!! (2011/04/28 3:48), Dave Page wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and ongoing maintenan

Re: [HACKERS] PostgreSQL Core Team

Congratulations. Jeremiah Peschka Microsoft SQL Server MVP MCITP: Database Developer, DBA On Apr 27, 2011 11:49 AM, "Dave Page" wrote: > I'm pleased to announce that effective immediately, Magnus Hagander > will be joining the PostgreSQL Core Team. > > Magnus has been a contributor to PostgreSQL

Re: [HACKERS] "stored procedures" - use cases?

On Apr 27, 2011, at 3:28 PM, Josh Berkus wrote: > Actually, you can already sort of do that using XSLT. So I don't > necessary think that's a prohibitive idea, depending on implementation. > After all, many of the new non-relational databases implement exactly this. The proposed JSON data type

Re: [HACKERS] [ANNOUNCE] PostgreSQL Core Team

Congratulation! Regards, Nado Sent from my BlackBerry® powered by Sinyal Kuat INDOSAT -Original Message- From: Dave Page Sender: pgsql-announce-owner@postgresql.orgDate: Wed, 27 Apr 2011 19:48:48 To: pgsql-announce Cc: PostgreSQL Hackers; Subject: [ANNOUNCE] PostgreSQL Core Team I'm

Re: [HACKERS] "stored procedures" - use cases?

Greg, > Because we want to be able to manipulate data in queries in > data-type-specific ways. For example we want to do aggregations on the > result of a function or index scans across a user data type, etc. I don't see how this is different from wanting to capture error output, which would fac

Re: [HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

Dan Ports wrote: > On Wed, Apr 27, 2011 at 04:09:38PM -0500, Kevin Grittner wrote: >> Heikki Linnakangas wrote: >>> Hmm, could we upgrade all predicate locks to relation-level >>> predicate locks instead? >> >> Tied to what backend? > I think Heikki was suggesting to upgrade to relation-level

Re: [HACKERS] pg_upgrade automatic testing

On Wed, Apr 27, 2011 at 09:32:16PM +0300, Peter Eisentraut wrote: > On tor, 2011-04-07 at 23:02 +0300, Peter Eisentraut wrote: > > Seeing that 9.1-to-9.1 pg_upgrade has apparently been broken for months, > > it would probably be good to have some kind of automatic testing for it. > > Attached is so

Re: [HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

On Wed, Apr 27, 2011 at 02:59:19PM -0500, Kevin Grittner wrote: > For correct serializable behavior in the face of concurrent DDL > execution, I think that a request for a heavyweight ACCESS EXCLUSIVE > lock might need to block until all SIREAD locks on the relation have > been released. Pictur

Re: [HACKERS] make world fails

On ons, 2011-04-27 at 17:54 -0300, Alvaro Herrera wrote: > Excerpts from Alvaro Herrera's message of mié abr 27 17:28:32 -0300 2011: > > > I think you need to install some Docbook XSL package or other. > > In my system (Debian) I have a catalog.xml file from the docbook-xsl > package which has th

Re: [HACKERS] XML with invalid chars

On Wed, Apr 27, 2011 at 03:05:30PM -0400, Andrew Dunstan wrote: > On 04/26/2011 05:11 PM, Noah Misch wrote: >> On Mon, Apr 25, 2011 at 07:25:02PM -0400, Andrew Dunstan wrote: >>> I came across this today, while helping a customer. The following will >>> happily create a piece of XML with an embedde

Re: [HACKERS] PostgreSQL Core Team

2011/4/27 Dave Page : > I'm pleased to announce that effective immediately, Magnus Hagander > will be joining the PostgreSQL Core Team. > > Magnus has been a contributor to PostgreSQL for over 12 years, and > played a major part in the development and ongoing maintenance of the > native Windows por

Re: [HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

Heikki Linnakangas wrote: > On 27.04.2011 22:59, Kevin Grittner wrote: >> For correct serializable behavior in the face of concurrent DDL >> execution, I think that a request for a heavyweight ACCESS >> EXCLUSIVE lock might need to block until all SIREAD locks on the >> relation have been released

Re: [HACKERS] make world fails

Excerpts from Alvaro Herrera's message of mié abr 27 17:28:32 -0300 2011: > I think you need to install some Docbook XSL package or other. In my system (Debian) I have a catalog.xml file from the docbook-xsl package which has these two lines in it: http://docbook.sourceforge.net/release/xsl/cu

[HACKERS] new AM, build returns error

Hi, my new AM starts working..., calling something like CREATE INDEX idx ON films USING ebi (did) returns now: ERROR: unexpected EBI relation size: 3, should be 4294967295 The second argument looks for me like max uint32... there might be somehting wrong here I think? Is there somehting wrong

Re: [HACKERS] Introduction

On Tue, Apr 26, 2011 at 11:20 PM, Shiv wrote: > Dear pgsql-hackers, >  My name is Sivasankar Ramasubramanian (you can call me Shiv). That's an awesome nickname. > My project is aimed towards extending > and hopefully improving upon pgtune. If any of you have some ideas or > thoughts to share. I

Re: [HACKERS] make world fails

On Wed, Apr 27, 2011 at 9:29 PM, Kevin Grittner wrote: > Tom Lane wrote: >> "Kevin Grittner" writes: >>> I just did my usual: >>> make maintainer-clean \ >>>  && ./configure --prefix=/usr/local/pgsql-serializable \ >>>                 --enable-debug \ >>>                 --enable-cassert \ >>>  

Re: [HACKERS] Best way to construct Datum out of a string?

Am 27.04.2011 16:11, schrieb Heikki Linnakangas: > On 27.04.2011 17:06, Yves Weißig wrote: >> Hi, >> >> sadly, so far my search in the source code wasn't very successfull on >> this topic. >> So, how can I construct a Datum out of a string? > > What kind of a Datum do you want it to be? What data

Re: [HACKERS] [COMMITTERS] pgsql: Fix pg_size_pretty() to avoid overflow for inputs close to INT64

Excerpts from Tom Lane's message of mié abr 27 17:10:37 -0300 2011: > Alvaro Herrera writes: > > Excerpts from Tom Lane's message of lun abr 25 17:22:41 -0300 2011: > >> Fix pg_size_pretty() to avoid overflow for inputs close to INT64_MAX. > > > Apparently this change is causing Moa's SunStudio c

Re: [HACKERS] make world fails

Tom Lane wrote: > "Kevin Grittner" writes: >> I just did my usual: >> make maintainer-clean \ >> && ./configure --prefix=/usr/local/pgsql-serializable \ >> --enable-debug \ >> --enable-cassert \ >> --enable-depend \ >> --with-libxml

Re: [HACKERS] make world fails

Excerpts from Kevin Grittner's message of mié abr 27 16:39:01 -0300 2011: > I just did my usual: > > make maintainer-clean \ > && ./configure --prefix=/usr/local/pgsql-serializable \ > --enable-debug \ > --enable-cassert \ > --enable-depend \ >

Re: [HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

On 27.04.2011 22:59, Kevin Grittner wrote: For correct serializable behavior in the face of concurrent DDL execution, I think that a request for a heavyweight ACCESS EXCLUSIVE lock might need to block until all SIREAD locks on the relation have been released. Picture, for example, what might hap

Re: [HACKERS] PostgreSQL Core Team

On Wed, Apr 27, 2011 at 1:48 PM, Dave Page wrote: > I'm pleased to announce that effective immediately, Magnus Hagander > will be joining the PostgreSQL Core Team. > > Magnus has been a contributor to PostgreSQL for over 12 years, and > played a major part in the development and ongoing maintenanc

Re: [HACKERS] make world fails

"Kevin Grittner" writes: > I just did my usual: > make maintainer-clean \ > && ./configure --prefix=/usr/local/pgsql-serializable \ > --enable-debug \ > --enable-cassert \ > --enable-depend \ > --with-libxml \ > --wit

Re: [HACKERS] [COMMITTERS] pgsql: Fix pg_size_pretty() to avoid overflow for inputs close to INT64

Alvaro Herrera writes: > Excerpts from Tom Lane's message of lun abr 25 17:22:41 -0300 2011: >> Fix pg_size_pretty() to avoid overflow for inputs close to INT64_MAX. > Apparently this change is causing Moa's SunStudio compiler to fail an > assertion. [ scratches head... ] Hard to see why, there

[HACKERS] SIREAD lock versus ACCESS EXCLUSIVE lock

Composing my rather long-winded response to Simon got me thinking -- which just led me to realize there is probably a need to fix another thing related to SSI. For correct serializable behavior in the face of concurrent DDL execution, I think that a request for a heavyweight ACCESS EXCLUSIVE lock

Re: [HACKERS] "stored procedures" - use cases?

On Wed, Apr 27, 2011 at 6:48 PM, Josh Berkus wrote: > If you pursue your argument a little further, Greg, why do we have > functions at all?  We could do it all in the application. > >> Autonomous transactions have value on their own. But it's not so that >> you can run create index ocncurrently o

[HACKERS] make world fails

I just did my usual: make maintainer-clean \ && ./configure --prefix=/usr/local/pgsql-serializable \ --enable-debug \ --enable-cassert \ --enable-depend \ --with-libxml \ --with-python \ && make world Which ended

Re: [HACKERS] PostgreSQL Core Team

On Wed, Apr 27, 2011 at 1:48 PM, Dave Page wrote: > I'm pleased to announce that effective immediately, Magnus Hagander > will be joining the PostgreSQL Core Team. > Congratulations! -- Jaime Casanova         www.2ndQuadrant.com Professional PostgreSQL: Soporte y capacitación de PostgreSQL --

Re: [HACKERS] [GENERAL] PostgreSQL Core Team

On Apr 27, 2011, at 14:48, Dave Page wrote: > I'm pleased to announce that effective immediately, Magnus Hagander > will be joining the PostgreSQL Core Team. Congratulations, Magnus! Michael Glaesemann grzm seespotcode net -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.or

Re: [HACKERS] Alpha4 release blockers (was Re: wrapping up this CommitFest)

Excerpts from Dave Page's message of mié abr 27 16:15:33 -0300 2011: > On Wed, Apr 27, 2011 at 8:12 PM, Alvaro Herrera > wrote: > > BTW I just swapped the compiler details for those two animals in the > > buildfarm database. > > I thought Andrew did that already? He hadn't gotten around to actu

Re: [HACKERS] Alpha4 release blockers (was Re: wrapping up this CommitFest)

On 04/27/2011 03:15 PM, Dave Page wrote: On Wed, Apr 27, 2011 at 8:12 PM, Alvaro Herrera wrote: Excerpts from Dave Page's message of mié mar 02 16:38:00 -0300 2011: Should be. Moa is definitely Sun Studio: -bash-3.00$ /opt/sunstudio12.1/bin/cc -V cc: Sun C 5.10 SunOS_i386 2009/06/03 usage

Re: [HACKERS] Typed-tables patch broke pg_upgrade

On Wed, Apr 27, 2011 at 09:30:41PM +0300, Peter Eisentraut wrote: > Here is the patch to fix that, as discussed. Looks correct. Thanks. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Alpha4 release blockers (was Re: wrapping up this CommitFest)

On Wed, Apr 27, 2011 at 8:12 PM, Alvaro Herrera wrote: > Excerpts from Dave Page's message of mié mar 02 16:38:00 -0300 2011: > >> Should be. Moa is definitely Sun Studio: >> >> -bash-3.00$ /opt/sunstudio12.1/bin/cc -V >> cc: Sun C 5.10 SunOS_i386 2009/06/03 >> usage: cc [ options] files.  Use 'cc

Re: [HACKERS] Alpha4 release blockers (was Re: wrapping up this CommitFest)

Excerpts from Dave Page's message of mié mar 02 16:38:00 -0300 2011: > Should be. Moa is definitely Sun Studio: > > -bash-3.00$ /opt/sunstudio12.1/bin/cc -V > cc: Sun C 5.10 SunOS_i386 2009/06/03 > usage: cc [ options] files. Use 'cc -flags' for details > > And Huia is GCC: > > -bash-3.00$ /us

Re: [HACKERS] PostgreSQL Core Team

On 27 April 2011 19:48, Dave Page wrote: > I'm pleased to announce that effective immediately, Magnus Hagander > will be joining the PostgreSQL Core Team. > > Magnus has been a contributor to PostgreSQL for over 12 years, and > played a major part in the development and ongoing maintenance of the

Re: [HACKERS] XML with invalid chars

On 04/26/2011 05:11 PM, Noah Misch wrote: On Mon, Apr 25, 2011 at 07:25:02PM -0400, Andrew Dunstan wrote: I came across this today, while helping a customer. The following will happily create a piece of XML with an embedded ^A: select xmlelement(name foo, null, E'abc\x01def'); Now, a ^A

Re: [HACKERS] PostgreSQL Core Team

Kudos! Cheers, David. On Wed, Apr 27, 2011 at 07:48:48PM +0100, Dave Page wrote: > I'm pleased to announce that effective immediately, Magnus Hagander > will be joining the PostgreSQL Core Team. > > Magnus has been a contributor to PostgreSQL for over 12 years, and > played a major part in the de

Re: [HACKERS] [GENERAL] PostgreSQL Core Team

On 27/04/2011 19:48, Dave Page wrote: I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and ongoing maintenance of the native Wind

Re: [HACKERS] alpha5

Excerpts from Peter Eisentraut's message of mié abr 27 15:40:22 -0300 2011: > On tis, 2011-04-26 at 11:36 -0300, Alvaro Herrera wrote: > > This is a trivial patch (attached). The only problem with it is that > > "make all" would fail if lynx is not installed. > > Well, that will probably not be a

[HACKERS] PostgreSQL Core Team

I'm pleased to announce that effective immediately, Magnus Hagander will be joining the PostgreSQL Core Team. Magnus has been a contributor to PostgreSQL for over 12 years, and played a major part in the development and ongoing maintenance of the native Windows port, quickly becoming a committer t

Re: [HACKERS] alpha5

On 04/27/2011 02:40 PM, Peter Eisentraut wrote: On tis, 2011-04-26 at 11:36 -0300, Alvaro Herrera wrote: This is a trivial patch (attached). The only problem with it is that "make all" would fail if lynx is not installed. Well, that will probably not be acceptable. I rather think the action

Re: [HACKERS] Typed-tables patch broke pg_upgrade

Peter Eisentraut writes: > Here is the patch to fix that, as discussed. Looks sane --- I assume you tested it against the originally complained-of scenario? http://archives.postgresql.org/message-id/201103111328.p2bdsfd10...@momjian.us If so, please apply soon --- we need to wrap beta1 this even

Re: [HACKERS] alpha5

On tis, 2011-04-26 at 11:36 -0300, Alvaro Herrera wrote: > This is a trivial patch (attached). The only problem with it is that > "make all" would fail if lynx is not installed. Well, that will probably not be acceptable. I rather think the action item here is to set up a buildfarm-ish job that

Re: [HACKERS] pg_upgrade automatic testing

On tor, 2011-04-07 at 23:02 +0300, Peter Eisentraut wrote: > Seeing that 9.1-to-9.1 pg_upgrade has apparently been broken for months, > it would probably be good to have some kind of automatic testing for it. > Attached is something I hacked together that at least exposes the > current problems, ea

Re: timeline garbage in pg_basebackup (was [HACKERS] gcc 4.6 warnings -Wunused-but-set-variable)

On Wed, Apr 27, 2011 at 20:21, Peter Eisentraut wrote: > On ons, 2011-04-27 at 19:17 +0200, Magnus Hagander wrote: >> On Wed, Apr 27, 2011 at 18:55, Peter Eisentraut wrote: >> > On tis, 2011-03-29 at 23:48 +0300, Peter Eisentraut wrote: >> >> The line I marked in pg_basebackup.c might be an actua

Re: [HACKERS] Typed-tables patch broke pg_upgrade

Here is the patch to fix that, as discussed. diff --git i/src/bin/pg_dump/pg_dump.c w/src/bin/pg_dump/pg_dump.c index c2f6180..afc7fd7 100644 --- i/src/bin/pg_dump/pg_dump.c +++ w/src/bin/pg_dump/pg_dump.c @@ -12004,7 +12004,11 @@ dumpTableSchema(Archive *fout, TableInfo *tbinfo) "UNLOGGED

Re: timeline garbage in pg_basebackup (was [HACKERS] gcc 4.6 warnings -Wunused-but-set-variable)

On ons, 2011-04-27 at 19:17 +0200, Magnus Hagander wrote: > On Wed, Apr 27, 2011 at 18:55, Peter Eisentraut wrote: > > On tis, 2011-03-29 at 23:48 +0300, Peter Eisentraut wrote: > >> The line I marked in pg_basebackup.c might be an actual problem: It > >> goes through a whole lot to figure out the

Re: [HACKERS] SSI non-serializable UPDATE performance

Simon Riggs wrote: > Reading the code, IIUC, we check for RW conflicts after each write > but only if the writer is running a serializable transaction. Correct as far as that statement goes. There are cases where predicate lock maintenance is needed when dealing with locked resources; see bel

Re: [HACKERS] SSI non-serializable UPDATE performance

On Wed, Apr 27, 2011 at 06:26:52PM +0100, Simon Riggs wrote: > Reading the code, IIUC, we check for RW conflicts after each write but > only if the writer is running a serializable transaction. > > Am I correct in thinking that there is zero impact of SSI if nobody is > running a serializable tran

Re: [HACKERS] "stored procedures" - use cases?

> These don't seem like compelling use cases at all to me. You said you > had to fall back to using a python script outside the database, but > what disadvantage does that have? Why is moving your application logic > into the database an improvement? Since both were part of a code rollout, it com

Re: [HACKERS] SSI non-serializable UPDATE performance

On Mon, Apr 25, 2011 at 4:33 AM, Dan Ports wrote: > On Sat, Apr 23, 2011 at 08:54:31AM -0500, Kevin Grittner wrote: >> Even though this didn't show any difference in Dan's performance >> tests, it seems like reasonable insurance against creating a new >> bottleneck in very high concurrency situati

Re: timeline garbage in pg_basebackup (was [HACKERS] gcc 4.6 warnings -Wunused-but-set-variable)

On Wed, Apr 27, 2011 at 18:55, Peter Eisentraut wrote: > On tis, 2011-03-29 at 23:48 +0300, Peter Eisentraut wrote: >> The line I marked in pg_basebackup.c might be an actual problem: It >> goes through a whole lot to figure out the timeline and then doesn't >> do anything with it. > > This hasn't

Re: [HACKERS] gcc 4.6 warnings -Wunused-but-set-variable

On tis, 2011-03-29 at 23:48 +0300, Peter Eisentraut wrote: > As you might have heard, GCC 4.6 was released the other day. It > generates a bunch of new warnings with the PostgreSQL source code, most > of which belong to the new warning scenario -Wunused-but-set-variable, > which is included in -Wa

timeline garbage in pg_basebackup (was [HACKERS] gcc 4.6 warnings -Wunused-but-set-variable)

On tis, 2011-03-29 at 23:48 +0300, Peter Eisentraut wrote: > The line I marked in pg_basebackup.c might be an actual problem: It > goes through a whole lot to figure out the timeline and then doesn't > do anything with it. This hasn't been addressed yet. It doesn't manifest itself as an actual pr

Re: [HACKERS] unknown conversion %m

On 04/27/2011 11:02 AM, Tom Lane wrote: So the question to ask is not why gcc doesn't complain about %m elsewhere, but why it does complain in your Windows installation. I'm guessing that the mingw people hacked it. If you're lucky, they might have hacked in an extra switch to control the beh

Re: [HACKERS] Alignment padding bytes in arrays vs the planner

Noah Misch writes: > On Tue, Apr 26, 2011 at 07:23:12PM -0400, Tom Lane wrote: > [input functions aren't the only problematic source of uninitialized datum > bytes] > FWIW, when I was running the test suite under valgrind, these were the > functions that left uninitialized bytes in datums: array

Re: [HACKERS] Alignment padding bytes in arrays vs the planner

Greg Stark writes: > On Wed, Apr 27, 2011 at 12:23 AM, Tom Lane wrote: >> Any ideas about better answers? > Here's a crazy idea. We could use string equality of the out > function's representation instead. If an output function doesn't > consistently output the same data for things that are equa

Re: [HACKERS] alpha5

Excerpts from Heikki Linnakangas's message of mié abr 27 07:47:32 -0300 2011: > On 26.04.2011 17:36, Alvaro Herrera wrote: > >> I suggest having them be created in doc/src/sgml "all" target. This > >> gets them in "make docs" and "make world" AFAICT. > > > > This is a trivial patch (attached). T

Re: [HACKERS] unknown conversion %m

Andrew Dunstan writes: > What I'd like to know is why it doesn't complain elsewhere. That question is backwards ... > The one > non-Linux non-Windows machine I have is FBSD. Its gcc (4.2.1) doesn't > expand "%m" but doesn't complain about it either. It's libc, not gcc, that's actually got th

Re: [HACKERS] unknown conversion %m

Andrew Dunstan wrote: > What I'd like to know is why it doesn't complain elsewhere. It appears to be allowed as an "extension" on some compliers. http://sourceware.org/ml/newlib/2006/msg00079.html -Kevin -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make change

Re: [HACKERS] unknown conversion %m

On 04/27/2011 10:29 AM, Tom Lane wrote: Andrew Dunstan writes: On 04/27/2011 12:50 AM, Tom Lane wrote: Andrew Dunstan writes: All or almost all the warnings seen on Windows/Mingw of the type "warning: unknown conversion type character 'm' in format" come from checking of three functions:

Re: [HACKERS] unknown conversion %m

Andrew Dunstan writes: > On 04/27/2011 12:50 AM, Tom Lane wrote: >> Andrew Dunstan writes: >>> All or almost all the warnings seen on Windows/Mingw of the type >>> "warning: unknown conversion type character 'm' in format" come from >>> checking of three functions: errmsg, elog and errdetail. I t

Re: [HACKERS] fixing INT64_FORMAT warnings on Mingw

On 04/27/2011 09:00 AM, Peter Eisentraut wrote: On Wed, 2011-04-27 at 00:01 -0400, Andrew Dunstan wrote: Both "%lld" and "%I64d" can be used with mingw to print 64 bit integers. However, modern versions of gcc spit warnings with the former, and not the latter. However, since "%lld" works, it i

Re: [HACKERS] Best way to construct Datum out of a string?

On 04/27/2011 10:06 AM, Yves Weißig wrote: Hi, sadly, so far my search in the source code wasn't very successfull on this topic. So, how can I construct a Datum out of a string? CStringGetDatum() The code is replete with examples, cheers andrew -- Sent via pgsql-hackers mailing list (pg

Re: [HACKERS] Best way to construct Datum out of a string?

On 27.04.2011 17:06, Yves Weißig wrote: Hi, sadly, so far my search in the source code wasn't very successfull on this topic. So, how can I construct a Datum out of a string? What kind of a Datum do you want it to be? What data type? See CStringGetDatum, or perhaps CStringGetTextDatum(). Or p

[HACKERS] Best way to construct Datum out of a string?

Hi, sadly, so far my search in the source code wasn't very successfull on this topic. So, how can I construct a Datum out of a string? Greetz, Yves -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsq

Re: [HACKERS] new AM, catalog entries

Am 26.04.2011 17:07, schrieb Alvaro Herrera: > Excerpts from Yves Weißig's message of mar abr 26 11:32:31 -0300 2011: > >> I keep getting: ERROR: there is no built-in function named "ebibuild" >> This error message somehow leads me to fmgr.c where the contents of an >> array are inspected (in lin

Re: [HACKERS] operator classes for index?

Am 26.04.2011 17:37, schrieb Tom Lane: > =?ISO-8859-1?Q?Yves_Wei=DFig?= > writes: >> Am 26.04.2011 14:28, schrieb Robert Haas: >>> On Tue, Apr 26, 2011 at 5:18 AM, Yves Weißig >>> wrote: CREATE OPERATOR CLASS abstime_ops DEFAULT FOR TYPE abstime USING ebi FAMILY abstime_ops AS OPE

Re: [HACKERS] "stored procedures" - use cases?

On Tue, Apr 26, 2011 at 10:12 PM, Greg Stark wrote: > On Tue, Apr 26, 2011 at 11:55 PM, Josh Berkus wrote: >> Here's where I wanted autonomous transactions just last week, and didn't >> have them so I had to use a python script outside the database: >> >> -- doing a CREATE INDEX CONCURRENTLY for

Re: [HACKERS] Fail to search in array, produced by subquery - is it a bug?

On Tue, Apr 26, 2011 at 10:29 PM, Dmitry Fefelov wrote: > With Postgres 8.4 query like > > SELECT * >  FROM core.tag_links ctl >  WHERE (ctl.tag_id = ANY ( >      SELECT array_agg(ct.id) >        FROM core.tags ct >        WHERE (LOWER(ct.tag) LIKE LOWER(('search tag')::text || '%') ESCAPE >      

Re: [HACKERS] fixing INT64_FORMAT warnings on Mingw

On Wed, 2011-04-27 at 00:01 -0400, Andrew Dunstan wrote: > Both "%lld" and "%I64d" can be used with mingw to print 64 bit integers. > However, modern versions of gcc spit warnings with the former, and not > the latter. However, since "%lld" works, it is chosen by our config > setup since it come

Re: [HACKERS] unknown conversion %m

On 04/27/2011 12:50 AM, Tom Lane wrote: Andrew Dunstan writes: All or almost all the warnings seen on Windows/Mingw of the type "warning: unknown conversion type character 'm' in format" come from checking of three functions: errmsg, elog and errdetail. I therefore propose to disable the attr

Re: [HACKERS] maximum digits for NUMERIC

On Wed, Apr 27, 2011 at 4:47 AM, Bruce Momjian wrote: > Alvaro Herrera wrote: >> Excerpts from Bruce Momjian's message of mar abr 26 12:58:19 -0300 2011: >> >> > Wow, I am so glad someone documented this.  I often do factorial(4000) >> > which generates 12673 digits when teaching classes, and it b

Re: [HACKERS] alpha5

On 26.04.2011 17:36, Alvaro Herrera wrote: Excerpts from Alvaro Herrera's message of sáb abr 09 01:55:45 -0300 2011: Excerpts from Peter Eisentraut's message of lun mar 28 17:00:01 -0300 2011: On mån, 2011-03-28 at 09:35 -0400, Robert Haas wrote: Actually those are all my fault. Sorry, I'm st

Re: [HACKERS] Predicate locking

On 27.04.2011 12:24, Vlad Arkhipov wrote: 27.04.2011 17:45, Nicolas Barbier: 2011/4/27 Vlad Arkhipov: I'm currently need predicate locking in the project, so there are two ways to get it by now: implement it by creating special database records to lock with SELECT FOR UPDATE or wait while they

Re: [HACKERS] Predicate locking

27.04.2011 17:45, Nicolas Barbier: 2011/4/27 Vlad Arkhipov: I'm currently need predicate locking in the project, so there are two ways to get it by now: implement it by creating special database records to lock with SELECT FOR UPDATE or wait while they will be implemented in Postgres core.

  1   2   >