7;ll update the vacfix page to explain better.
I also need to update it to explain that the vacfix is not a
cure-all, certain degenerate conditions cause it to perform as
bad if not worse than a traditional vacuum.
--
-Alfred Perlstein - [[EMAIL PROTECTED]]
Represent yourself, show up at BABUG http:
sql 7.0.3 here:
http://www.freebsd.org/~alfred/vacfix
I'm strongly considering taking the patches offline and reselling them
as I seem to be the only source for them nowadays.
--
-Alfred Perlstein - [[EMAIL PROTECTED]]
http://www.egr.unlv.edu/~slumos/on-netbsd.html
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
* Joel Dudley <[EMAIL PROTECTED]> [010327 11:29] wrote:
> Hello All,
> I am writing my first C function for postgres and failing miserably. my C
> function needs to get passed a username (char) , uid(int), and gid(int) and
right, wrong and wrong.
char *, uid_t, gid_t.
--
-A
I deleted Bruce's email and promptly lost the URL, anyone care to
forward it to me please?
thanks,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please se
formation during insert
or updates the insert rule. If you put a unique index on the 'lower'
column then the rule should bomb out and explain why.
As a safety precaution, i would also make a rule that automagically
bombs out on a direct update to the 'lower' column.
--
-Alfred
; it's not been around all that long.
Is there a way to do this atomically, meaning so that no one can
get at the table after dropping, but before recreating the index?
lock the table during?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
---(end of br
* Shaw Terwilliger <[EMAIL PROTECTED]> [010222 15:49] wrote:
> Alfred Perlstein wrote:
> > As a general safety precaution I would close a connection after a
> > timeout or N uses.
>
> My application is running on the same host as PostgreSQL, so connection
> timeout
Install Bison and re-run "configure"
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
* Shaw Terwilliger <[EMAIL PROTECTED]> [010209 16:18] wrote:
> Alfred Perlstein wrote:
> > Actually NFS has very strong write ordering semantics, it just has
> > terrible cache coherency. Meaning two machines accessing the same
> > file will most likely see diff
;s probably more black magic that can cause wierd
things to happen.
> Seems a lot better to run the Postgres server on the machine where
> the storage is.
Agreed. :)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
t, redundant
> local storage. I thought I'd ask the designers and users here so I could
> back up my recommendations.
NFS == Not F** Stable, don't do it. :) Any DBA will want to
hurt you when he hears about you running a production DB over NFS.
--
-Alfred Perlstein - [[EMAIL PRO
* Dave Cramer <[EMAIL PROTECTED]> [010124 09:08] wrote:
> Tom,
>
> Thanks for the hint, and no I wasn't looking in the right place. Here is the
>backtrace
This isn't a backtrace, you need to actually type 'bt' to get a backtrace.
-Alfred
I now reference pge_id as well as pge_path. Somewhere I
> have read that indices on CHAR are faster than those on VARCHAR.
No clue, but as a somewhat related note, I don't think indexes work
properly when a join is attempted on a CHAR and VARCHAR column.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|
nd server be more cheaper than Oracle, if the party is satisfied with
> PG performance? I browsed some PG commercial organization site that told
> about a Replication Server being available for PG. I am about to look into
> that next month. Is it any good like PG? Will provide failover too..rather
> than using Oracle.
It should, but I havne't read up on it much.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
nd* SQL at the same time.
Oh, so it's sort of like /proc for mysql?
What a terrible waste of time and resources. :(
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
ad data and then recreate the index, prefereably
with only an exclusive lock on the database being manipulated(*)?
(*) to avoid having to start up the postmaster with weird options
and/or stop activity on other databases under the postmaster's
control.
thanks,
--
-Alfred Perlstein - [[EMAIL P
don't enter a racing contest without tuning
and knowing a hell of a lot about your vehicle.
I really don't understand why people expect computers to do everything
for them, the burden of using tools properly belongs to the user.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
readsafe with a
few exceptions, see the docs for functions you shouldn't call.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
http://www.postgresql.org/mhonarc/pgsql-committers/
errors out with:
'Cant load template [search.htm]! '
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
it's both.
Honestly Postgresql should be able to deal with this limitation by
using more than one file per table.
But if you really want to support large files on a free UNIX,
I'd try FreeBSD.
best of luck,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart
post_util.o
> i386ld fatal: Symbol referencing errors. No output written to t_postgresql
This looks like a problem on your end, post_util.o references 'floor'
and even with -lm it's not being found. Can you compile something
with post_util.o without t_postgresql.o to see if it
* Enrico Comini <[EMAIL PROTECTED]> [001117 04:04] wrote:
> I use postgres with php3. Now I have to write some little applications.
> What language I can use ?
> Give me a valid idea.
Perl should work, you just need to install the postgresql module.
--
-Alfred Perlstein - [[
> * Philip Hallstrom <[EMAIL PROTECTED]> [001109 20:37] wrote:
> >
> > Yeah, that's what I've seen... I guess I was wondering if there were any
> > guidelines to raising them.. I mean should I up the defaults by 10? Or
> > up them by a percentage (to keep the relationship), etc...
>
> here's w
ep the relationship), etc...
here's what I use:
options SHMMAXPGS=512000
options SHMSEG=128
options SEMMNI=40 # /* # of semaphore identifiers */
options SEMMNS=240 # /* # of semaphores in system */
options SEMUME=40 # /*
ate too much memory for these structures
and cause problems booting or running your system.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
ning the amount
of shared memory it allocates as well as how much memory it
will use for "sort buffers"
-B 32768 (~256MB shared segment)
-o "-S 65534" (increases size of sort buffers, not sure how much though)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
shed at connection.
These values are fixed for the life
of the PGconn object.
It's described in the 'libpq' section of the programmer's manual.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
cution speed, I just want less cpu allocation no matter how slow.
Unix is a timesharing system, if you want an application on unix
to use less CPU then put it on a box with a slower CPU. If you
want to limit its priority against other processes so that it
shares CPU in a more friendly manner, the
* Roderick A. Anderson <[EMAIL PROTECTED]> [001016 12:32] wrote:
> On Mon, 16 Oct 2000, Alfred Perlstein wrote:
>
> > huh? How are you copying to an unmounted partition?
>
> Sorry I left that step out of the description. I usually mount it to some
> dumy point lo
this work with 7.1? (I'm writing up some instructions that I'd like
> to not have to change later.)
huh? How are you copying to an unmounted partition?
Afaik you need the device node to be mounted before you can write to
it.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
ime competitor against the big commercial database engines.
>
> WAL is a backup system.
afaik WAL means the end of the dreaded 'vacuum', it allows the system
to reuse free space without explicitly scanning the datafiles, it should
also do it in a manner that still allows transacti
because it is
an opensource project.
It's much more important to continue on with the rapid pace of
developement than to fear black helicopters that haven't even
shown up as blips on the radar.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
many of you would like to have him working full time on Postgresql
alongside several other highly skilled developers and compensated
for his work rather than trying to squeeze it into his everyday
life like so many other opensource authors with "real jobs" on the
side?
--
-Alfred Per
* Bruce Momjian <[EMAIL PROTECTED]> [001009 22:11] wrote:
> As many of you know, several businesses are involved in providing
> PostgreSQL support.
>
> After careful consideration, I have decided to accept a job with Great
> Bridge. There will be a press announcement tomorrow (Tuesday) with more
* Bruce Momjian <[EMAIL PROTECTED]> [000926 13:55] wrote:
> > Alfred Perlstein wrote:
> > >
> > [snipped thread]
> >
> > OK, if I'm reading it right, the general concensus seems to be - it'll
> > work, but there is a possibility of data l
you
may want to play it safe and not use softupdates.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
an't you get a traceback or crash dump with the Linux kernel?
And no, postgresql shouldn't be able to trash/crash your system
unless you have it configured in such a way that it can exhaust
all resources.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
me/postgres/postgres.log.
> Why is everyone else's script working without the -l and mine wasn't?
Check su's manpage.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
* Ian Turner <[EMAIL PROTECTED]> [000903 22:37] wrote:
> -BEGIN PGP SIGNED MESSAGE-
> Hash: SHA1
>
> When I try to do this:
>
> CREATE TABLE test (
> a Integer,
> b Integer,
> CHECK ((SELECT SUM(t.a) FROM test t WHERE t.b = b) < 1000)
> );
>
> INSERT INTO test (a, b)
* Zlatko Calusic <[EMAIL PROTECTED]> [000903 07:59] wrote:
> Hi!
>
> This is my first post (not counting those failed because I posted them
> from the other email address) so please be gentle.
>
> I have recently started playing with PostgreSQL and found what I think
> is a bug in postgres. I'm
> From: "Matthew Kennedy" <[EMAIL PROTECTED]>
> > I have a ton of data in a text delimited file from an old legacy system.
> > When uploading it into postgres, I'd do something like this:
> >
> > COPY stuff FROM 'stuff.txt' USING DELIMITERS = '|';
> >
> > The problem is some of the rows in stuff.t
* Moses <[EMAIL PROTECTED]> [000821 17:20] wrote:
> HI,
> My name is Moses, I work as system admin in INDIA and I just got your ID
> when I was looking out for a solution on Semaphore Problem which I am facing
> currently. I will be greateful to u if you could help me out on this.
>
>I wo
> Chris Bitmead wrote:
>
> > That's very helpful. Can you also tell us if Proprietry 1 or Proprietry
> > 2 was definitely NOT MS-SQL Server?
* Ned Lilly <[EMAIL PROTECTED]> [000815 18:59] wrote:
> Er... let me put it this way. Proprietary 2 prefers to run on Windows NT.
It's oracle??? j/k
You
* [EMAIL PROTECTED] <[EMAIL PROTECTED]> [000729 10:57] wrote:
> Dear all,
>
> Is there a way I can select the top 50 rows from table, 51 - 100 rows from
> table etc (with order clause)? It is because I am writing a message board
> and I would like to create the prev/next button on different
* Marcos Barreto de Castro <[EMAIL PROTECTED]> [000721 12:45] wrote:
> Hi,
>
> Can someone tell me how can I disable the more
> command at the end of any one page display in
> PostgreSQL 7.0 ? I simply don't want to be asked to
> press a key to continue displaying the result of a
> query.
* Steven <[EMAIL PROTECTED]> [000717 11:28] wrote:
> I'm pretty new using postgres, but is there any way to add a field to a
> table without droping the table and recreating it?
it's in the docs:
http://www.postgresql.org/docs/user/sql-altertable.htm
--
-Alfred Perlste
* Prasanth A. Kumar <[EMAIL PROTECTED]> [000717 08:49] wrote:
> Gilles DAROLD <[EMAIL PROTECTED]> writes:
>
> > Hi,
> >
> > Please don't use RPM if you don't want to have a Win$ based install.
> > It's remember me a very old question: Where are the DLL ?
> >
> > The better way is to get the tar
* The Hermit Hacker <[EMAIL PROTECTED]> [000705 12:03] wrote:
>
> just to curtail this while thread to a certain point ... switching the
> license to GPL is *not* on the table, nor has it every been, nor will it
> ever be ...
Good to hear, I was getting worried for a bit that the code might
bec
* Michael Blakeley <[EMAIL PROTECTED]> [000601 19:09] wrote:
> I hope someone on the list can suggest a solution for me - given a table like
>
> CREATE TABLE EVENTS( stamp date, id varchar(16), event varchar(128) );
>
> I'm trying to find the average age of the records. I've gotten as far as:
>
* Tom Lane <[EMAIL PROTECTED]> [000526 15:43] wrote:
> "Bryan White" <[EMAIL PROTECTED]> writes:
> 4, I could probably get by with just 2 If I had to. I will give it a
> try.
>
> > With the indexes deleted I am now getting 40 or 50 updates per second
> > instead of 5.
>
> That's good,
anna run the debian whith his diabolique
> dselect & apt-get
Try FreeBSD:
http://www.freebsd.org/
:)
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
> # At 04:56 PM 5/15/00, Diego Schvartzman wrote:
> # >I have an application via PHP. For example, a SELECT query that must return
> # >one and only one row, with a where clause with and index (I droped it and
> # >created again) that took about 3 seconds (v6.5.3), now (v7.0.0) takes about
> # >15
* Lincoln Yeoh <[EMAIL PROTECTED]> [000511 21:25] wrote:
> At 07:21 PM 11-05-2000 -0300, The Hermit Hacker wrote:
> >
> >Do you not have a copy of the code sitting in front of you, or
> >nearby? Don't greater then, oh, 50 mirror sites? Don't >500 downloads of
> >v7.0 since release? My point is
anpages now? Is there some way
> > to get them via cvsup/cvs?
>
> They are in SGML format in pgsql/doc/src/sgml.
Oh, that's cool, I'm glad whenever autogenerated stuff is removed
from the tree because it certainly helps my download time especially
when getting a new repo.
thanks,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
CVS, but why remove the manpages entirely from the repo? It
makes little sense to me because it makes it more complex to submit
changes.
How does one submit changes to the manpages now? Is there some way
to get them via cvsup/cvs?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
pg_dumpall then using psql to source the file went off perfectly.
Just a nit, where's the manpages in 7.0? :)
Thanks for the excellent database system, and best of luck with
the recent step up in the business and political open source world!
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[
Hopefully this is considered on-topic, please trim cc.
http://www.wintelcom.net/\n\n");
exit;
?>
Work with the best or die like the rest.
hope to hear from you,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
econd and time zone part.
>
> Is there any ways that make the output doesn't contain the nano second and
> time zone part?
>
> Thnx a lot!
I think the date_trunc() function is what you need to use.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
some other trick?
Also, I think the count(*) is a bad idea because we only need to know
if a single entry besideds the one we are deleteing exists, not the
actual count.
Any suggestions?
thanks,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I have the heart of a child; I keep it in a jar on my desk."
ble to select a date range (let's say a month) and perform
sums on some of the columns however "group by" the day, so that I
get rows returned that are the sum of all the day's statistics for
several days.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
"I hav
t;Is the postmaster running at 'localhost' and accepting connections
on Unix socket '5432'?"
well, is it at least running?
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
for simple question, but I just started using PostgreSQL.
I'm pretty new to postgresql as well, but i think what you want to
look at is the RULES section of the documentation, it seems that
would be what you're looking for.
I haven't done it myself, but there's some decent examples there.
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
cause my SQL is broken, or because
of table corruption?
I've dropped and re-created the "formatted" table (DROP/CREATE) and
this still happens.
Any ideas? (i'm using 6.5.3)
thanks,
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
* Dean Browett <[EMAIL PROTECTED]> [000218 15:55] wrote:
> Hi,
>
> We are running postgres-6.5.3 on a dual pentium 300 machine, 0.5Gb RAM under
> Linux Redhat 6.0 (kernel 2.2.14). The machine we are using sits on a 100Mb
> network and the nics are 3com3c590's. We are also using a DPT Raid
> contr
* Ron Chmara <[EMAIL PROTECTED]> [000116 16:18] wrote:
> Peter Eisentraut wrote:
> >
> > On 2000-01-14, Alfred Perlstein mentioned:
> >
> > > > issue: how to secure cgi's that access postgres
> > > >
> > > > problem: passw
* Peter Eisentraut <[EMAIL PROTECTED]> [000116 09:30] wrote:
> On 2000-01-14, Alfred Perlstein mentioned:
>
> > > issue: how to secure cgi's that access postgres
> > >
> > > problem: passwords for postgres database are stored
> > &g
dir, you'll
either need some sort of setuid (to a special user, not root) or
use some sort of cgiwrapper.
-Alfred
>
> On Fri, 14 Jan 2000, Alfred Perlstein wrote:
>
> > * Jeff MacDonald <[EMAIL PROTECTED]> [000114 13:38] wrote:
> > > hey folks,
> > >
&
>
> question in short: how to make perl accessing databases
> more secure, so any jack can't modify a database.
>
> thanks in advance.
>
> Jeff MacDonald
> [EMAIL PROTECTED]
>
--
-Alfred Perlstein - [[EMAIL PROTECTED]|[EMAIL PROTECTED]]
68 matches
Mail list logo
