why should the bank collect interest on money they borrowed from the people's government for next to nothing?
- where did you read my endorsement of such a deal?
I am completely AGAINST government meddling with economics and currency. Banks must not be bailed out and stimulated by government lending, they must survive on their own by providing customers with products that make it beneficial for the customers to lend their money to the banks!
When you put your money into a bank, you are not just giving it to them for safekeeping (or you can do that with a safety deposit box, or only holding cash in checking account, but this doesn't even guarantee that your money isn't used by the bank for loans), but you are giving them a resource, a reserve, which they can then lend out. As long as there is no bank run, bank can make loans based on the reserves it has that come from depositors.
FDIC made it so that the bank customers stopped caring about the business practices that banks are engaged in. So instead of choosing a bank and a plan based on risk aversion, bank customers only chose banks based on proximity to their house and maybe based on the interest that they could get while their money was in savings accounts.
Government regulation in form of FDIC in this case created the moral hazard where customers of care more about which toaster brand they are going to buy rather than which bank they will lend their money to.
Funny thing is is now that some banks got the bail out money, they are now charging reverse interest on the money you hold there (negative real interest rates) based on the fact that everybody know that the moral hazard is there, so if there is another financial collapse (and it's coming), those banks WILL BE BAILED OUT AGAIN. Of-course this can only continue until the government itself collapses because the currency collapses and nobody can bail out USA with all its debts and no production capacity.
Now that they can borrow from the fed for next to no interest and we can only benefit if we pay vastly inflated interest on bank loans, they have turned nasty.
- banks needed to fail.
When I write comments that explain how wrong the monetary policy of money destruction is, I get moderated in ways, as if I am proposing that everybody starts molesting children and kittens, so now I decided to write more in the journal instead.
Capitalism is only interested in maximising short term profits.
This is false, I will take a great caution to explain why, caution, because it is NOT popular view on/.
As an individual person I am interested in being able to live a long and prosperous life. I may absolutely FAIL in doing that, but it's the goal. To be able to lead a life that is prosperous, I do think about long term consequences of my investment, my actions and work.
Were I an individual person, who had unrestricted access to government and ability to "borrow" from government at 0% interest (that's why borrowing is in quotes), then it would be in my best interest to borrow as much as possible without any restraints and to attempt to gamble with that money instead of trying to invest it, because though the money is given to me at 0% interest, I may have to (maybe) return the principal at some point in time.
Free money makes people gamble and take great risks.
Investing your own money makes people understand that there is risk.
I did write about the reasons for HFT here and about free money and it applies to thinking of all business in economies, that are this regulated, this inflated, this taxed and this subsidized.
There is no reason to take a long term look at things, when there is gambling going on all around. There is no reason to pay dividends and there is no reason to expect dividends, with these levels of inflation. There is no reason to think beyond the next quarter, because the company is broke today, it's on life line extended by government support, tomorrow this blood line may be cut and then the company will die. Everybody knows about it, nobody admits it.
However, it's pretty hard to deny that an alternative operating system that's fully compatible with Windows applications will not be commercially viable.
- BS. I won't be, because there IS already an alternative to Windows. It's pirated Windows and it will always be the preferred alternative to those, who want Windows, don't want to pay for it, while not interested in switching to half a dozen of other options, including Apple, GNU/Linux/Unix, whatever.
The big issue with failures like Solyndra is that there was no transparency and no accountability. That says a lot more about the Obama administration than it does about government involvement in backing startups.
- there is NO SUCH THING as accountability when it comes to money that comes out of the printing presses by the very definition of the fact, of where the 'money' came from.
By the way, my original comment was in no way a 'flamebait', but again,/. moderation is broken.
To reply to your comment: Yuri Gagarin and the entire space race was funded by using basically what amounts to slave labor in the former USSR. I should know, I was born there. Most of the country's resources was directed to military spending, space race, and whatever dust that could be thrown into the people's eyes, just to make it look like something worked.
As to Neil Armstrong - SS fund was raided for that and to what purpose? How much private enterprise innovation was stifled and diverted to this waste of resources, putting a man into orbit, when it is in fact clear that we don't need people in space at this time because we don't have a purpose for them being there.
Nuclear energy has been subverted by government agenda, I talked about it here. It should be done privately to search for cheaper, more efficient ways of generating power.
As to ENIAC - there is always an argument that other priorities must be put on hold, when important wars are fought, and then all of the nation's resources are diverted to that. Unfortunately we fight these wars, but we fight them specifically because governments destroys free market and prevent economies from working, and then there are too many unemployed, which can be diverted by some perverted "leaders" to fight bloody wars. This is NOT a good endorsement of government power AT ALL.
Governments funding of projects, any projects, is mis-allocation of resources. If the project in question has any reason to exist, then there would be private funding for it, private lending, private interest.
In his speech Obama didn't say "stimulus" once. He wants to stay away from that word, last stimulus was a failure and unpopular.
Of-course deficits that finance the stimulus destroy more jobs than the tax cuts create.
None of it is paid for, cuts from future increases is not paying for anything, but there is net increase in deficit (and it's underestimated) 450 Billion USD year 2011.
Debt ceiling now will have to be raised again obviously next year, because this is 450Billion that are not accounted for in the last debt ceiling increase.
Tax credit for hiring people who are unemployed for more than 6 months. So now employers will have incentive NOT to hire anybody who hasn't been unemployed for 6 months:)
More unemployment!
7.25 - is minimum wage. 4000USD is given as tax credit, and you have to keep the person for 6 months minimum. So hiring somebody at 7.25USD/hour and given 4000USD credit reduces minimum wage to 3.40USD/hour.
Minimum wage will be reduced, and so there WILL be more employment, but some people will be FIRED to give more space for new minimum wage hires because of the tax credit.
Bill will make it illegal to discriminate against long term unemployed. So what will happen is that people who are long term unemployed will NOT be interviewed. Who wants to have a lawsuit on their hands?
If anybody is unemployed for 4-5 months, now there is a reason not to hire them right away, to interview them and to keep them on UI for another 1-2 months and then to get the tax credit once they are at 6 months unemployment time.
Of-course fire anybody after 6 months, get new hires. It's all going to be minimum wage jobs, nobody who is hiring people at good salaries will care about 4000USD tax credit.
The 1 year cut in SS payroll tax will make SS that much more broke (it's broke now, but it can be made worse.)
To pretend that there is SS "trust fund", gov't will borrow money, put it into "trust fund", borrow from "trust fund" and spend it on stimulus. Many lies all around.
If you hire a returning veteran, the tax credit is 5600USD. Applied to minimum wage, it makes minimum wage 1.87USD/hour. This creates huge government incentive to have very high turnover.
Payroll taxes will be lost on existing jobs, ha ha. They'll have to print more money.
For returning veterans with injuries (wounded warrior), you get 9600USD tax credit. For a minimum wage job this makes the pay a NEGATIVE ONE:) -1.98USD/hour.
Hire as many wounded warriors as possible immediately and just pay them, but the employer gets 1.98/hour for every new hire. Hire all of them and have the Fed monetize the debt that will be created paying these tax credits.
the disasters of beginning of this century include XML. In everything. "Agile" development. IE6 and ActiveX controls. IBM Lotus Notes. "Visual" programming, especially mixed with UML and RUP. Passing parameters from URLs directly to database layers as input without sanitation. Not checking data structure boundaries and sizes. Using root for everything, this one is especially nice when combined with a password, that is used for everything in a corporation. Especially when password is some variation of "adminpass1". Buying more and more BEA/Oracle licenses to set up more and more nodes where the real speed problem could be solved with very little code on a single machine, but obviously that's not sexy and doesn't buy perks. Having no testing cycles, never having enough testing, doing irrelevant testing (this even includes automated testing, which can be huge, but still irrelevant).
Producing huge meaningless documents that end up copied in email to everybody, but eventually don't get read by anybody who they should address, having template "Architecture", where past documents are copied, whatever names are replaced, no thought is given to the project and all the details are left over to the team for the time of implementation. This, especially when combined with time lines that give 80% time to meetings/architecture, 12% time to all of the development combined and then whatever remains is running around like chickens with heads cut off, from users to testers to admins, trying to get any of it working.
All of the above and more, much more are disasters.
But the real disaster here is that pathetic article that this story refers to.
There is nothing wrong with fractional reserve banking as long as the banks actually do due diligence, so that money that they loan out is for business creation based on sound ideas and planning and not for gambling or buying consumer products.
Building new businesses does create wealth for everybody. If a person takes a loan and provides collateral, and builds a business with that loan and creates products that the market wants and repays the loan, then here is what happens:
1. Loan is lent out and then interest is paid, loan is repaid. Investors have made money, which is good.
2. A new business is started, products are made that the market wants to buy, which makes everybody wealthier via production of these products, which is good.
3. The businessman found a way to generate profit and increase his own wealth, so now he is better off financially, which is good.
--
Here is the problem with the way things are done now:
1. Politicians get elected based on promises of free lunch, to whoever, be it the more SS or be it more corporate welfare, at the end this helps the politician to make some cash and it always helps some special interest, while growing government bigger, which is bad.
2. The bigger the government, the more it spends, and it's impossible to shrink it, and when economy slows down and even shrinks, government only grows via taxes, loans and then debasing of money, which is bad.
3. National bank prints fiat currency to subsidize government spending, which adds to the debt and eventually prevents the economy from being fixed, because the bigger the debt, the less likely it is that interest rates will be let go by the government, because the bigger the debt, the more expensive it is to service it. At some point inflation becomes unbearable and currency can fail, which is bad.
4. Some people make a lot of money on the process of currency debasing, these are the people who are close to the government circles, they are making policy that helps them, but destroys currency and economy in the process, which is bad.
5. All of this turns the market into a casino with gamblers, rather than investors, who have all this counterfeit currency that they want to gamble with. This destroys any incentive and opportunity to build an actual viable real business, which is bad.
--
More government leads to the second outcome, less government and more freedoms lead to the first outcome.
I know where this comments is going to lead my/. account too.
How about Sarkozy stops trying to bail out his freaking banks and stops messing with the economy, which would stop the environment that creates the HFT in the first place?
I just had to do a little bit of this, I use plsql from the client, create a function that handles this case:...EXCEPTION WHEN unique_violation THEN...
it's actually jumping within 10ms more or less, after doing many tries I see different things come out all within 72 to 87ms, so I don't think it's that much different.
Of-course planner is what is important. If it doesn't do its job right, then it can send it all the way back to 30 seconds - that hurts.
newer code actually replaces some really crazy stuff
CASE WHEN sum(least(ri.total_price_before_discount, ri.total_price_after_discount))0 AND
sum(greatest(ri.total_price_before_discount, ri.total_price_after_discount))0 THEN
sum(greatest(ri.total_price_before_discount, ri.total_price_after_discount)) ELSE
sum(least(ri.total_price_before_discount, ri.total_price_after_discount)) END as total_sale,
with a much simpler version
sum(CASE WHEN ri.total_price_after_discount IS NULL THEN ri.total_price_before_discount ELSE ri.total_price_after_discount END) as total_sale,
which then weirdly reverses the numbers. The SQL you sent with this change becomes 78ms and the old with this change is 72ms.
Now you got me reading too many explain analyze lines.....
I really actually enjoy using PostgreSQL, really, much more than I should probably and much more than I have ever enjoyed using Oracle or DB2 or MSSQL (or progress 4GL aaaaaaa, kill me) in years that I had to use them.
As I said - a single SQL is not broken into smaller independent pieces to be executed by separate processors/threads. Separate connections/sql requests run in separate processes, but one sql request is not turned into many parallel executions.
Hey, I am just writing on my experiences, obviously people don't add stuff without reason.
As to WAL segments - I am not using this feature for streaming replication, just to have an immediate backup to a separate disk, no hot stand by, nothing like that. Imagine a bunch of stores, each one has a small server for management. Data gets transfered to the central servers but also gets backed up to a separate drive that's only used for backup, nothing else. No hot stand by processes waiting for the main process to die or anything. So yes, archive_timeout is used to force a dump of the data to the second disk. You may consider it 'obsolete', but it has a valid use case, and it's not for streaming to a separate database, just to be able to replay the data back in case main disk fails.
# in postgresql.conf shared_buffers = 500MB checkpoint_segments = 10 track_counts = on autovacuum_vacuum_scale_factor = 0.00002 # many small updates autovacuum_analyze_scale_factor = 0.00001 bytea_output='escape' # still problems with other types
## restart db
/usr/local/pgsql/bin/psql -d dbname -U user < model.ddl
I address all of these shortcomings that I am writing about here within the application.
Of-course it's much simpler for me to do from application perspective, because I know what the business logic is, so I break SQLs into pieces that can run in parallel, then I execute them in multiple connections against the database (thread or process per connection), and then I merge data as it comes back. This speeds up execution dramatically, not even close to what a single serial SQL can do.
As to adding more machines to the cluster - again, in the application level I have to split data logically into separate instances, application knows where to go for different segments of data, so this is not transparent to the application of-course, it must know where different data is.
Slashdot Mirror
why should the bank collect interest on money they borrowed from the people's government for next to nothing?
- where did you read my endorsement of such a deal?
I am completely AGAINST government meddling with economics and currency. Banks must not be bailed out and stimulated by government lending, they must survive on their own by providing customers with products that make it beneficial for the customers to lend their money to the banks!
When you put your money into a bank, you are not just giving it to them for safekeeping (or you can do that with a safety deposit box, or only holding cash in checking account, but this doesn't even guarantee that your money isn't used by the bank for loans), but you are giving them a resource, a reserve, which they can then lend out. As long as there is no bank run, bank can make loans based on the reserves it has that come from depositors.
FDIC made it so that the bank customers stopped caring about the business practices that banks are engaged in. So instead of choosing a bank and a plan based on risk aversion, bank customers only chose banks based on proximity to their house and maybe based on the interest that they could get while their money was in savings accounts.
Government regulation in form of FDIC in this case created the moral hazard where customers of care more about which toaster brand they are going to buy rather than which bank they will lend their money to.
Funny thing is is now that some banks got the bail out money, they are now charging reverse interest on the money you hold there (negative real interest rates) based on the fact that everybody know that the moral hazard is there, so if there is another financial collapse (and it's coming), those banks WILL BE BAILED OUT AGAIN. Of-course this can only continue until the government itself collapses because the currency collapses and nobody can bail out USA with all its debts and no production capacity.
Now that they can borrow from the fed for next to no interest and we can only benefit if we pay vastly inflated interest on bank loans, they have turned nasty.
- banks needed to fail.
When I write comments that explain how wrong the monetary policy of money destruction is, I get moderated in ways, as if I am proposing that everybody starts molesting children and kittens, so now I decided to write more in the journal instead.
Capitalism is only interested in maximising short term profits.
This is false, I will take a great caution to explain why, caution, because it is NOT popular view on /.
As an individual person I am interested in being able to live a long and prosperous life. I may absolutely FAIL in doing that, but it's the goal. To be able to lead a life that is prosperous, I do think about long term consequences of my investment, my actions and work.
Were I an individual person, who had unrestricted access to government and ability to "borrow" from government at 0% interest (that's why borrowing is in quotes), then it would be in my best interest to borrow as much as possible without any restraints and to attempt to gamble with that money instead of trying to invest it, because though the money is given to me at 0% interest, I may have to (maybe) return the principal at some point in time.
Free money makes people gamble and take great risks.
Investing your own money makes people understand that there is risk.
I did write about the reasons for HFT here and about free money and it applies to thinking of all business in economies, that are this regulated, this inflated, this taxed and this subsidized.
There is no reason to take a long term look at things, when there is gambling going on all around. There is no reason to pay dividends and there is no reason to expect dividends, with these levels of inflation. There is no reason to think beyond the next quarter, because the company is broke today, it's on life line extended by government support, tomorrow this blood line may be cut and then the company will die. Everybody knows about it, nobody admits it.
Some people are talking, but they are not taken seriously as always.
However, it's pretty hard to deny that an alternative operating system that's fully compatible with Windows applications will not be commercially viable.
- BS. I won't be, because there IS already an alternative to Windows. It's pirated Windows and it will always be the preferred alternative to those, who want Windows, don't want to pay for it, while not interested in switching to half a dozen of other options, including Apple, GNU/Linux/Unix, whatever.
The big issue with failures like Solyndra is that there was no transparency and no accountability. That says a lot more about the Obama administration than it does about government involvement in backing startups.
- there is NO SUCH THING as accountability when it comes to money that comes out of the printing presses by the very definition of the fact, of where the 'money' came from.
By the way, my original comment was in no way a 'flamebait', but again, /. moderation is broken.
To reply to your comment: Yuri Gagarin and the entire space race was funded by using basically what amounts to slave labor in the former USSR. I should know, I was born there. Most of the country's resources was directed to military spending, space race, and whatever dust that could be thrown into the people's eyes, just to make it look like something worked.
As to Neil Armstrong - SS fund was raided for that and to what purpose? How much private enterprise innovation was stifled and diverted to this waste of resources, putting a man into orbit, when it is in fact clear that we don't need people in space at this time because we don't have a purpose for them being there.
Nuclear energy has been subverted by government agenda, I talked about it here. It should be done privately to search for cheaper, more efficient ways of generating power.
As to ENIAC - there is always an argument that other priorities must be put on hold, when important wars are fought, and then all of the nation's resources are diverted to that. Unfortunately we fight these wars, but we fight them specifically because governments destroys free market and prevent economies from working, and then there are too many unemployed, which can be diverted by some perverted "leaders" to fight bloody wars. This is NOT a good endorsement of government power AT ALL.
Here are reasons as to why it makes NO SENSE to hire American workers.
Full Congressional meeting.
2006 speech predicting the incoming problems.
discussion on the job destruction act
Text submitted to Congressional committee before the meeting.
Governments funding of projects, any projects, is mis-allocation of resources. If the project in question has any reason to exist, then there would be private funding for it, private lending, private interest.
Government can push agenda, but they can't make it work nor should they try.
Either there is a reason for something to exist in the market or there isn't. Government commanding reasons does not work.
Peter Schiff's Testimony to the Committee starts at minute 31.
Then there is question/answer session.
PDF
Government Oversight Committee
Obama's Jobs Destruction Act
In his speech Obama didn't say "stimulus" once. He wants to stay away from that word, last stimulus was a failure and unpopular.
Of-course deficits that finance the stimulus destroy more jobs than the tax cuts create.
None of it is paid for, cuts from future increases is not paying for anything, but there is net increase in deficit (and it's underestimated) 450 Billion USD year 2011.
Debt ceiling now will have to be raised again obviously next year, because this is 450Billion that are not accounted for in the last debt ceiling increase.
Tax credit for hiring people who are unemployed for more than 6 months. So now employers will have incentive NOT to hire anybody who hasn't been unemployed for 6 months :)
More unemployment!
7.25 - is minimum wage. 4000USD is given as tax credit, and you have to keep the person for 6 months minimum.
So hiring somebody at 7.25USD/hour and given 4000USD credit reduces minimum wage to 3.40USD/hour.
Minimum wage will be reduced, and so there WILL be more employment, but some people will be FIRED to give more space for new minimum wage hires because of the tax credit.
Bill will make it illegal to discriminate against long term unemployed. So what will happen is that people who are long term unemployed will NOT be interviewed. Who wants to have a lawsuit on their hands?
If anybody is unemployed for 4-5 months, now there is a reason not to hire them right away, to interview them and to keep them on UI for another 1-2 months and then to get the tax credit once they are at 6 months unemployment time.
Of-course fire anybody after 6 months, get new hires. It's all going to be minimum wage jobs, nobody who is hiring people at good salaries will care about 4000USD tax credit.
The 1 year cut in SS payroll tax will make SS that much more broke (it's broke now, but it can be made worse.)
To pretend that there is SS "trust fund", gov't will borrow money, put it into "trust fund", borrow from "trust fund" and spend it on stimulus. Many lies all around.
If you hire a returning veteran, the tax credit is 5600USD. Applied to minimum wage, it makes minimum wage 1.87USD/hour. This creates huge government incentive to have very high turnover.
Payroll taxes will be lost on existing jobs, ha ha. They'll have to print more money.
For returning veterans with injuries (wounded warrior), you get 9600USD tax credit. For a minimum wage job this makes the pay a NEGATIVE ONE :) -1.98USD/hour.
Hire as many wounded warriors as possible immediately and just pay them, but the employer gets 1.98/hour for every new hire. Hire all of them and have the Fed monetize the debt that will be created paying these tax credits.
How do you like them apples?
the disasters of beginning of this century include XML. In everything. "Agile" development. IE6 and ActiveX controls. IBM Lotus Notes. "Visual" programming, especially mixed with UML and RUP. Passing parameters from URLs directly to database layers as input without sanitation. Not checking data structure boundaries and sizes. Using root for everything, this one is especially nice when combined with a password, that is used for everything in a corporation. Especially when password is some variation of "adminpass1". Buying more and more BEA/Oracle licenses to set up more and more nodes where the real speed problem could be solved with very little code on a single machine, but obviously that's not sexy and doesn't buy perks. Having no testing cycles, never having enough testing, doing irrelevant testing (this even includes automated testing, which can be huge, but still irrelevant).
Producing huge meaningless documents that end up copied in email to everybody, but eventually don't get read by anybody who they should address, having template "Architecture", where past documents are copied, whatever names are replaced, no thought is given to the project and all the details are left over to the team for the time of implementation. This, especially when combined with time lines that give 80% time to meetings/architecture, 12% time to all of the development combined and then whatever remains is running around like chickens with heads cut off, from users to testers to admins, trying to get any of it working.
All of the above and more, much more are disasters.
But the real disaster here is that pathetic article that this story refers to.
Butterflies and all... real programmers hack every day to be a programmer day, it's not a day if it ain't hacked to be day of programmer.
wish I didn't know this, it's a sad sad day :/
There is nothing wrong with fractional reserve banking as long as the banks actually do due diligence, so that money that they loan out is for business creation based on sound ideas and planning and not for gambling or buying consumer products.
Building new businesses does create wealth for everybody. If a person takes a loan and provides collateral, and builds a business with that loan and creates products that the market wants and repays the loan, then here is what happens:
1. Loan is lent out and then interest is paid, loan is repaid. Investors have made money, which is good.
2. A new business is started, products are made that the market wants to buy, which makes everybody wealthier via production of these products, which is good.
3. The businessman found a way to generate profit and increase his own wealth, so now he is better off financially, which is good.
--
Here is the problem with the way things are done now:
1. Politicians get elected based on promises of free lunch, to whoever, be it the more SS or be it more corporate welfare, at the end this helps the politician to make some cash and it always helps some special interest, while growing government bigger, which is bad.
2. The bigger the government, the more it spends, and it's impossible to shrink it, and when economy slows down and even shrinks, government only grows via taxes, loans and then debasing of money, which is bad.
3. National bank prints fiat currency to subsidize government spending, which adds to the debt and eventually prevents the economy from being fixed, because the bigger the debt, the less likely it is that interest rates will be let go by the government, because the bigger the debt, the more expensive it is to service it. At some point inflation becomes unbearable and currency can fail, which is bad.
4. Some people make a lot of money on the process of currency debasing, these are the people who are close to the government circles, they are making policy that helps them, but destroys currency and economy in the process, which is bad.
5. All of this turns the market into a casino with gamblers, rather than investors, who have all this counterfeit currency that they want to gamble with. This destroys any incentive and opportunity to build an actual viable real business, which is bad.
--
More government leads to the second outcome, less government and more freedoms lead to the first outcome.
I know where this comments is going to lead my /. account too.
How about Sarkozy stops trying to bail out his freaking banks and stops messing with the economy, which would stop the environment that creates the HFT in the first place?
Here is the explanation to the phenomena of HFT.
I just had to do a little bit of this, I use plsql from the client, create a function that handles this case: ...EXCEPTION WHEN unique_violation THEN ...
For god sake? You think god would like me to use packages instead?
it's actually jumping within 10ms more or less, after doing many tries I see different things come out all within 72 to 87ms, so I don't think it's that much different.
Of-course planner is what is important. If it doesn't do its job right, then it can send it all the way back to 30 seconds - that hurts.
newer code actually replaces some really crazy stuff
CASE WHEN sum(least(ri.total_price_before_discount, ri.total_price_after_discount))0 AND
sum(greatest(ri.total_price_before_discount, ri.total_price_after_discount))0 THEN
sum(greatest(ri.total_price_before_discount, ri.total_price_after_discount)) ELSE
sum(least(ri.total_price_before_discount, ri.total_price_after_discount)) END as total_sale,
with a much simpler version
sum(CASE WHEN ri.total_price_after_discount IS NULL THEN ri.total_price_before_discount ELSE ri.total_price_after_discount END) as total_sale,
which then weirdly reverses the numbers. The SQL you sent with this change becomes 78ms and the old with this change is 72ms.
Now you got me reading too many explain analyze lines.....
The old one that's posted in the bug report runs in 83ms right now, yours runs in 74ms, so it's a nice gain.
However this was code from a couple months back and it's constantly changing, but thanks.
It's just not true.
I really actually enjoy using PostgreSQL, really, much more than I should probably and much more than I have ever enjoyed using Oracle or DB2 or MSSQL (or progress 4GL aaaaaaa, kill me) in years that I had to use them.
As I said - a single SQL is not broken into smaller independent pieces to be executed by separate processors/threads. Separate connections/sql requests run in separate processes, but one sql request is not turned into many parallel executions.
Hey, I am just writing on my experiences, obviously people don't add stuff without reason.
As to WAL segments - I am not using this feature for streaming replication, just to have an immediate backup to a separate disk, no hot stand by, nothing like that. Imagine a bunch of stores, each one has a small server for management. Data gets transfered to the central servers but also gets backed up to a separate drive that's only used for backup, nothing else. No hot stand by processes waiting for the main process to die or anything. So yes, archive_timeout is used to force a dump of the data to the second disk. You may consider it 'obsolete', but it has a valid use case, and it's not for streaming to a separate database, just to be able to replay the data back in case main disk fails.
that's part of install procedure I have for little boxes, that go into separate stores in a chain. They have maybe 2GB, and shmall is not set at all.
For the central servers the settings are different altogether, it's also 48-96GB RAM.
I tried these guys (just noticed they switched from com to nl, interesting, wtf?
They are not as refined as the big ones, but they provide bang for the buck.
I prefer source and my script
I address all of these shortcomings that I am writing about here within the application.
Of-course it's much simpler for me to do from application perspective, because I know what the business logic is, so I break SQLs into pieces that can run in parallel, then I execute them in multiple connections against the database (thread or process per connection), and then I merge data as it comes back. This speeds up execution dramatically, not even close to what a single serial SQL can do.
As to adding more machines to the cluster - again, in the application level I have to split data logically into separate instances, application knows where to go for different segments of data, so this is not transparent to the application of-course, it must know where different data is.