Re: [HACKERS] pg_autovacuum next steps

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 -- [EMAIL PROTECTED] Alex J. Avriette, Systems Programmer

Re: [HACKERS] pg_autovacuum next steps

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 PROTECTED] Alex J. Avriette, Unix Systems Gladiator You cannot invade

Re: [HACKERS] Timing of 'SELECT 1'

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.postgresql.org/docs/faqs

Re: [HACKERS] Slony-I makes progress

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, Unix Systems Gladiator v shpxvat ungr jvaqbjf naq v ubcr ovyy tngrf oheaf va uryy. - Ronald O. Thompson, 13

Re: [HACKERS] Slony-I makes progress

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. ---(end of broadcast)--- TIP 7

Re: [HACKERS] [ADMIN] Schema comparisons

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 -- [EMAIL PROTECTED] Alex J. Avriette, Solaris Systems Masseur http://envy.posixnap.net/~alex/articles/nro-wahhabi.html

Re: [HACKERS] Tablespaces

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 J. Avriette, Unix Systems

Re: [HACKERS] Tablespaces

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 of arms, as the blackest. - Mahatma Gandhi

Re: [HACKERS] RFC: Security documentation

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 wayward Database Administrators We are paying through the nose to be ignorant

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

) 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. Alex -- [EMAIL PROTECTED] Alex J. Avriette, Unix Systems Gladiator The Emperor Wears No Clothes. http

Re: [HACKERS] RFC: Security documentation

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 said policies wound up in a doc. Alex -- [EMAIL PROTECTED] Alex J. Avriette, Unix Systems Gladiator I favor the Civil Rights Act of 1965, and it must

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

-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

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 small percentage, even 1% would

[HACKERS] RFC: Very large scale postgres support

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 boredom with no hope of parole is a much worse punishment than just

[HACKERS] Brokenness in parsing of pg_hba.conf

mention it, since it surprised me today. Thoughts? Alex -- [EMAIL PROTECTED] Alex J. Avriette, Solaris Frobnosticator You can get much farther with a kind word and a gun than you can with a kind word alone. - Al Capone ---(end of broadcast)--- TIP 1

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

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)--- TIP 5: Have you checked our extensive FAQ? http

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

' problem. There isn't any point in filing a bug if it will be ignored. 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 grass. - Admiral Isoroku Yamamoto ---(end

Re: [HACKERS] psql \d option list overloaded

to use interactively. Making pseudo sql will encourage more developers to (and I'd apologize for this if it weren't true) code in Postgres the same lazy way they code in MySQL. Alex -- [EMAIL PROTECTED] Alex J. Avriette, Unix Systems Engineer It's computationally FEROCIOUS. - Steve Jobs, discussing

Re: [HACKERS] psql \d option list overloaded

, 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. Alex -- [EMAIL PROTECTED] Alex J. Avriette, Solaris Systems Masseur I ... remain against the death penalty because I feel that eternal boredom with no hope

Re: [HACKERS] feature request: \qf datatype

. 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 that, we could ... just bronze Gates, turn him into a statue, and stick him in front of the Commerce Department

Re: [HACKERS] feature request: \qf datatype

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 Object-oriented programming is an exceptionally bad idea which could only have originated in California. - Edsger Dijkstra ---(end

[HACKERS] feature request: \qf datatype

for people who haven't yet becomes familiar with postgres' (very rich) function base. Hm. On second thought, \qf is a bad name for it, as \q is quit, and 'f' is an unexpected extra argument. Perhaps \dfq? Thanks, alex -- [EMAIL PROTECTED] Alex J. Avriette, Professional Something-or-Other