Locate your postgresql.conf

locate postgresql.conf

Assuming you are a highly skilled super user who fully understands and is responsible for all configuration changes s/he makes, edit postgresql.conf

vi postgresql.conf

Find the section with the log_min_duration_statement option:

/log_min_duration_statement

For the purpose of finding out what to improve, I set mine like this:

log_min_duration_statement = 250        # -1 is disabled, 0 logs all statements
                                                            # and their durations, in milliseconds.

A reload is all that is necessary to cause pg to use the new duration - at least after uncommenting the line. I used restart a few times and then successfully tried reload.

Since I am using Debian:

/etc/init.d/postgresql-8.1 reload

My postgresql logs are here:

tail -f  /var/log/postgresql/postgresql-8.1-main.log

After finding and fixing some long running queries, be sure to edit your postgresql.conf again and set the

log_min_duration_statement = -1

to turn off the function. Just commenting pg conf file settings out does not guarantee they will return to default, according to pg references I have read.

Be sure to reload and tail the log file to ensure that settings are back to performance mode.

See Power PostgreSQL website for more performance tuning info.

"... setting LANG=en_US then people post bugs to the GNU coreutils
about it claiming it is a bug. See the ...   more »

Yep tomorrow is my birthday. 44.

I would like a toaster and cds of the "Starseeds" and or William Orbit ...   more »

I use Cold Fusion to loop over a distinct query for the table that contains the duplicates. Note that your table needs to have OIDs, or a unique primary key.

column_a is the key field I want to eliminate duplicates on

SELECT distinct column_a
FROM table_a;

CFLOOP over the above query - query_a

DELETE FROM table_a
WHERE column_a = #query_a.column_a#
AND OID < (
    SELECT OID
    FROM table_a
    WHERE column_a = #query_a.column_a#
    ORDER BY OID DESC
    LIMIT 1
);

/CFLOOP

Many Internet access ISPs now block port 25. To access an outbound server other than your access ISPs, you can ...   more »

Should most technology that provides global scale benefit be provided through a "non-profit" organization?

Are non-profit organizations more ethical than for-profit organizations?

Do non-profits do a better job of maximizing the potential of technology for doing good in the world, than for-profits?

Why are some service offerings best suited to non-profit organizations?

****************
Case A: Cure for the Purple Plague in Perlivia

Let's say you uncovered a cure for a deadly malady "the purple plague" most prevalent in (fictional) third-world country Perlivia. Hundreds of thousands of victims die every year, mostly children, some with children they leave orphaned, mostly from families living below poverty level income.

The "users" most directly benefited by your technology are unable to pay for the services they need. Life and death is at stake; the opportunity for children to grow up unscarred is at stake, and the lifetime potential of these Perlivians to do good in the world is in jeopardy at best.

Individual philanthropists who may give you the money to distribute your cure - gain a dual benefit by giving you the money - only if your organization is structured as a non-profit. They do not have to pay taxes on the money they give you - and they can feel good about helping people less fortunate.

Corporations who may give you money to distribute your cure can use their involvement as a PR benefit, perhaps gaining customers by having people know they give money to some good causes.

Can you obtain sufficient revenue from those most directly benefited, to do an excellent job of getting this technology to the most people in the world who can use it?

Is it appropriate in this case to ask others (governments, private donors, corporate foundations) who don't directly benefit, to pay for those who do?

*************

Case B: Theft-proof Ink Pens

You've come up with a modification to ink pens that (magically) prevents them from leaving the area they were purchased for. The technology only works for writing instruments. It will add 1 cent to the manufacturing cost and have no impact on other costs associated with distribution of the product.

Both individuals and corporations use ink pens. So do non-profit organizations. However, of the billion (you can find out the real pen market size here: 2003-2008 World Outlook for Fountain Pens) ink pens bought per year, only a small number are mis-appropriated from private homes. For-profit corporations suffer the largest ink-pen-misappropriation cost. Non-profit organizations also "lose" ink pens - but dollar figure of the loss is orders of magnitude smaller than the loss to for-profit corporations.

Is the "user" who benefits most from your innovation able to pay for the enhanced product?

Corporations are losing a box of 12 pens for every pen that stays in the office for its useful life. Market tests show that corporations will gladly pay 12 cents more per pen - seeing the ROI on that decision as instant and worth many times the investment.

Manufacturers and distributors split 10.975 cents per pen - and your Magic Stayput R&D Lab gets 1/4th of one cent per 10 pens if you operate as a for profit. Several large knock-off pen makers also duplicate your innovation and pay you nothing. The knock-offs assume a 95% market position.

You find yourself smiling understandingly as you and your team cheer the creation of Magic Stay-Put R&D Lab's Sunbake waffler. The 1.2 million in annual revenue you get from the pen industry has allowed you to employ a fine set of ethical innovators and supply test equipment for making more products that make people's lives better.

Another option would be to form Magic Stay-Put R&D Lab as a non-profit. You could ask individuals to give to this good cause - whose primary direct benefitor is for-profit corporations who would lose fewer pens to employee theft. Or you could ask the ink pen industry to support your lab, perhaps with an annual membership at various sponsorship levels depending on size. Or you could ask the for-profit corporations (who will save through the use of your pen modification) to support your work with a sponsorship or membership annually. Or perhaps seek a government grant - the government is losing pens to employee theft too - and maybe law enforcement would be interested or counter-intelligence for possible applications in laser pens.

**********

Primary goal is getting the technology to the places it can do the most good.

Some services and products are primarily of use to businesses and organizations who are able to pay and will make money or save money by acquiring these services and products. What are the circumstances under which a non-profit organization is the most efficient way to create, deliver or sustain services that primarily benefit for-profit business?

Clearly if there is no need for "charity" - a charitable non-profit is not the appropriate form. There are not-for-profit industry associations. One purpose they may serve is to show no favoritism to any one company in the industry, and act as a unifying force or buffer for a variety of players in an industry to aggregate or exchange information.

Other services and products will require substantial funding to get them to people or organizations who cannot afford them. Here, a charitable non-profit may be an appropriate form.

In many cases, profit from sales to for-profits can be used to also support getting the technology to those who cannot afford it. The same technology can be sold to for-profits (who gain ROI from the purchase) and also distributed through a non-profit organization to those for whom paying doesn't make sense. Government, foundation, industry sponsorships and private giving can help fund the non-profit arm.

T or F: While pursuing investor dollars, innovators stay focused on making their product or service the best it can be and the thought they wake up with every morning is how to do better at helping people today  

 

T or F: As the innovation interacts with users and requirements inevitably shift as new ways to help people are illuminated - investors encourage innovators to mold the business model to what is best for helping people.

T or F: Once the product or service is succeeding at helping people, investors obtain their ROI in the way that is most supportive of the product or service continuing to help people.

   more »

Click here for April Lorenzen's Wishlist Intro and wishlist

If you get logged out of webmail - you can now log back in and click the Compose link to restore your work:



Click the OK button and the text you had typed so far will be restored.
more »

See http://ors.blogs4change.org, described as:

"... a non-proprietary and highly collaborative space for a group of people interested in an Open Reputation System for Email (or other name the group decides on.) "


   more »

Sometime over a year ago, the Outbound Index started keeping a collection of data about domains and their name servers. We record new name servers, deleted name servers, IE changes to name servers. From this we could get churn rate as well as density per cidr block, and age of name servers.   more »

We do not make any distinction about how the sender got the RCPT address or if he has permission to send to it. We simply note that inherently - those without permission to send must constantly move and change or be blacklisted. Those with no reason to move and change rapidly are those whose mail is generally welcomed by the RCPT.   more »

We have a small hosting business for web and email serving several hundred domains and several thousand email accounts. Time is split between consulting for customers (web / database / Photoshopping / hand-holding / advising), hosting maintenance, and dev / maintenance of Outbound Index and related email tech.   more »

Setting aside the blogging/journalling features, Blogware is quite a nice CMS (Content Management System) for websites. CMS usually cost thousands, ...   more »

Your site visitors can just click on the attachment to hear your MP3. However, if they use ipodder software - they will automatically get your new podcasts when you add them to your site. Their software checks for new recordings at scheduled intervals and automatically downloads your podcast and adds it to their playlist.   more »

What is the one thing a fraud cannot copy?

Element 1. Something personal to the individual user.
Examples: a personal photo or a personal sound recording of their pet, child, loved one or self. Selected by the user, not by the software maker or application server, not by the third party trust authority.   more »

The bad news is that even if an SPF record helps get your mail delivered to Microsoft Hotmail or MSN email users - an SPF record may hurt your email's spamminess score elsewhere, at hundreds of thousands of non-Microsoft mail services.   more »

My primary goals are:

 - Make sure all revenue generating emails arrive to the business and get seen

 - Employees waste very little time each day on emails such as spam, viruses, scams - energy or actions which may harm or at least do nothing positive for the business

The Outbound Index was conceived and designed to function on a global scale. It has been in use for several years in the service of business customers   more »

VARA = Verified And Recipient Authorized, a simple, public domain concept with applications in anti-phishing and fixing the forwarding ...   more »

If you see a color and style you like on this page just click the radio button next to it and then click Change at the bottom of the page. If you prefer to put in your own color directly, read on.   more »

Get your entire website submitted to Google with what is likely to be the best priority you can get - by following our four step shortcut.   more »

Buried under many layers of new Google services is a gem for website owners - Google Sitemaps. Like several recent ...   more »

Ironically, efforts to block spam sometimes cost businesses revenue by preventing employees from seeing mail from legitimate contacts, including customers. ...   more »

Email signatures are a great subtle form of advertising, bringing you new business through personal networking. People who correspond with you usually need your web address, phone fax and mailing address, so it also saves a lot of typing.   more »

Written for a user who asked for a way to get his mail from multiple computers, home and travelling. Often ...   more »

Written for the novice, this article details three steps - 1. upload the PDF, 2. discover and copy the web address of the PDF, 3. create a hyperlink. Tips on avoiding common mistakes in naming files as well entre to the secret world of A HREF for non-programmers.   more »

It's the classic catch 22: you'd like to get rid of the spam clogging your existing email address by starting over with a new one. But you've printed that email address on all your business cards, letterhead, it's in your advertising and you have important customers who write to it.   more »

Three Crucial Reasons to Verify Control of Your Domain and Business Email Address - Reason number one: Your email address is a valuable asset; you pay to advertise it, customers retain it. Would you change your phone number overnight or let a third party control any of your other business reputation assets?   more »

I have started a "just what you *need* to know" tutorial for using Blogware to create your own blog....   more »

As I have studied how IDEAS are handled in all of these communities - my mind has changed about the value and appropriateness of patents and litigation. I have come to believe that it is the person or company who "takes the best CARE of an idea" - who should, and automatically does -get market share on an idea.   more »

The Flash simulation vividly portrays the effect of putting people between the sources of mosquitos and the trap - people will get bites. The user can play with wind direction and add multiple traps. Clicking "Breed Mosquitos" causes mosquitos to fly out en masse from the bushes, stagnant water, hedges, garden etc.   more »

I have frequently had success guessing other directories and finding the file there - webmasters do make mistakes sometimes - or as I did in this case, switch from http:// download to ftp:// and see if I can browse their anonymous FTP site and locate the desired file. Viola!   more »

MS support has a topic on this - basic advice is to disable or remove hardware that XP may be having trouble finding a driver for - they claim that it isn't really hanging but could take 30 minutes to detect.   more »

How a five year old girl who trips circuit mains and defies an elementary teacher by checking out "Boy's books" about electronics from the school library grew up to write this blog.   more »