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 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 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
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, 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 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 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 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
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 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 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
>
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 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 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 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, 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-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-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 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 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 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 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, 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
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 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 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
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 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
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 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,
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 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 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
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 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
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
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 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
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 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 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 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 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 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 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 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 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-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 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-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 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
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
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
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
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
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 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 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 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 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
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 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
62 matches
Mail list logo
