Re: [GENERAL] Plug-pull testing worked, diskchecker.pl failed

2012-10-27 Thread Chris Angelico
On Sat, Oct 27, 2012 at 4:26 PM, Greg Smith g...@2ndquadrant.com wrote: In general, through, diskchecker.pl is the more sensitive test. If it fails, storage is unreliable for PostgreSQL, period. It's good that you've followed up by confirming the real database corruption implied by that is

Re: [GENERAL] PostgresQL intallation error

2012-10-27 Thread Raul Feliu
I have windows vista. I tried to run the installer in admin mode and I disabled UAC. Still having the same problem. Any other help will be wellcome :) Thanks again, and thanks Xiong He. From: iih...@qq.com To: raulfp...@hotmail.com; pgsql-general@postgresql.org Subject: Re: [GENERAL]

Re: [GENERAL] PostgresQL intallation error

2012-10-27 Thread Gavin Flower
On 27/10/12 23:30, Raul Feliu wrote: I have windows vista. I tried to run the installer in admin mode and I disabled UAC. Still having the same problem. Any other help will be wellcome :) Thanks again, and thanks Xiong He.

Re: [GENERAL] Function Profiler in Postgre

2012-10-27 Thread Craig Ringer
On 10/27/2012 01:43 AM, D T wrote: Hi, I have many functions which i want to finetune. Is there any profiler available which i can use to check performance of function and finetune it. Since you haven't specified your PostgreSQL version, platform, the language the functions are written in, etc

Re: [GENERAL] PostgresQL intallation error

2012-10-27 Thread Xiong He
Can you copy C:\Users\Ral\AppData\Local\Temp\prerun_checks.vbs to another location and verify if it can run without any issue? Make sure Windows Script Host is installed. and .vbs is associated with it. -- ThanksRegards, Xiong He -- Original

[GENERAL] progress of PITR

2012-10-27 Thread Andreas Brandl
Hi, I'm currently doing a point in time recovery with a recovery_target_time set. As it takes quite a while, I was wondering if there is a way to see the progress in terms of 'realtime' somehow? Is there any way of getting the timestamp of the last replayed transaction or the like? I know

Re: [GENERAL] Improve MMO Game Performance

2012-10-27 Thread Torsten Zühlsdorff
Hello Arvind, the cyclic change idea is really marvellous , thank you You're welcome. :) but we store each round, because we need player actions for further analysis about game trends Normally the different analyze-forms and goals are known from the beginning. You could use a more

[GENERAL] Great site for comparing databases (or anything else)

2012-10-27 Thread Mike Christensen
Just came across this one: http://hammerprinciple.com/databases/items/mysql/postgresql mySQL is great for embedding in applications though? Have they not read Oracle's license? Mike

[GENERAL] PITR / progress

2012-10-27 Thread Andreas Brandl
Hi, I'm currently doing a point in time recovery with a recovery_target_time set. As it takes quite a while, I was wondering if there is a way to see the progress in terms of 'realtime' somehow? Is there any way of getting the timestamp of the last replayed transaction or the like? I know

Re: [GENERAL] Great site for comparing databases (or anything else)

2012-10-27 Thread Edson Richter
Em 27/10/2012 19:18, Mike Christensen escreveu: Just came across this one: http://hammerprinciple.com/databases/items/mysql/postgresql mySQL is great for embedding in applications though? Have they not read Oracle's license? Mike Sorry to say, this site is full of holes. The problem is

Re: [GENERAL] Great site for comparing databases (or anything else)

2012-10-27 Thread Stephen Cook
On 10/27/2012 5:18 PM, Mike Christensen wrote: Just came across this one: http://hammerprinciple.com/databases/items/mysql/postgresql mySQL is great for embedding in applications though? Have they not read Oracle's license? Does it say anywhere on that site if the people surveyed know both

Re: [GENERAL] Great site for comparing databases (or anything else)

2012-10-27 Thread Mike Christensen
It seems to be based on the honor system. When you click Rank, it asks you what databases you're familiar with. Then you can stack rank those databases across various questions. It's possible people could lie and say they know about mySQL and Postgres when in reality they don't, but hopefully

Re: [GENERAL] Great site for comparing databases (or anything else)

2012-10-27 Thread Gavin Flower
On 28/10/12 12:00, Stephen Cook wrote: On 10/27/2012 5:18 PM, Mike Christensen wrote: Just came across this one: http://hammerprinciple.com/databases/items/mysql/postgresql mySQL is great for embedding in applications though? Have they not read Oracle's license? Does it say anywhere on

Re: [GENERAL] Great site for comparing databases (or anything else)

2012-10-27 Thread Leif Biberg Kristensen
Søndag 28. oktober 2012 01.17.45 skrev Gavin Flower : Also note that for features that are obviously complicated or advanced, Postgres tends to a lot better than MySQL. It's like comparing BASIC to C. BASIC has a low threshold, but you will very quickly bump your head against the wall.

Re: [GENERAL] Great site for comparing databases (or anything else)

2012-10-27 Thread Gavin Flower
On 28/10/12 12:29, Leif Biberg Kristensen wrote: Søndag 28. oktober 2012 01.17.45 skrev Gavin Flower : Also note that for features that are obviously complicated or advanced, Postgres tends to a lot better than MySQL. It's like comparing BASIC to C. BASIC has a low threshold, but you will

Re: [GENERAL] Great site for comparing databases (or anything else)

2012-10-27 Thread Edson Richter
Em 28/10/2012 01:35, Gavin Flower escreveu: On 28/10/12 12:29, Leif Biberg Kristensen wrote: Søndag 28. oktober 2012 01.17.45 skrev Gavin Flower : Also note that for features that are obviously complicated or advanced, Postgres tends to a lot better than MySQL. It's like comparing BASIC to

Re: [GENERAL] Great site for comparing databases (or anything else)

2012-10-27 Thread Gavin Flower
On 28/10/12 16:52, Edson Richter wrote: Em 28/10/2012 01:35, Gavin Flower escreveu: On 28/10/12 12:29, Leif Biberg Kristensen wrote: Søndag 28. oktober 2012 01.17.45 skrev Gavin Flower : Also note that for features that are obviously complicated or advanced, Postgres tends to a lot better