Vacuum analyze keeps hanging here...
NOTICE: --Relation referer_log--
NOTICE: Pages 529: Changed 1, reaped 509, Empty 0, New 0; Tup 24306:
Vac 43000, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen 72, MaxLen 324;
Re-using: Free/Avail. Space 5205100/5193540; EndEmpty/Avail. Pages
0/508. CPU
Dear:
I wanna create a function that return a multiple rows in to a single
row.
example:
CREATE FUNCTION GETNAME() RETURNS SETOF VARCHAR AS 'SELECT NAME FROM
TEST;' LANGUAGE 'SQL';
when i call this function it return:
--
peter
susan
john
but I wonder is it possible to make it to
On Fri, 27 Apr 2001, Clayton Vernon wrote:
I was wondering what the plans were for PostgreSQL to convert to the
one process multithreaded approach, as Apache, Interbase and others
are doing?
there has been talk about doing some threads actions inside of a
process, but, if I recall my read of
Hello all:
I am part of a software development team evaluating RDBMSs for inclusion
as a base component of a messaging system. I've been thrashing hard
on PostgreSQL under Solaris 8 and the GNU compiler for a few days now,
and personally, I'm impressed. Thank you, developers.
The only two
I had this problem with 7.0.3, but it cleared up completely with 7.1
W
James Thornton wrote:
Vacuum analyze keeps hanging here...
NOTICE: --Relation referer_log--
NOTICE: Pages 529: Changed 1, reaped 509, Empty 0, New 0; Tup 24306:
Vac 43000, Keep/VTL 0/0, Crash 0, UnUsed 0, MinLen
Is any work being done to streamline/redesign the way
PostgreSQL handles updates and/or the way VACUUM works so that it doesn't lock
the entire table while it does it's job? It seems that tables that need to
be VACUUM'ed the most would typically have fewer acceptable "windows" in which
to
Over the past few months there've been a number of requests for an
interactive type documentation setup like the folks at php.net have.
Great to add to the documentation, but I hope the PostgreSQL project
doesn't take it so far as to make the primary documentation
interactive. A
* Jack Bates [EMAIL PROTECTED] [010428 13:31] wrote:
Hello all:
I am part of a software development team evaluating RDBMSs for inclusion
as a base component of a messaging system. I've been thrashing hard
on PostgreSQL under Solaris 8 and the GNU compiler for a few days now,
and
I am rather staggered by a developer considering it necessary to
attempt to cooerce the core development team into including a patch.
If the work that Alfred has done is as effective as he claims, then
there must be a *REALLY* good reason why it isn't being included.
I don't want to start any
quote who=J.H.M. Dassen (Ray)
will trillich [EMAIL PROTECTED] wrote:
Care to explain -- in terms a Debian newbie might grok -- what
contrib/pgcrypto means?
Peter is referring to a directory in the PostgreSQL sources, not to a part
of a binary package. apt-get source postgresql and look
Under 7.0.x and earlier, no.
Under 7.1, you can use execute to execute a string which
could have dynamic bits (replace create sequence seqname;
with execute ''create sequence '' || seqname;)
On Sat, 28 Apr 2001, Lieven Van Acker wrote:
Hi,
is there a way to make a name in a plpgsql
* [EMAIL PROTECTED] [EMAIL PROTECTED] [010428 21:44] wrote:
I am rather staggered by a developer considering it necessary to
attempt to cooerce the core development team into including a patch.
I'm assuming you refer to the updated page at:
http://people.freebsd.org/~alfred/vacfix/
If the
Hi Clayton,
From what I remember, using -p will change BOTH the TCP/IP port and the
Unix domain socket.
i.e. pg_ctl start -o '-i -p '
Should make PostgreSQL listen on TCP port , and on most unix systems
will create a socket file in /tmp/.s.PGSQL. (and its corresponding
lock
On Sun, Apr 29, 2001 at 04:33:42PM -0020, [EMAIL PROTECTED] wrote:
If the work that Alfred has done is as effective as he claims, then
there must be a *REALLY* good reason why it isn't being included.
Isn't 7.1 in a code freeze?
That seems like a *REALLY* good reason not to include such a
On Sun, Apr 29, 2001 at 03:04:18PM +1000, Jeff Waugh wrote:
quote who=J.H.M. Dassen (Ray)
will trillich [EMAIL PROTECTED] wrote:
Care to explain -- in terms a Debian newbie might grok -- what
contrib/pgcrypto means?
Peter is referring to a directory in the PostgreSQL sources, not
15 matches
Mail list logo