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 kgri...@ymail.com wrote:
Tom Lane t...@sss.pgh.pa.us wrote:
However I've got to say that both of those side-effects of
exclusive-lock abandonment
On Mon, Oct 4, 2010 at 8:44 AM, Hakan Kocaman hko...@googlemail.com 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
On Thu, Apr 1, 2010 at 10:05 AM, David E. Wheeler da...@kineticode.com 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
Except that he posted a month ago and got no answers...
On Tue, Dec 1, 2009 at 8:22 AM, Robert Haas robertmh...@gmail.com wrote:
2009/11/30 rahimeh khodadadi rahimeh.khodad...@gmail.com:
-- Forwarded message --
From: rahimeh khodadadi rahimeh.khodad...@gmail.com
Date:
On Tue, Nov 24, 2009 at 11:34 AM, Tom Lane t...@sss.pgh.pa.us wrote:
Robert Haas robertmh...@gmail.com writes:
On Tue, Nov 24, 2009 at 12:28 PM, Tom Lane t...@sss.pgh.pa.us wrote:
But actually I thought we had more or less concluded that CREATE OR
REPLACE LANGUAGE would be acceptable (perhaps
On Sun, Nov 22, 2009 at 10:19 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Andrew Dunstan and...@dunslane.net 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
On Sun, Nov 22, 2009 at 10:41 PM, Craig Ringer
cr...@postnewspapers.com.au 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
On Mon, May 4, 2009 at 2:10 AM, Laurent Laborde kerdez...@gmail.com 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
On Tue, Jan 6, 2009 at 2:04 AM, Gurjeet Singh singh.gurj...@gmail.com 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
On Tue, Jan 6, 2009 at 2:24 AM, Gurjeet Singh singh.gurj...@gmail.com wrote:
On Tue, Jan 6, 2009 at 2:43 PM, Scott Marlowe scott.marl...@gmail.com
wrote:
On Tue, Jan 6, 2009 at 2:04 AM, Gurjeet Singh singh.gurj...@gmail.com
wrote:
I took your cue, and have formulated this solution for 8.3.1
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 be added?
Yeah,
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
and have RETURN QUERY be recognized by an ad-hoc strcmp test
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.
Hello Neil, I think
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.
Sure they can. We already do that for INSTALL
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 a temp table (which
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. It just seems wrong to have different signs in what
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 consistent.
Pretty much. It just seems wrong
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
thinks its charter is only to reduce day components that are = 30
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 now,
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
JOIN
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.
Huh? I
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 good.
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 will permit to
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 he
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
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
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, in
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
-Original Message-
From: Scott Marlowe [mailto:[EMAIL PROTECTED]
Sent
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?)
Most
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 of
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
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 call
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 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 the
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 options for
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 doesn't.
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 more problems we haven't foreseen yet, but I can't put my
finger
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 ROLLBACK
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 to know when
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 some idea early on of
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
transaction tree.
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't exist yet
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'd say pine
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 your points below.
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; Greg
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 systems that
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,
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 possible
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
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
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 is
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 mission statement?
If so, where could I find
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 doing it
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 source
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 admins?
I
61 matches
Mail list logo
