On Tue, Apr 24, 2001 at 11:28:17PM -0300, The Hermit Hacker wrote:
> I have a Dual-866, 1gig of RAM and strip'd file systems ... this past
> week, I've hit many times where CPU usage is 100%, RAM is 500Meg free and
> disks are pretty much sitting idle ...
Assuming "strip'd" above means "striped",
At 11:28 PM 24-04-2001 -0300, The Hermit Hacker wrote:
>
>I have a Dual-866, 1gig of RAM and strip'd file systems ... this past
>week, I've hit many times where CPU usage is 100%, RAM is 500Meg free and
>disks are pretty much sitting idle ...
>
>It turns out, in this case, that vacuum was in order
At 12:04 25/04/01 +1000, Philip Warner wrote:
>
>it won't currently work if
>multiple dumps are being sent to stdout.
This latter could be fixed (at least for 'c' format) by modifying pg_dump
to use open/read/write/lseek instead of fopen/fread/fwrite/fseek etc.
-
On Wed, 25 Apr 2001, Lincoln Yeoh wrote:
> At 10:59 PM 23-04-2001 -0700, Nathan Myers wrote:
> >On Tue, Apr 24, 2001 at 12:39:29PM +0800, Lincoln Yeoh wrote:
> >> Why not be more deterministic about refusing connections and stick
> >> to reducing max clients? If not it seems like a case where you
At 10:00 25/04/01 +0900, Tatsuo Ishii wrote:
>Does anybody know:
>
>1) Is the tar/custom format of pg_dump is portable accross different
> platforms?
It's supposed to be; if it's not, it's a bug.
>2) if I want to dump out all of database cluster contents including
> large objects, is follow
At 10:59 PM 23-04-2001 -0700, Nathan Myers wrote:
>On Tue, Apr 24, 2001 at 12:39:29PM +0800, Lincoln Yeoh wrote:
>> Why not be more deterministic about refusing connections and stick
>> to reducing max clients? If not it seems like a case where you're
>> promised something but when you need it, yo
Does anybody know:
1) Is the tar/custom format of pg_dump is portable accross different
platforms?
2) if I want to dump out all of database cluster contents including
large objects, is following procedure correct?
(dump procedure)
pg_dumpall -g
pg_dump -F c for each database
Bruce Momjian wrote:
>
> I would like to know myself. I just did a recursive grep of the entire
> PostgreSQL tree and don't see it. My guess is that it is part of the
> RPM. Not sure who to report that to. I know Lamar Owen works on it,
> but I don't know if he is the contact.
Yes, that woul
I would like to know myself. I just did a recursive grep of the entire
PostgreSQL tree and don't see it. My guess is that it is part of the
RPM. Not sure who to report that to. I know Lamar Owen works on it,
but I don't know if he is the contact.
[ Charset ISO-8859-1 unsupported, converting.
who is it distributed by then? it was on the postgres ftp mirror sites, so
it probably can't be redhat. I have found workarounds, so its not a big
deal, but... Also, i wonder what else is different from this package from
the "real" source distribution. I am sorry if this has been discussed or
expl
Max Khon wrote:
> hi, there!
>
> On Mon, 23 Apr 2001, Jan Wieck wrote:
>
> > I just got trapped by one of my own features in the
> > referential integrity area.
> >
> > The problem is, that the trigger run on the FK row at UPDATE
> > allways checks and locks the refer
Doug McNaught writes:
> A very valid objection. I'm also dubious as to the utility of the
> whole concept. What happens when Sendmail refuses a message based on
> load? It is requeued on the sending end to be tried later. What
> happens when PG refuses a new client connection based on load?
Doug McNaught wrote:
> A very valid objection. I'm also dubious as to the utility of the
> whole concept. What happens when Sendmail refuses a message based on
> load? It is requeued on the sending end to be tried later. What
> happens when PG refuses a new client connection based on load? Th
Apparently so under Solaris ...
hestia:/> uname -a
SunOS hestia 5.7 Generic_106542-12 i86pc i386 i86pc
C Library Functionsgetloadavg(3C)
NAME
getloadavg - get system load averages
SYNOPSIS
#include
int getloadavg(double loadavg[], int nelem);
> SELECT card_info.main_cat, category_details.sub_cat_flag,count(*)
> FROM send0,card_info,category_details
> WHERE send0.card_id=card_info.card_id
>AND category_details.mcategory='e-cards'
>AND card_info.main_cat=category_details.category
>AND send_date >= '2001/04/08'
>AND sen
Tom Lane writes:
> The Hermit Hacker <[EMAIL PROTECTED]> writes:
> > sendmail does it now, and, apparently relatively portable across OSs ...
>
> sendmail expects to be root. It's unlikely (and very undesirable) that
> postgres will be installed with adequate privileges to read /dev/kmem,
> whic
You will find that that script is not distributed by us.
[ Charset ISO-8859-1 unsupported, converting... ]
>
> Hi,
>
> I believe i found two minor bugs in the linux start/stop scripts for the
> downloadable rpm version of postgres 7.1. I don't think these have been
> reported already (i did som
Tom:
Notice that WriteBuffer would just put the fresh copy of the page
out in the shared space.
Other backends would get the latest copy of the page when
THEY execute BufferAlloc() afterwards. [Remember, backends would
not have a local buffer cache, only (temporary) copies of one buffer
pe
hi, there!
On Mon, 23 Apr 2001, Jan Wieck wrote:
> I just got trapped by one of my own features in the
> referential integrity area.
>
> The problem is, that the trigger run on the FK row at UPDATE
> allways checks and locks the referenced PK, even if the FK
>
Got a query that looks like:
SELECT card_info.main_cat, category_details.sub_cat_flag,count(*)
FROM send0,card_info,category_details
WHERE send0.card_id=card_info.card_id
AND category_details.mcategory='e-cards'
A
Bruce Momjian wrote:
>
> Postgresql Programmer's Guide
> by Thomas Lockhart, Thomas Lochart (Editor)
>
>
>http://www.amazon.com/exec/obidos/ASIN/0595149170/ref=pd_sim_elt_l1/107-6921356-0996510
Oh! Have you changed the PostgreSQL logo to an unplugged old macintosh
mouse ?
-
21 matches
Mail list logo
