To: ISMTP@SFRA0046@Servers[<pgsql-general-digest@hub.org>]
Cc:
Subject: pgsql-general-digest V1 #381
Message not delivered to recipients below. Press F1 for help with VNM
error codes.
VNM3043: DE_VOLDER Fabrice@ATR_EXPL_LYON1@SFR_DO_CNTR_EST
VNM3043 -- MAILBOX IS FULL
The message cannot be delivered because the
recipient's mailbox contains the maximum number of
messages, as set by the system administrator. The
recipient must delete some messages before any
other messages can be delivered.
The maximum message limit for a user's mailbox is
10,000. The default message limit is 1000 messages.
Administrators can set message limits using the
Mailbox Settings function available in the
Manage User menu (MUSER).
When a user's mailbox reaches the limit, the
user must delete some of the messages before
the mailbox can accept any more incoming messages.
---------------------- Original Message Follows ----------------------
pgsql-general-digest Thursday, July 8 1999 Volume 01 : Number 381
Index:
Re: [HACKERS] RE: [GENERAL] Transaction logging
unsubscribe
Does Apache has PostgreSQL module?
Re: [GENERAL] Does Apache has PostgreSQL module?
User priveledges
just little BUG
marino.lionello@bluewin.ch
Re: [GENERAL] Problems with inequalities on numeric fields in 6.5
[none]
----------------------------------------------------------------------
Date: Wed, 7 Jul 1999 23:25:24 -0400 (EDT)
From: Bruce Momjian <maillist@candle.pha.pa.us>
Subject: Re: [HACKERS] RE: [GENERAL] Transaction logging
Updated TODO:
* Transaction log, so re-do log can be on a separate disk by
with after-row images
> > Added to TODO:
> >
> > * Transaction log, so re-do log can be on a separate disk by
> > logging SQL queries, or before/after row images
> >
> I would drop the "log SQL queries idea".
> No need to log before row images eighter, since this is the
> current state of the row during rollforward.
> (For asserts a checksum of the before image would be sufficient,
> but IMHO not necessary.)
>
> I suggest:
> * Transaction log that stores after row (or even only column)
> images,
> which can be put on a separate disk to allow rollforward after
> a restore of a server.
>
> The "restore of a server" is a main problem here, but I suggest the
> following
> additional backup tool, that could be used for a "restore of a server"
> which could then be used for a rollforward and would also be a lot faster
> than a pg_dump:
>
> 1. place a vacuum lock on db (we don't want vacuum during backup)
> 2. backup pg_log using direct file access (something like dd bs2k)
> 3. backup the rest in any order (same as pg_log)
> 4. release vacuum lock
>
> If this was restored, this should lead to a consistent database,
> that has all transactions after the start of backup rolled back.
>
> Is there a nono in this idea? I feel it should work.
> A problem is probably, that the first to touch a row with a committed update
> stores this info in that row. There would probably need to be an undo for
> this
> after restore of the physical files.
>
> Andreas
>
>
>
- --
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
------------------------------
Date: Thu, 08 Jul 1999 07:49:59 +0200
From: Leszek Rychlewski <leszek@bioinfobank.com>
Subject: unsubscribe
unsubscribe
------------------------------
Date: Thu, 08 Jul 1999 01:18:44 PDT
From: Albert Chen <chen6178@hotmail.com>
Subject: Does Apache has PostgreSQL module?
Hi,
I know there is a ApacheMysql module. Has ApachePostgres module?
- -Albert
______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com
------------------------------
Date: Thu, 8 Jul 1999 13:07:12 +0400 (MSD)
From: Oleg Broytmann <phd@emerald.netskate.ru>
Subject: Re: [GENERAL] Does Apache has PostgreSQL module?
On Thu, 8 Jul 1999, Albert Chen wrote:
> I know there is a ApacheMysql module. Has ApachePostgres module?
Do you mean postgres authentication module? It is called mod_auth_pgsql,
and you can hunt for this on http://modules.apache.org. Works pretty fine
for me.
> -Albert
Oleg.
- ----
Oleg Broytmann http://members.xoom.com/phd2/ phd2@earthling.net
Programmers don't die, they just GOSUB without RETURN.
------------------------------
Date: Thu, 08 Jul 1999 09:21:12 -0500
From: Bob Kruger <bkruger@mindspring.com>
Subject: User priveledges
I have what may be a fairly simple question for the group, but for the life
of me I missed it in the documentation.
In writing some perl cgi scripts for postgres, I found that I would get an
error message if a user without certain priveledges tried to do a select,
insert, delete or whatever.
What I would like to do is a quick scan prior to executing a perl script
that would look at the user and see if they have the priveledge for the
action they are about to attempt. An example would be that prior to a
screen coming up that handles deletions, a query is made to see if the user
even has this priveledge and the result is somehow captured so that they
can either go on to a subroutine generating a HTML screen for deletion or a
subroutine informing them they do not have the correct priveledge status,
etc....
Any hints?
Regards - Bob Kruger
------------------------------
Date: Thu, 8 Jul 1999 17:16:10 +0200
From: "Jonathan davis" <haj@idianet.net>
Subject: just little BUG
hello all
normaly a UNIQUE PRIMARY KEY is unique but
when you use a heritage, you can insert a duplicate key !!!!
------------------------------
Date: Thu, 08 Jul 1999 17:25:13 +0200
From: Marino Lionello <marino.lionello@bluewin.ch>
Subject: marino.lionello@bluewin.ch
unsubscribe
------------------------------
Date: Thu, 08 Jul 1999 11:44:32 -0300
From: Martin Weinberg <weinberg@osprey.phast.umass.edu>
Subject: Re: [GENERAL] Problems with inequalities on numeric fields in 6.5
Bruce Momjian wrote on Wed, 07 Jul 1999 12:29:13 EDT
>> Thanks, Bruce!
>>
>> Yes, I tried the latter query and it's the same:
>>
>> --------------------------------------------------
>>
>> lmc>:float4;
>> NOTICE: QUERY PLAN:
>>
>> Aggregate (costb349.97 rowsx8100 width
>> -> Index Scan using j on lmctot (costb349.97 rowsx8100 width
>>
>> EXPLAIN
>>
>> --------------------------------------------------
>> I've tried all permutations of the conversions in the ranges with
>> similar results (and vacuum analyzed several times as well as
>> dumped and reloaded and reloaded from scracth). We have
>> a larger database with 20M rows which has a similar behavior.
>>
>> There are 7092894 rows in database "lmc". So:
>>
>> (3.5-3.4)/(99.999-2.731) >>
>> A clue?
>
>I have just fixed a problem with index size estimates. Try adding
>#include <math.h> to the top of backend/optimizer/util/plancat.c. That
>may fix the estimated number of tuples returned. However, it don't
>think you are going to get better performance, since you are already
>using the index in the above case. The only big win I can think of is
>to use CLUSTER on that field. That should speed things up quite a bit.
>
Hi Bruce,
Ok. Sorry about the delay.
I added the math.h but that doesn't seem to change the
query plan output.
I then dropped all the indices, made a new one on three of the
variables and clustered:
create index m_col on lmctot using btree (j_m, h_m, k_m);
cluster m_col on lmctot;
vacuum analyze;
where the j_m, h_m, k_m are three float4 fields.
The cluster took about 18 hours on my 7.1 million records
(this is a dual 450Mhz Xeon Linux box). Not sure why
this was so slow.
Anyway, this *hugely* improved queries of form:
select count(*) from lmctot where j_m>3.4::float4 and j_m<3.5:
although the explain query plan output is identical. However
using h_m or k_m (not the first variable in the index) appears
to be doing a sequential scan. Is that right?
I then made indices on h_m and k_m, vacuum analyzed and tried
again, but got identical performance. If this is the way
it is, so be it, but I have the feeling that something is
not working properly.
Any ideas?
Again, with _heaps_ of thanks,
- --Martin
Martin Weinberg Phone: (413) 545-3821
Dept. of Physics and Astronomy FAX: (413) 545-2117/0648
530 Graduate Research Tower
University of Massachusetts
Amherst, MA 01003-4525
------------------------------
Date: Thu, 8 Jul 1999 16:13:54 -0500 (COT)
From: "Moises Rincon D'Hoyos" <moi-rinc@demy.uniandes.edu.co>
Subject: [none]
subscribe
end
------------------------------
End of pgsql-general-digest V1 #381
***********************************
