* Magnus Naeslund(f) <[EMAIL PROTECTED]> [010426 21:17] wrote:
> How does 7.1 work now with the vacuum and all?
>
> Does it go for indexes by default, even when i haven't run a vacuum at all?
> Does vacuum lock up postgres? It says the analyze part shouldn't, but how's
> that for all of the vacuu
> There's a report of startup recovery failure in Japan.
> Redo done but ...
> Unfortunately I have no time today.
Please ask to start up with wal_debug = 1...
Vadim
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unreg
How does 7.1 work now with the vacuum and all?
Does it go for indexes by default, even when i haven't run a vacuum at all?
Does vacuum lock up postgres? It says the analyze part shouldn't, but how's
that for all of the vacuum?
An 7.0.3 db we have here we are forced to run vacuum every hour to ge
Hi,
There's a report of startup recovery failure in Japan.
Redo done but ...
Unfortunately I have no time today.
regards,
Hiroshi Inoue
KAMI wrote:
>
>
> DEBUG: database system shutdown was interrupted at 2001-04-26 22:15:00 JST
> DEBUG: CheckPoint record at (1, 3923829232)
> DEBUG: Redo rec
On Thursday 26 April 2001 23:36, Barnes, Sandy (Sandra) wrote:
> > We are currently calling 'vacuum' from within our code, using the psql++
> > PgDatabase ExecCommandOk() to send the SQL statement 'vacuum'. I seems
> > to work when we only have one process running, but when two processes
> > (bot
> Is there any discussion before I submit the patch to -patches?
Since we can, or should be able to, run postgres as a backend to ldap,
this seems to give a wonderfully circular system (which probably works
just fine). Just a comment...
- Thomas
---
A couple {days,weeks} ago, someone sent an email to one of the pgsql-*
lists asking if anybody had thought about implementing the glue to use PAM
as authentication method for PostgreSQL. Having thought about being able
to easily drop in various external authentication agents, I've been
thinking a
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> When I create a table
> create table test (a bit(4));
> and insert a value
> insert into test values (b'11');
> the zpbit_in() function gets an atttypmod (arg 2 (of 2)) of -1. Is there
> somewhere the system needs to be told that "this type u
Marko Kreen <[EMAIL PROTECTED]> writes:
> A general question: what is the status on patch acceptance
> now, after 7.1 is successfully released? I did not
> want to fuzz around with new code when 7.1 was in freeze,
> but what is the status now?
We're still in bug-fixes-only mode. I think the pla
When I create a table
create table test (a bit(4));
and insert a value
insert into test values (b'11');
the zpbit_in() function gets an atttypmod (arg 2 (of 2)) of -1. Is there
somewhere the system needs to be told that "this type uses the atttypmod
field"?
--
Peter Eisentraut [EM
perhaps adding t.tgargs to your view enable me to extract parameters
that are the related fields
---
CREATE VIEW dev_ri
AS
SELECT * t.tgargs , t.oid as trigoid,
c.relname as trig_tbl,
On Thu, 26 Apr 2001, V. M. wrote:
(moving this conversation back to pgsql-general, followups to there)
> perhaps adding t.tgargs to your view enable me to extract parameters
> that are the related fields
At SCW, we use a naming convention for RI triggers, to allow
us to easily extract that, an
On Thu, Apr 26, 2001 at 05:20:53PM +0200, Peter Eisentraut wrote:
> will trillich writes:
> > i know "password" can be used in creating/altering user
> > information (as used via GRANT and REVOKE) but is there any
> > facility within postgres to CRYPT() a value?
>
> See contrib/pgcrypto for hashi
read it,
but i can determine only the related tables and not the fields of these
tables that are related.
valter
>From: Joel Burton <[EMAIL PROTECTED]>
>To: "V. M." <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: [HACKERS] Re: unanswered: Schema Issue
>Date: Thu, 26 Apr 2001 14:42:31 -0400
ok for serials, now i can extract from psql (\d tablename).
But i'm not able to extract foreign keys from the schema.
>From: Joel Burton <[EMAIL PROTECTED]>
>To: "V. M." <[EMAIL PROTECTED]>
>CC: [EMAIL PROTECTED]
>Subject: Re: unanswered: Schema Issue
>Date: Thu, 26 Apr 2001 13:51:26 -0400 (E
Ian Lance Taylor wrote:
> Jan Wieck <[EMAIL PROTECTED]> writes:
>
> > I don't object if we can be sure that it's implementing the
> > syntax a final version with *real* cursor support will have.
> > Can we?
>
> I don't know, and I don't know what the decision criteria are.
>
> I int
On Thu, 26 Apr 2001, V. M. wrote:
> ok for serials, now i can extract from psql (\d tablename).
>
> But i'm not able to extract foreign keys from the schema.
Yes you can. Read my tutorial on Referential Integrity in the top section
at techdocs.postgresql.org.
--
Joel Burton <[EMAIL PROTECT
Tom Lane wrote:
> Jan Wieck <[EMAIL PROTECTED]> writes:
> > What'd be easy is this:
>
> > - We already have two entry points for INSERT/UPDATE on FK
> > table, but the one for UPDATE is fortunately unused.
>
> > - We change analyze.c to install the RI_FKey_check_upd
>
Jan Wieck <[EMAIL PROTECTED]> writes:
> What'd be easy is this:
> - We already have two entry points for INSERT/UPDATE on FK
> table, but the one for UPDATE is fortunately unused.
> - We change analyze.c to install the RI_FKey_check_upd
> trigger if the cons
Tom Lane wrote:
>
> mlw <[EMAIL PROTECTED]> writes:
> > I am getting a bit concerned about Postgres 7.1 performance with
> > multiple connections. Postgres does not seem to scaling very
> > well. Below there is a list of outputs from pgbench with different
> > number of clients, you will see that
Jan Wieck <[EMAIL PROTECTED]> writes:
> I don't object if we can be sure that it's implementing the
> syntax a final version with *real* cursor support will have.
> Can we?
I don't know, and I don't know what the decision criteria are.
I intentionally implemented the Oracle curso
> We are currently calling 'vacuum' from within our code, using the psql++
> PgDatabase ExecCommandOk() to send the SQL statement 'vacuum'. I seems to
> work when we only have one process running, but when two processes (both
> invoking the vacuum) are running it immediately hangs. Some postgre
mlw <[EMAIL PROTECTED]> writes:
> I am getting a bit concerned about Postgres 7.1 performance with
> multiple connections. Postgres does not seem to scaling very
> well. Below there is a list of outputs from pgbench with different
> number of clients, you will see that postgres' performance in the
> > If someone wants to run the A4 docs through a PDF converter, send 'em to
> > me and I'll post them too.
> I just did the userA4 pdf from hub with this:
> $ gzcat userA4.ps.gz | ps2pdf - > userA4.pdf
> Do you want me to do the rest of them? Or we can probably have the
> makindex script do it
On Thu, 26 Apr 2001, Thomas Lockhart wrote:
> > > If someone wants to run the A4 docs through a PDF converter, send 'em to
> > > me and I'll post them too.
> > I just did the userA4 pdf from hub with this:
> > $ gzcat userA4.ps.gz | ps2pdf - > userA4.pdf
> > Do you want me to do the rest of them?
Jan Wieck wrote:
> Just discussed it with Tom Lane while he'd been here in
> Norfolk and it's even more ugly. We couldn't even pull out
> the FK's column defaults at this time to check if we are
> about to delete the corresponding PK because they might call
> all
I want to extract tables schema information, i've looked at
src/bin/psql/describe.c but i cannot determine the datatype
'serial' and
'references' from pg_*, i understand that triggers are generated for
serial
and references, so how i can understand from my perl application the
full
schema ?
tha
Please disregard this. This message was held by Majordomo for a couple
of days and I have already resent it.
Tom Lane has already solved my problem (I had a miscompiled version of
bison in my machine).
Regards to all,
Fernando
Fernando Nasser wrote:
>
> Is anyone else seeing this?
>
> I hav
On Tue, 24 Apr 2001, Thomas Lockhart wrote:
> If someone wants to run the A4 docs through a PDF converter, send 'em to
> me and I'll post them too.
I just did the userA4 pdf from hub with this:
$ gzcat userA4.ps.gz | ps2pdf - > userA4.pdf
Do you want me to do the rest of them? Or we can prob
Vince Vielhaber <[EMAIL PROTECTED]> writes:
> On Wed, 25 Apr 2001, The Hermit Hacker wrote:
>> On Wed, 25 Apr 2001, Vince Vielhaber wrote:
>>
> On Wed, 25 Apr 2001, Tom Lane wrote:
> Because it's tied to a GNU getloadavg.c implementation, which we'd have
> license problems with using.
>
> It's p
Tom Lane wrote:
> A less dangerous way of approaching it might be to have an option
> whereby the postmaster invokes 'uptime' via system() every so often
> (maybe once a minute?) and throttles on the basis of the results.
> The reaction time would be poorer, but security would be a whole lot
> be
The soft load shedding idea is great.
Along the lines of "lots of idle connections" is the issue with the simple
number of connections. I suspect in most real world apps you'll have
logic+web serving on a set of frontends talking to a single db backend
(until clustering is really nailed).
The is
Is anyone else seeing this?
I have the current CVS sources and "make check" ends up with one
failure. My regression.diffs shows:
*** ./expected/join.out Thu Dec 14 17:30:45 2000
--- ./results/join.out Mon Apr 23 20:23:15 2001
***
*** 1845,1851
-- UNION JOIN isn't implemente
Hi,
I think the pg_log file of my postgreSQL is corrupted.
I can;t access to tables in my database now.
The error message appear when I tried to list all tables is as below :
" cannot flush block 8 of pg_log to stable store "
Anybody know how can I restore back the pg_log file.
Thanks.
Emmanuel
>Nathan Myers wrote:
>> On Mon, Apr 23, 2001 at 03:09:53PM -0300, The Hermit Hacker wrote:
>> >
>> > Anyone thought of implementing this, similar to how sendmail does it?
If
>> > load > n, refuse connections?
>> > ...
>> > If nobody is working on something like this, does anyone but me feel
that
>
I am getting a bit concerned about Postgres 7.1 performance with multiple
connections. Postgres does not seem to scaling very well. Below there is a list
of outputs from pgbench with different number of clients, you will see that
postgres' performance in the benchmark drops with each new connectio
Folks:
I'm planning a port of Postgres to a multiprocessor
architecture in which all nodes have both local memory
and fast access to a shared memory. Shared memory it more
expensive than local memory.
My intent is to put the shmem & lock structures in
shared memory, but use a copy-
On Thu, 26 Apr 2001, The Hermit Hacker wrote:
> On Thu, 26 Apr 2001, Vince Vielhaber wrote:
>
> > On Wed, 25 Apr 2001, The Hermit Hacker wrote:
> >
> > > On Wed, 25 Apr 2001, Vince Vielhaber wrote:
> > >
> > > > On Wed, 25 Apr 2001, Tom Lane wrote:
> > > >
> > > > > The Hermit Hacker <[EMAIL PROT
On Thu, 26 Apr 2001, Vince Vielhaber wrote:
> On Wed, 25 Apr 2001, The Hermit Hacker wrote:
>
> > On Wed, 25 Apr 2001, Vince Vielhaber wrote:
> >
> > > On Wed, 25 Apr 2001, Tom Lane wrote:
> > >
> > > > The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > > > > Autoconf has a 'LOADAVG' check already
On Wed, 25 Apr 2001, The Hermit Hacker wrote:
> On Wed, 25 Apr 2001, Vince Vielhaber wrote:
>
> > On Wed, 25 Apr 2001, Tom Lane wrote:
> >
> > > The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > > > Autoconf has a 'LOADAVG' check already, so what is so problematic about
> > > > using that to enab
Dear friends,
PgAdmin provides new features for dropping/creating functions, triggers and
views and relinking the whole system without restarting PostgreSQL.
By now, this new feature is only available as a patch to PgAdmin
http://www.greatbridge.org/project/pgadmin/patch/patchlist.php.
If you
Jan Wieck <[EMAIL PROTECTED]> writes:
> IIRC the patch only provides the syntax for CURSOR to
> PL/pgSQL. Not real cursor support on the SPI level. So it's
> still the same as before, the backend will try to suck up the
> entire resultset into the SPI tuple table (that's
42 matches
Mail list logo
