Re: [HACKERS] pg_autovacuum next steps

2004-03-22 Thread Alex J. Avriette
, but I really need to have more flexibility or we are going to (read: I will be tasked with) be writing our own. Sorry for the terseness -- and I haven't had a chance to go over the whole thread; we're moving from 7.3.2 to 7.4.2 on "the big database" this week. Alex -- [

Re: [HACKERS] pg_autovacuum next steps

2004-03-22 Thread Alex J. Avriette
were just if it was ready, and how or if it should change when it goes in. It is very simple code, I'm not sure what is "not ready" about it. If people don't want to use it, they don't have to. Many databases can go days to weeks without vacuuming. alex -- [EMAIL PROTECT

[HACKERS] feature request: \qf datatype

2003-12-25 Thread Alex J. Avriette
ven found the \df macro. However, the C stuff was beyond my ability. Hopefully, this is a direct "clone \df" item. I really think this would be useful for people who haven't yet becomes familiar with postgres' (very rich) function base. Hm. On second thought, \qf is a bad n

Re: [HACKERS] feature request: \qf datatype

2003-12-26 Thread Alex J. Avriette
ses. Duplication of help systems that are never going to be used is a waste of everyone's time. Alex -- [EMAIL PROTECTED] Alex J. Avriette, Unix Systems Gladiator "Shut down some of the bullshit the government is spending money on and use it to buy all the Microsoft stock. If we did tha

Re: [HACKERS] feature request: \qf datatype

2003-12-26 Thread Alex J. Avriette
in psql. I'm just unable to actually do the C part myself. If somebody would step up to the plate, we could see this in the next release. I haven't heard anyone say they didn't like it. alex -- [EMAIL PROTECTED] Alex J. Avriette, Windows Systems Defenestrator "Obj

Re: [HACKERS] psql \d option list overloaded

2004-01-04 Thread Alex J. Avriette
't have any particular allegiance to the forward slash over anything else. My chief concern is that what we're abstracting here are macros, and as such, they should not be treated as sql. Because they aren't sql. If you want to find out how to show the databases in sql, use psql -E.

Re: [HACKERS] psql \d option list overloaded

2004-01-05 Thread Alex J. Avriette
ht* with those extensions. You can't become a PostgreSQL guru without > being a newbie first. I vote we make it easier for newbies. What really frightens me here is that I know of several applications (shudder, "LAMP" applications) which use the output of "show tables"

[HACKERS] Brokenness in parsing of pg_hba.conf

2004-01-06 Thread Alex J. Avriette
ip4 address. However, I'm aware that many people don't even realize this is a valid address. As such, I won't lose any sleep over it, but I thought I'd mention it, since it surprised me today. Thoughts? Alex -- [EMAIL PROTECTED] Alex J. Avriette, Solaris Frobnosticator

Re: [HACKERS] Brokenness in parsing of pg_hba.conf

2004-01-06 Thread Alex J. Avriette
7;d really like to hear from others what their opinions on this are. alex -- [EMAIL PROTECTED] Alex J. Avriette, Shepherd of wayward Database Administrators "We are paying through the nose to be ignorant." - Larry Ellison ---(end of broadcast)

Re: [HACKERS] Brokenness in parsing of pg_hba.conf

2004-01-06 Thread Alex J. Avriette
think that it isn't supported? > those library routines behave, forward your bug report appropriately > --- but it's not Postgres' problem. There isn't any point in filing a bug if it will be ignored. alex -- [EMAIL PROTECTED] Alex J. Avriette, Unix Syste

[HACKERS] RFC: Security documentation

2004-02-07 Thread Alex J. Avriette
luded in the next release. I don't feel that having zero documentation on this subject is acceptable. Thanks for your time, alex -- [EMAIL PROTECTED] Alex J. Avriette, Unix Systems Gladiator "You cannot invade the mainland United States. There would be a rifle behind each blade of g

[HACKERS] RFC: Very large scale postgres support

2004-02-07 Thread Alex J. Avriette
hopes that we can discuss both the best way to support very large scale databases, as well as how to handle them presently. Thanks again for your time. alex -- [EMAIL PROTECTED] Alex J. Avriette, Solaris Systems Masseur "I ... remain against the death penalty because I feel that eternal bor

Re: [HACKERS] RFC: Very large scale postgres support

2004-02-08 Thread Alex J. Avriette
load balancing (eg rotors or similar) and updates between postmasters, it would be (it seems to me) possible to drastically increase the available capacity of a database installation through the addition of more nodes. This has the added benefit of allowing us to distribute network resources. A

Re: [HACKERS] RFC: Security documentation

2004-02-08 Thread Alex J. Avriette
yone would be opposed to this, however. I'm happy to write the document and provide a patch for inclusion if we can come to agreeance on some basic policies. The reason I posted the original message in this thread is I wanted to know what others felt were appropriate policies, and to suggest

Re: [HACKERS] RFC: Very large scale postgres support

2004-02-08 Thread Alex J. Avriette
also think most of us would agree that the current "graft-on" replication methods are sub-ideal. alex -- [EMAIL PROTECTED] Alex J. Avriette, Unix Systems Gladiator The Emperor Wears No Clothes. http://www.drugsense.org/wodclock.htm ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] RFC: Very large scale postgres support

2004-02-08 Thread Alex J. Avriette
On Sun, Feb 08, 2004 at 09:20:07PM -0500, Rod Taylor wrote: > On Sun, 2004-02-08 at 21:01, Alex J. Avriette wrote: > > On Sun, Feb 08, 2004 at 08:01:38PM -0500, Rod Taylor wrote: > > > > > Replication won't help if those are all mostly write transactions. If a &

Re: [HACKERS] RFC: Security documentation

2004-02-09 Thread Alex J. Avriette
stions via google first. If the docs were included on techdocs, google would find them soon enough. I suppose, also, anyone who was interested in securing their database would look a little further than the included documentation. Opinions? Alex -- [EMAIL PROTECTED] Alex J. Avriette, Shepherd of

Re: [HACKERS] Tablespaces

2004-02-26 Thread Alex J. Avriette
> I don't intend going this far, however. Perhaps now would be a good time to bring up my directio on Solaris question from a year or so back? Is there any interest in the ability to use raw disk? Alex (who is overjoyed to hear discussion of tablespaces again) -- [EMAIL PROTECTED] Alex

Re: [HACKERS] Tablespaces

2004-02-26 Thread Alex J. Avriette
I'm very glad to hear tablespaces mentioned again and see what looks like work being done on it. Thanks! Alex -- [EMAIL PROTECTED] Alex J. Avriette, Solaris Artillery Officer "Among the many misdeeds of the British rule in India, history will look upon the act of depriving a whole nation

Re: [HACKERS] [ADMIN] Schema comparisons

2004-02-28 Thread Alex J. Avriette
e" schema and the schema in cvs at work. This was a really painful process, and it occurred to me that it wouldn't be terribly hard to write a perl program to do it (I wound up using vim and diff). Is there interest in such a tool? I could probably have one written within a day or two. Alex -- [

Re: [HACKERS] Slony-I makes progress

2004-03-03 Thread Alex J. Avriette
;d like to avoid the dogmatic jihad by not submitting a perl tool if the eventual goal is to be end-to-end C (or java or tcl or whatever). Alex -- [EMAIL PROTECTED] Alex J. Avriette, Unix Systems Gladiator "Something seems to have happened to the life support system , Dave.

Re: [HACKERS] Slony-I makes progress

2004-03-05 Thread Alex J. Avriette
gui if need be). It seems to me, that until the postmaster has some kind of native replication, all replication efforts will be based on external programs. As such, they should be configured externally, and be treated as any other daemon would be. Alex -- [EMAIL PROTECTED] Alex J. Avriette, U

Re: [HACKERS] Timing of 'SELECT 1'

2004-03-12 Thread Alex J. Avriette
nobody actually come to a conclusion on what that "last msec" was from? Alex -- [EMAIL PROTECTED] Alex J. Avriette, Unix Systems Gladiator ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.pos