ng) its limits,
> >I've been most happy with it ...
> >
> >
> >
> >Marc G. Fournier Hub.Org Networking Services (http://www.hub.org)
> >Email: [EMAIL PROTECTED] Yahoo!: yscrappy ICQ: 7615664
> >
> >
>
>
>
>
On Mon, Jun 04, 2001 at 02:16:35PM -0400, Tom Lane wrote:
> I wrote:
> > Jim Mercer <[EMAIL PROTECTED]> writes:
> >> where are these relations? is this a compile-time thing, or can it be done
> >> on-the-fly?
>
> > Compile-time; see SharedSystemRelatio
27.0.0.1 255.255.255.255 password pg_shadow
where "pg_shadow" is a special key (like "ident sameuser") to set up this
behaviour.
the patch is done in such a way that it will not impact existing installations
--
[ Jim Mercer [EMAIL PROTECTED] ]
[ Reptilian
and anyone post some of their experiences with using the new replication
stuff in production?
--
[ Jim Mercer [EMAIL PROTECTED] ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ aka[EMAIL PROTECTED] +1 416 410-5633 ]
27;secret', 'salt');
or
> SELECT makecrypt('secret');
such that if salt is not specified, the c function would make one up.
--
[ Jim Mercer [EMAIL PROTECTED] ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ aka[EMAIL PROTECTED] +1 416 410-5633 ]
t;.
in "samples", i have various tables which have been configured using
"GRANT/REVOKE" to allow/disallow various activities by users.
however, any user can create new tables.
how do i stop/restrict who can add tables (and/or indexes) ?
--
[ Jim Mercer [
oh, forgot to mention that some of my indexes take 2+ hours to rebuild
from scratch.
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 410-5633 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
y got 25+ gig of tables, two of which are 10+ gig each.
8^(
it certainly would be nice to have a quicker process than dump/reload.
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 410-5633 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
NIX stream port
>
> I have rebooted the machine since then and there is no file in /tmp
> directory to be removed. I am absolutly positive that another postmaster is
> not running and that file does not exist.
>
>
> Any suggestions would be appreciated.
>
you might find a library of either tar or cpio read functions as
part of the FreeBSD sysinstall utility.
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 410-5633 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
On Fri, Jun 23, 2000 at 12:00:31PM -0400, Tom Lane wrote:
> Jim Mercer <[EMAIL PROTECTED]> writes:
> > it appears that each call to UPDATE seems to be taking a long, long time to
> > complete.
>
> Poor choice of plan, maybe? What does EXPLAIN say about how a typical
&
to some component overheating?
> Sorry for my english
your english is fine.
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
s no processing happening).
has anybody had similar issues? solutions? suggestions?
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
if i have a table:
CREATE TABLE booga
(
name varchar(20),
addr varchar(20)
);
CREATE UNIQUE INDEX booga_idx ON booga (name);
is there a fast way to find the last entry in index booga_idx?
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654
ehave that
> way, it is a bug.
is this just in pgsql, or in SQL in general?
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
lling of analyse with a
> 'z' not an 's'.
>
> Hope you have a very nice day, :-)
[ picture of jim slapping himself in the forehead ]
geez.
i know it was right in front of me, but, g.
[ in his best homer simpson voice ] Doh!
--
[ Jim Mercer [EM
/Avail. Pages 0/0. Elapsed 0/0 sec.
NOTICE: Index switch_name: Pages 2; Tuples 9. Elapsed 0/0 sec.
VACUUM
what is the correct syntax for doing a vacuum analyse?
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ]
[ Reptilian Research -- Longer Life through Col
p a pg_options file,
i've noticed that verbose level 2 will put the output of vacuum into
the syslog file.
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ]
[ Reptilian Research -- Longer Life through Colder Blood ]
[ Don't be fooled by cheap Finnish imitations; BSD is the One True Code. ]
i'm getting the following error on one of my tables:
error: SQL: FETCH FORWARD 500 IN cur_NON_110916;
error: database (7) ERROR: cannot read block 122600 of gt
there are no messages from the OS about disk read failures.
this is postgres-6.5.2 on FreeBSD-3.3-STABLE
--
[ Jim M
allid_key grow to in excess of 50% the size
of the main table.
any ideas?
this is postgres-6.5.2 (patched from 6.5.1) on intel hardware under FreeBSD.
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ]
[ Reptilian Research -- Longer Life through Colder Blood
> I got the above error [see subject] when I attempted to "initdb".
>
> What's wrong and how do I fix it ?
what operating system?
--
[ Jim Mercer [EMAIL PROTECTED] +1 416 506-0654 ]
[ Reptilian Research -- Longer L
DECLARE mycurs CURSOR FOR
SELECT mark::int8, subnet, bytes_in, bytes_out
FROM samples
WHERE mark >= 'epoch or another date'::abstime;
it works fine as well.
--
[ Jim MercerReptilian Research [EMAIL PROTECTED] +1 416 410-5633 ]
[ The telephone, for tho
m selecting a huge number of records,
and defining some conversion or something in the selected fields.
if i revert my code to (note: less the DATE_PART conversion):
DECLARE mycurs CURSOR FOR
SELECT mark, subnet, bytes_in, bytes_out
FROM samples
WHERE mark >= 'epoch or another date
(i was gonna cut and paste part of a top session here, but the vacuum just
blew out the 750M swap partition on the server, and now i need to reboot it).
why does this vacuum require so much core memory?
--
[ Jim MercerReptilian Research [EMAIL PROTECTED] +1 416 410-5633 ]
[ The telepho
imilar problem with 6.5beta, only i was using index fields of
int8, float8, datestamp and abstime.
be nice to know what the issue is.
jim (wandering off to look up "CLUSTERED")
--
[ Jim MercerReptilian Research [EMAIL PROTECTED] +1 416 410-5633 ]
[ The telephone, for those of
i have a number of processes which deal with the same table.
i've run into locking contention.
is there a way for me to tell if there are connections waiting on a share
or exclusive lock?
i'm using libpq and C.
--
[ Jim MercerReptilian Research [EMAIL PROTECTED] +1 41
wer supply parameters using SQL and would be a powerful ( no pun ) tool for
> doing all sorts of things in response to alarms etc ( including sending email
> ).
>
> Thanks again.
looks like an application for triggers.
--
[ Jim MercerReptilian Research [EMAIL PROTECTED]
p.tar.gz
this is the dbf2sql-2.0 stuff, plus the source for my program (mydb).
the makefile is minimally modified to my tastes.
--
[ Jim MercerReptilian Research [EMAIL PROTECTED] +1 416 410-5633 ]
[ The telephone, for those of you who have forgotten, was a commonly used ]
[ communicat
i make such changes to the source, will it break other people's code if
the changes get added to the core source (6.4.3 or 6.5)?
--
[ Jim MercerReptilian Research [EMAIL PROTECTED] +1 416 410-5633 ]
[ The telephone, for those of you who have forgotten, was a commonly used ]
[ communicat
of records
> saved setMaxSize(); but this does not seem to decrease the time of
> execution of executeQuery(), and probably only uses less local memory.
have a look at using cursors.
worked for me.
--
[ Jim MercerReptilian Research [EMAIL PROTECTED] +1 416 410-5633 ]
[ The te
> At 16:10 +0200 on 17/2/99, Jim Mercer wrote:
> You probably didn't understand me. If you convert it to tab delimited text
> and then use COPY table_name FROM filename/stdin instead of INSERT, it will
> be much faster, because you don't have to do the parsing and planni
> How about -o -F ?
the startup script is:
[ -x /usr/local/pgsql/bin/postmaster ] && {
su -l pgsql -c 'exec /usr/local/pgsql/bin/postmaster -i -S -o -F -d 3 \
-D/usr/local/pgsql/data' >> /usr/local/pgsql/errlog 2>&1
echo -n ' p
CT ... FROM temp_table; -- update within select
>CREATE INDEX...;
as stated above, the size of the table means i can't do this on every update.
> 3) Back to the issue of INSERTS - copies are faster. If you can transform
>the data into tab-delimited format as required by COPY, yo
33 matches
Mail list logo