Does this behavior only affect the 9.2 branch? Or was it ported to 9.1 or
9.0 or 8.4 as well?
On Thu, Apr 11, 2013 at 7:48 PM, Kevin Grittner wrote:
> Tom Lane wrote:
>
> > However I've got to say that both of those side-effects of
> > exclusive-lock abandonment seem absolutely brain dead now
On Thu, Apr 1, 2010 at 10:05 AM, David E. Wheeler wrote:
> On Apr 1, 2010, at 3:01 AM, Magnus Hagander wrote:
>
>>> I prefer to dump all my data in a big text file and grep it for the
>>> information I need.
>>
>> As long as you implement your own grep, that sounds about on par with
>> the curren
On Mon, Oct 4, 2010 at 8:44 AM, Hakan Kocaman wrote:
> Hi,
> for whom it may concern:
> http://pdos.csail.mit.edu/mosbench/
> They tested with 8.3.9, i wonder what results 9.0 would give.
> Best regards and keep up the good work
They mention that these tests were run on the older 8xxx series
opte
On 8/29/07, Mario Gonzalez <[EMAIL PROTECTED]> wrote:
> On 29/08/2007, Neil Conway <[EMAIL PROTECTED]> wrote:
> >
> > I wonder if it would be possible to keep the master version of the
> > contrib docs as SGML, and generate plaintext READMEs from it during the
> > documentation build.
> >
>
> Hel
On 8/29/07, Alvaro Herrera <[EMAIL PROTECTED]> wrote:
> Scott Marlowe escribió:
>
> > Could the contrib README files couldn't be generated from the same
> > source as the docs (i.e. sgml) and then put into the appropriate
> > contrib/module/ directory.
>
&g
On Nov 9, 2007 5:14 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Todd A. Cook" <[EMAIL PROTECTED]> writes:
> > I saw the item in the release notes about the new "return query"
> > syntax in pl/pgsql, but I didn't see any note about "query" being
> > reserved now. Perhaps an explicit mention should b
On Nov 9, 2007 6:07 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
> > On Nov 9, 2007 5:14 PM, Tom Lane <[EMAIL PROTECTED]> wrote:
> >> [ thinks for a bit... ] It might be possible to get rid of the keyword
>
Except that he posted a month ago and got no answers...
On Tue, Dec 1, 2009 at 8:22 AM, Robert Haas wrote:
> 2009/11/30 rahimeh khodadadi :
>>
>>
>> -- Forwarded message --
>> From: rahimeh khodadadi
>> Date: 2009/11/29
>> Subject: Re: psql+krb5
>> To: Denis Feklushkin
>
> Pleas
On Tue, Jan 6, 2009 at 2:04 AM, Gurjeet Singh wrote:
> I took your cue, and have formulated this solution for 8.3.1 :
Is there a good reason you're running against a db version with known
bugs instead of 8.3.5? Seriously, it's an easy upgrade and running a
version missing over a year of updates
On Tue, Jan 6, 2009 at 2:24 AM, Gurjeet Singh wrote:
> On Tue, Jan 6, 2009 at 2:43 PM, Scott Marlowe
> wrote:
>>
>> On Tue, Jan 6, 2009 at 2:04 AM, Gurjeet Singh
>> wrote:
>> > I took your cue, and have formulated this solution for 8.3.1 :
>>
>> Is
On Sun, Nov 22, 2009 at 10:19 PM, Tom Lane wrote:
> Andrew Dunstan writes:
>> Part of the motivation for allowing inline blocks was to allow for
>> conditional logic.
>
> I don't think that argument really applies to this case, because the
> complaint was about not being sure if plpgsql is instal
On Sun, Nov 22, 2009 at 10:41 PM, Craig Ringer
wrote:
> Tom Lane wrote:
> It'd be a HUGE benefit in deployment and update scripts to have PL/PgSQL
> installed and available by default, at least to the superuser and to
> the DB owner.
Are there any known security problems with plpgsql?
--
Sent
On Tue, Nov 24, 2009 at 11:34 AM, Tom Lane wrote:
> Robert Haas writes:
>> On Tue, Nov 24, 2009 at 12:28 PM, Tom Lane wrote:
>>> But actually I thought we had more or less concluded that CREATE OR
>>> REPLACE LANGUAGE would be acceptable (perhaps only if it's given
>>> without any extra args?).
On Mon, May 4, 2009 at 2:10 AM, Laurent Laborde wrote:
> Friendly greetings !
> I found something "odd" (something that i can't explain) this weekend.
>
> An octocore server with 32GB of ram, running postgresql 8.3.6
> Running only postgresql, slony-I and pgbouncer.
>
> Just for testing purpose, i
s inside
a transaction should be mucking with the environment around them when
they're done.
But that's just my opinion, I could be wrong. Scott Marlowe
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On 2 May 2002, Jason Earl wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
>
> > On Wed, 1 May 2002, David Terrell wrote:
> >
> > > On Wed, May 01, 2002 at 02:24:30PM -0400, mlw wrote:
> > > > Just out of curiosity, does PostgreSQL have a mis
On Wed, 1 May 2002, David Terrell wrote:
> On Wed, May 01, 2002 at 02:24:30PM -0400, mlw wrote:
> > Just out of curiosity, does PostgreSQL have a mission statement?
> >
> > If so, where could I find it?
> >
> > If not, does anyone see a need?
>
> "Provide a really good database and have fun do
On 2 May 2002, Hannu Krosing wrote:
> The Politically Correct mission statement follows:
>
> The PostgreSQL community is committed to creating and maintaining a good
> but not the best, mostly reliable, open-source multi-purpose standards
> based database, and with it, promote free and open so
On Thu, 2 May 2002, Jim Mercer wrote:
> On Thu, May 02, 2002 at 08:41:30PM -0400, mlw wrote:
> > A mission statement is like a tie.
>
> straw vote!
>
> who on the list wears ties?
Does a skinny black tie count if I'm only wearing it to go out to a jazz
club? :-) Not at work though. I think
On Thu, 9 May 2002, Jan Wieck wrote:
> > If postgresql IS going to eventually be multi-threaded, then the whole
> > win32 port should probably be delayed until then, since it would solve
> > many of the issues of fork() versus createprocess().
>
> If multi-threading is the plan, then there i
On Mon, 10 Jun 2002, Dann Corbit wrote:
> If you are going to completely replace the data in a table, drop the
> table, create the table, and use the bulk copy interface.
Actually, that's a bad habit to get into. Views disappear, as do triggers
or constraints. Better to 'truncate table' or 'd
also, remember that for the cost of a single CPU oracle license you can
build a crankin' postgresql server... memory and I/O are way more
important than CPU power btw.
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMA
During the discussion of bools and hash index and partial indexes and
index growth and everything else, I tried to make a partial index on a
bool field and got the error that "data type bool has no default operator
for class hash..."
So, can I cast something to make this work, or is it possibl
I'd have to say that personally, given a choice between expending effort
to fix current know bugs and add known needed features, and expending
effort to port to Windows, I'd pick the former, not the latter.
I could personally care less if postgresql ever runs as a native window
application, si
On 3 Apr 2002, Hannu Krosing wrote:
> On Wed, 2002-04-03 at 06:52, Gavin Sherry wrote:
> > On Wed, 3 Apr 2002, Christopher Kings-Lynne wrote:
> >
> > > Hi,
> > >
> > > Would it be an idea to have pg_dump append an ANALYZE; command to the end of
> > > its dumps to assist newbies / inexperienced
On Tue, 2005-06-07 at 12:16, Jaime Casanova wrote:
> > SELECT encounter.encounter_id, encounter_d.encounter_d_id
> > FROM encounter
> > JOIN encounter_d on encounter_d.encounter_id = encounter.encounter_id
> > EXCEPT
> > SELECT encounter.encounter_id, encounter_d.encounter_d_id
> > FROM encounter
>
On Mon, 2005-06-06 at 14:52, Edward Peschko wrote:
> hey all,
>
>
> I'm trying to convince some people here to adopt either mysql or postgresql
> as a relational database here.. However, we can't start from a clean slate;
> we have a very mature oracle database that applications point to right n
On Wed, 2004-06-09 at 11:41, [EMAIL PROTECTED] wrote:
> > On Wed, Jun 09, 2004 at 10:49:20PM +0800, Christopher Kings-Lynne wrote:
> >> >I love PG, I've been using it since version 6x, and it has gotten
> >> >fantastic over the years, and in many cases, I would choose it over
> >> >Oracle, but for
On Fri, 2004-06-11 at 11:02, Bruce Momjian wrote:
> Gaetano Mendola wrote:
> [ PGP not available, raw data follows ]
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > Bruce Momjian wrote:
> >
> > | Gaetano Mendola wrote:
> > |
> > |>Bruce Momjian wrote:
> > |>
> > |> > I understand yo
On Fri, 2004-06-11 at 11:29, Dann Corbit wrote:
> > -Original Message-
> > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
> > Sent: Friday, June 11, 2004 9:39 AM
> > To: Tom Lane
> > Cc: Dann Corbit; Zeugswetter Andreas SB SD;
> > [EMAIL PROTECTED]; [EMAIL PROTECTED]; Bruce Momjian; Gr
On Fri, 2004-06-18 at 08:24, Chris Browne wrote:
> "Santo Quartarone" <[EMAIL PROTECTED]> writes:
> > What's the safest email browser?
>
> less is pretty safe, more or less ;-).
>
> You didn't specify what sort of platform you wanted to use; the
> choices vary, considerably, between platforms.
I
On Sun, 2004-06-20 at 17:15, Tatsuo Ishii wrote:
> > > Also I think we need to enhance ALTER INDEX to assign new table spaces
> > > for indexes. Assigning different tables spaces for tables and indexes
> > > are essential to gain more I/O speed IMO.
> >
> > I thought about this. ALTER INDEX doesn'
On Fri, 2004-06-25 at 14:13, Jaime Casanova wrote:
> Hi all,
>
> Can anyone tell me if postgresql has problems with xeon processors?
> If so, there is any fix or project of fix it?
To PostgreSQL, there's no difference between a dual CPU machine with no
hyperthreading, and a single CPU machine
On Thu, 2004-07-01 at 18:54, Gavin Sherry wrote:
> On Thu, 1 Jul 2004, Mike Rylander wrote:
>
> > On Thursday 01 July 2004 06:43 pm, Gavin Sherry wrote:
> > > Hi Mike,
> > >
> > > In this release, unfortunately not.
> >
> > That't too bad, but it's not that urgent I suppose.
> >
> > >
> > > I had
On Thu, 2004-07-01 at 22:14, Tom Lane wrote:
> Mike Benoit <[EMAIL PROTECTED]> writes:
> > On Thu, 2004-07-01 at 18:38 -0400, Alvaro Herrera wrote:
> >> If we change the syntax, say by using SUBCOMMIT/SUBABORT for
> >> subtransactions, then using a simple ABORT would abort the whole
> >> transactio
On Tue, 2004-07-06 at 10:25, Alvaro Herrera wrote:
> On Tue, Jul 06, 2004 at 08:15:14AM +0200, Dennis Bjorklund wrote:
> > On Mon, 5 Jul 2004, Alvaro Herrera wrote:
> >
> > > > begin/end because they are already in an explicit/implicit transaction
> > > > by default... How is the user/programmer
On Tue, 2004-07-06 at 23:36, Greg Stark wrote:
> "Scott Marlowe" <[EMAIL PROTECTED]> writes:
>
> > Why not rollback all or commit all?
> >
> > I really really don't like subbegin and subcommit. I get the feeling
> > they'll cause m
On Wed, 2004-07-07 at 00:16, Dennis Bjorklund wrote:
> On Tue, 6 Jul 2004, Alvaro Herrera wrote:
>
> > We can later implement savepoints, which will have "SAVEPOINT foo" and
> > "ROLLBACK TO foo" as interface. (Note that a subtransaction is slightly
> > different from a savepoint, so we can't use
On Sat, 2004-07-10 at 15:21, Josh Berkus wrote:
> Bruce,
>
> > They have no way of reporting a failed query back to the user? How do
> > people program in those environments? Right now any failed query aborts
> > the transaction so it seems it would be pretty easy.
>
> Believe it or not, PHP4 d
On Sun, 2004-07-11 at 16:01, Josh Berkus wrote:
> Scott,
>
> > Uh, I think it can:
> >
> > http://www.php.net/manual/en/function.pg-result-error.php
>
> Heh. I half-knew that if I pointed this out that someone would correct me
> with a link to new code. In my defense, I will point out that
On Sun, 2004-07-11 at 19:00, Bruce Momjian wrote:
> Andreas Joseph Krogh wrote:
> [ PGP not available, raw data follows ]
> > -BEGIN PGP SIGNED MESSAGE-
> > Hash: SHA1
> >
> > Hi, I've prepared a patch(against CVS HEAD of today) to pg_dump.c to
> > make pg_dump understand multiple -t optio
Bruce said the other day open transactions can't cause this problem.
I wonder what all can?
On Tue, 2004-07-20 at 16:32, Joshua D. Drake wrote:
> Hello,
>
> Perhaps you have an open transaction that isn't closing and thus the
> pg_xlog continues to grow?
>
> Sincerely,
>
> Joshua D. Drake
>
On Thu, 2004-07-22 at 16:21, David Fetter wrote:
> Kind people,
>
> I am writing a document patch for the tutorials section, and would
> like to change the section on inheritance to reflect the fact that it
> is not currently being developed, and has known serious bugs in
> implementation.
I'd ca
On Sun, 2004-07-25 at 22:23, Tom Lane wrote:
> I don't think
> it's either practical or interesting to try to introduce an equivalent
> layering into Postgres.
I can possibly see a use for a row locking storage system, i.e. non MVCC
for some applications. But I can't see it being worth the amount
Moving the -admin, please don't reply to -hackers on this.
On Fri, 2004-07-30 at 00:04, Coloring Graph wrote:
> I am has some trouble when connect to 7.5 devel PostgreSQL server,
> see belows
>
> my setup:
> ===
> os=Windows2000
> server version=the non-MSI snapshot at
> htt
On Mon, 2004-08-02 at 00:09, Adrian Maier wrote:
> Hello,
>
> On the production server I have PostgreSql 7.4.3 , on Mandrake Linux 9.2.
> In the message log on 29 july I have received several "shared buffer
> hash table
> corrupted" errors .
> What could cause this error ? (bad RAM maybe?)
M
On Mon, 2004-08-02 at 08:51, chinni wrote:
> Hi all!
> Some time back I discussed the inclusion of replication (e.g.
> postgres-R) into postgres.
> One of the technical reasons that I understand against such a move is
> the application dependence of replication. PostgresR requires a large
> amount
On Wed, 2004-08-04 at 16:11, Cason, Kenny wrote:
> Is there an easy way to select, say, the 15th row in a table? I can't
> use a sequence number because rows will sometimes be deleted resulting
> in the 15th row now being a different row. I need to be able to select
> the 15th row regardless of whe
On Wed, 2004-08-04 at 14:53, Hicham G. Elmongui wrote:
> Hi,
> If I want the planner/optimizer to always choose merge join when it needs to
> join relations. How can I do it ?
>From my past experience, I'd guess what you're really trying to do is
STOP the planner from choosing a nested_loop join,
didn't mean about doing this from a front end. I want to disable
> nested_loop and hash_join from the backend.
> I tried to set the variables (enable_nestloop and enable_hashjoin) in
> costsize.c, but this didn't do it.
> Thanks,
> --h
>
>
>
>
> -
On Sun, 2004-08-08 at 09:58, Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > The only open issue I see for beta1 is perhaps disabling vacuum delay.
>
> Given that Jan is clearly in the minority on that, I suggest we just
> turn it off for beta1. We can always turn it on later if
Since this is the first release supporting Windows natively, and
Windows people tend to not have any development environment by default,
should there be a windows binary version of some sort into the beta
directory, or is that something that will come along later with
setup.exe type packaging or so
On Mon, 2004-08-09 at 05:19, Gaetano Mendola wrote:
> Hi all,
> I have seen the big debat about to have the delay
> off or on by default.
>
> Why not enable it by default and introduce a new
> parameter to vacuum command itself ? Something like:
>
>
> VACUUM WITH DELAY 100;
>
>
> this wil
On Fri, 2006-02-17 at 10:51, Ron wrote:
> I assume we have such?
Depends on what you wanna do.
For transactional systems, look at some of the stuff OSDL has done.
For large geospatial type stuff, the government is a good source, like
www.usgs.gov or the fcc transmitter database.
There are other
On Wed, 2006-03-01 at 14:18, Bruce Momjian wrote:
> Stephan Szabo wrote:
> > > justify_days doesn't currently do anything with this result --- it
> > > thinks its charter is only to reduce day components that are >= 30 days.
> > > However, I think a good case could be made that it should normalize
On Wed, 2006-03-01 at 14:27, Bruce Momjian wrote:
> Scott Marlowe wrote:
> > On Wed, 2006-03-01 at 14:18, Bruce Momjian wrote:
> > > Stephan Szabo wrote:
> > > > > justify_days doesn't currently do anything with this result --- it
> > > > > thi
On Thu, 2006-03-02 at 00:45, Hannu Krosing wrote:
> Ühel kenal päeval, K, 2006-03-01 kell 14:36, kirjutas Scott Marlowe:
>
> > > But it isn't '-2 months, -1 day'. I think what you are saying is what I
> > > am saying, that we should make the signs consisten
On Wed, 2006-03-08 at 06:07, Markus Schaber wrote:
> Hi, Scott,
>
> Scott Marlowe wrote:
>
> >>But it isn't '-2 months, -1 day'. I think what you are saying is what I
> >>am saying, that we should make the signs consistent.
> > Pretty much.
On Thu, 2006-05-11 at 12:18, Jim C. Nasby wrote:
> On Wed, May 10, 2006 at 08:31:54PM -0400, Tom Lane wrote:
> > "Jim C. Nasby" <[EMAIL PROTECTED]> writes:
> > > On Tue, May 09, 2006 at 03:13:01PM -0400, Tom Lane wrote:
> > >> PFC <[EMAIL PROTECTED]> writes:
> > >>> Fun thing is, the rowcount from
On Wed, 2004-09-01 at 11:34, David Parker wrote:
> I am not currently working on z/OS, and don't have access to a z/OS
> environment, but I did a little work with getting OpenLDAP ported to
> z/OS at my previous company. I assume you mean Unix System Services
> (USS) under z/OS, rather than zLinux.
On Sun, 2004-10-03 at 06:33, stig erikson wrote:
> Hello.
> i have an slightly off topic question, but i hope that somebody might know.
>
> at the moment we have a database on a MS SQL 7 server.
> This data will be transfered to PostgreSQL 7.4.5 or PostgreSQL 8 (when
> it is released). so far so
On Mon, 2004-10-25 at 23:53, Tom Lane wrote:
> Greg Stark <[EMAIL PROTECTED]> writes:
> > Tom Lane <[EMAIL PROTECTED]> writes:
> >> Another issue is what we do with the effective_cache_size value once we
> >> have a number we trust. We can't readily change the size of the ARC
> >> lists on the fly
62 matches
Mail list logo
