Well, it usually takes atleast 15-20 minutes to get results back on a
database that has many alerts in it. The system itself is dual pentium
4 1 GHZ with 1 GByte of RAM. I have been talking to a few people and
they mentioned trying to update the memory space for which postgres uses
by tweaking fr
Robert Treat wrote:
> is there some way to determine the query that creates the file
> pgsql_tmp15041.0? i thought maybe 15041 was the procpid but apparently
> not... anyone know?
It is the proc id. Perhaps the backend crashed. If so, a postmaster
restart clears those sort directories.
--
B
And all along I thought "v" stood for "victory" we launched 7.4! Seriously huge
effort, great product, cheers! Another great milestone.
Cheers to the veam, I mean team.
-Original Message-
From: Peter Eisentraut [mailto:[EMAIL PROTECTED]
Sent: Mon 11/
On Tue, 18 Nov 2003, Peter Eisentraut wrote:
> Joshua D. Drake writes:
>
> > Somebody please explain to me what the hell a difference it makes if
> > we have a v in front of the version number?
>
> Packaging tools, packaging standards, convention, consistency of public
> presentation.
Packaging h
On Tue, 2003-11-18 at 01:55, Joshua D. Drake wrote:
> Somebody please explain to me what the hell a difference it makes if
> we have a v in front of the version number?
It isn't standard practice. I agree with Peter on this.
Also, as I have asked before, please make sure that future releases sor
On Mon, 17 Nov 2003, Joshua D. Drake wrote:
> Here it's just the release announcements that make us look like some kind
>
> >of weirdos. But when you're making tarballs like erserver_v1.2.tar.gz
> >then you're not only making a fool of yourself, you're creating actual
> >technical problems. I ta
Joshua D. Drake wrote:
> Here it's just the release announcements that make us look like some kind
>
> >of weirdos. But when you're making tarballs like erserver_v1.2.tar.gz
> >then you're not only making a fool of yourself, you're creating actual
> >technical problems. I take offense at it beca
Joshua D. Drake writes:
> Somebody please explain to me what the hell a difference it makes if
> we have a v in front of the version number?
Packaging tools, packaging standards, convention, consistency of public
presentation.
--
Peter Eisentraut [EMAIL PROTECTED]
--
Here it's just the release announcements that make us look like some kind
of weirdos. But when you're making tarballs like erserver_v1.2.tar.gz
then you're not only making a fool of yourself, you're creating actual
technical problems. I take offense at it because for years you've simply
ignored
I would appreciate it if you could abandon that habit and stop making us
look like losers.
Odd that you are the only one that *ever* seems to take offence at it ...
*shrug*
I don't even understand why we are declaring a difference. Is it not v7.4?
---(end of bro
Marc G. Fournier writes:
> Odd that you are the only one that *ever* seems to take offence at it ...
> *shrug*
Here it's just the release announcements that make us look like some kind
of weirdos. But when you're making tarballs like erserver_v1.2.tar.gz
then you're not only making a fool of you
Not really, and still don't care either way.
Postgres *is* a superior product, I have used many different DB's, and will
continue to stick by Postgres. And THAT is what makes Postgres stand out
from the rest: let's get over it.
Terry Fielder
Manager Software Development and Deployment
Great Gulf
[EMAIL PROTECTED] wrote:
Interesting, I see the difference between "PostgreSQL v7.4 Released" and
"PostgreSQL 7.4 Released".
But I didn't perceive a "loser" until the Postgres team started squabbling
amongst themselves on a public forum about it.
No losers here :-)
Great job guys !
.Sig - Sp
On Tue, 18 Nov 2003, Peter Eisentraut wrote:
> Marc G. Fournier writes:
>
> > > And when will the coordinator learn that it is called "PostgreSQL 7.4" and
> > > not "PostgreSQL v7.4"?
> >
> > Habit :)
>
> I would appreciate it if you could abandon that habit and stop making us
> look like losers.
On Mon, 17 Nov 2003 [EMAIL PROTECTED] wrote:
> Interesting, I see the difference between "PostgreSQL v7.4 Released" and
> "PostgreSQL 7.4 Released".
And, until Peter pointed it out to you, did you notice the difference?
---(end of broadcast)---
T
Eclipse also has a nice c++ plugin.
Richard Welty wrote:
On Mon, 17 Nov 2003 23:48:46 + (GMT) jini us <[EMAIL PROTECTED]> wrote:
Java has long way to catch up with C++
in my opinion.
perhaps. this is neither the time nor the place for that discussion.
however, in answer to the actual
On Mon, 17 Nov 2003 23:48:46 + (GMT) jini us <[EMAIL PROTECTED]> wrote:
> Java has long way to catch up with C++
> in my opinion.
perhaps. this is neither the time nor the place for that discussion.
however, in answer to the actual discussion in this thread,
netbeans (not javabeans) is a nice
On Mon, 2003-11-17 at 15:35, Peter Eisentraut wrote:
I would appreciate it if you could abandon that habit and stop making us
look like losers.
Losers? PostgreSQL is way too good for it to be the product of losers. My Oracle-bound comrades have drooled over things like table inheritance and
Although java is quite strong when building
distributed applications,web application, small
devices.
Anyway Java is owned by sun microsystems and it is
their attempt to catch up with microsoft.
That doesn't benefit me any way... waiting for sun
microsystems and their partners (majority based in
i
Kathy Zhu wrote:
I know we have LIMIT to limit the number of rows returned, I wonder if there is
a way to indicate an offset.
Select * from Test offset 10, limit 4;
As per the PostgreSQL documentation, specifically the page on the
"SELECT" SQL command:
LIMIT Clause
LIMIT { count | ALL }
Interesting, I see the difference between "PostgreSQL v7.4 Released" and
"PostgreSQL 7.4 Released".
But I didn't perceive a "loser" until the Postgres team started squabbling
amongst themselves on a public forum about it.
Terry Fielder
Manager Software Development and Deployment
Great Gulf Homes
Java has long way to catch up with C++
in my opinion.
--- "scott.marlowe" <[EMAIL PROTECTED]> wrote: >
Yep, it's far more common to find free software for
> linux/unix than for
> windows, where commercial software tends to rule the
> roost.
>
> If you don't mind developing in Java, look at
> j
We have a running server (v7.3) which, over time, seems to accumulate a
bunch of "stuck" PostgreSQL instances which appear to be dead inside of
a transaction. For example, "ps" reveals many of these:
postgres 17683 0.0 0.4 7376 1032 ?SNov13 0:21 postgres:
bryan sourceid 127.0.0.1
Marc G. Fournier writes:
> > And when will the coordinator learn that it is called "PostgreSQL 7.4" and
> > not "PostgreSQL v7.4"?
>
> Habit :)
I would appreciate it if you could abandon that habit and stop making us
look like losers.
--
Peter Eisentraut [EMAIL PROTECTED]
--
Hi all,
I know we have LIMIT to limit the number of rows returned, I wonder if there is
a way to indicate an offset.
e.g.
Select * from Test offset 10, limit 4;
retrieve all Test, return 4 rows from the 10th row
thanks,
kathy
---(end of broadcast)--
is there some way to determine the query that creates the file
pgsql_tmp15041.0? i thought maybe 15041 was the procpid but apparently
not... anyone know?
Robert Treat
--
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL
---(end of broadcast)
Thank you Ben, that worked.
- Original Message -
From: "Ben" <[EMAIL PROTECTED]>
To: "Julie May" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>
Sent: Monday, November 17, 2003 3:17 PM
Subject: Re: [GENERAL] arrays as parameters to pl/pgsql functions
> On Mon, 17 Nov 2003, Julie May wrote:
On Mon, 17 Nov 2003, Peter Eisentraut wrote:
> Marc G. Fournier writes:
>
> > After almost 12 months of intense development, and testing, we are proud
> > to announce the availability of PostgreSQL v7.4.
>
> And when will the coordinator learn that it is called "PostgreSQL 7.4" and
> not "Postgr
SuSE RPMs for PostgreSQL 7.4 are available at
ftp://ftp.postgresql.org/pub/binary/v7.4/suse
or a mirror
http://www.postgresql.org/mirrors-www.html
or at
ftp://ftp.suse.com/pub/people/max/postgresql-7.4
or a mirror
http://www.suse.com/us/private/download/ftp/in
On Mon, 17 Nov 2003, Julie May wrote:
> Is it possible to use an array as a parameter to a pl/pgsql function. I am
> running version 7.3 and don't have the time right now to upgrade.If it is
> possible, how do you iterate through the array? For example:
CREATE or REPLACE FUNCTION foo(integer[])
After almost 12 months of intense development, and testing, we are proud
to announce the availability of PostgreSQL v7.4.
An overview of the major changes in v7.4 include:
IN/NOT IN subqueries are now much more efficient
Improved GROUP BY processing by using hash buckets
New multikey ha
G'day all ...
There is polling going on over at LinuxQuestions.Org for "Members
Choice Awards", with, of course, there being a category for Database of
the Year ...
Right now, as of this writing, we are in second place, with 36 votes vs
110 votes for MySQL ...
It is a registered thing,
32 matches
Mail list logo
