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

[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 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.

MySQL, the BASIC of db engines?

regards, Leif


I have used both MySQL & Postgres: I feel a lot more comfortable with 
Postgres, as it seems to be both simpler and more sophisticated.  
MySQL has several DB engines for different purposes, Postgres has 
just one that appears to be more capable than the collection of 
features from all the MySQL DB engines combined.  In the last 12 
years I've gone looking for comparisons between them 3 times; and 
each time, Postgres comes out better overall.




And I must add: even using InnoDB, MySQL allows violation of 
relational integrity (just put it under heavy transactional load).
I've suffered this pain in the past even with MySQL 5.1. This problem 
does not happens with PostgreSQL.
The only occasion I had duplications in PostgreSQL was during a heavy 
data load. At that time, I used RSync to copy data to another server 
with the command:


rsync -azv /var/lib/pgsql/9.1/data root@127.0.0.1:/var/lib/pgsql/9.1/


Do you see my mistake above? Yes, this causes duplicate records (and 
after some time, complete database corruption in PostgreSQL).
Is just db admin stupidity (I can tell, because I was caused by my 
self). Would be nice if we can shield PostgreSQL against my personal 
silliness.


Edson



Cheers,
Gavin





My tools are not good enough to cope with my own ineptitude - give me 
better tools!  :-)




--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[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 C. BASIC has a low threshold, but you 
will very

quickly bump your head against the wall.

MySQL, the BASIC of db engines?

regards, Leif


I have used both MySQL & Postgres: I feel a lot more comfortable with 
Postgres, as it seems to be both simpler and more sophisticated.  
MySQL has several DB engines for different purposes, Postgres has just 
one that appears to be more capable than the collection of features 
from all the MySQL DB engines combined.  In the last 12 years I've 
gone looking for comparisons between them 3 times; and each time, 
Postgres comes out better overall.




And I must add: even using InnoDB, MySQL allows violation of relational 
integrity (just put it under heavy transactional load).
I've suffered this pain in the past even with MySQL 5.1. This problem 
does not happens with PostgreSQL.
The only occasion I had duplications in PostgreSQL was during a heavy 
data load. At that time, I used RSync to copy data to another server 
with the command:


rsync -azv /var/lib/pgsql/9.1/data root@127.0.0.1:/var/lib/pgsql/9.1/


Do you see my mistake above? Yes, this causes duplicate records (and 
after some time, complete database corruption in PostgreSQL).
Is just db admin stupidity (I can tell, because I was caused by my 
self). Would be nice if we can shield PostgreSQL against my personal 
silliness.


Edson



Cheers,
Gavin






--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[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 very
quickly bump your head against the wall.

MySQL, the BASIC of db engines?

regards, Leif


I have used both MySQL & Postgres: I feel a lot more comfortable with 
Postgres, as it seems to be both simpler and more sophisticated.  MySQL 
has several DB engines for different purposes, Postgres has just one 
that appears to be more capable than the collection of features from all 
the MySQL DB engines combined.  In the last 12 years I've gone looking 
for comparisons between them 3 times; and each time, Postgres comes out 
better overall.



Cheers,
Gavin


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[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.

MySQL, the BASIC of db engines?

regards, Leif


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[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 that site if the people surveyed know both 
databases well enough to judge these questions? I can't find anything 
about that, and the site also ranks gin and martial arts, so I'm not 
sure sure it has much value.


-- Stephen


Probably a very useful site to note people's 'perceptions' - as 
perceptions tend to influence peoples decisions, especially when people 
feel overwhelmed by technical decision making.


Also note that for features that are obviously complicated or advanced, 
Postgres tends to a lot better than MySQL.


For the above reasons, I think it may be of value to the pg community to 
look at it in order to consider what are marketing messages should be.



Cheers,
Gavin


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[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 the overall results would be accurate.  Actually one of the
reasons I posted it here was because I was hoping more database experts
could weigh in with their opinions..

Mike

On Sat, Oct 27, 2012 at 4:00 PM, 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 that site if the people surveyed know both
> databases well enough to judge these questions? I can't find anything about
> that, and the site also ranks gin and martial arts, so I'm not sure sure it
> has much value.
>
> -- Stephen
>

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

[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 
databases well enough to judge these questions? I can't find anything 
about that, and the site also ranks gin and martial arts, so I'm not 
sure sure it has much value.


-- Stephen


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[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 explained in 
section "I am familiar with this database".
How would people who don't know something be allowed to emit a judgment 
about the compared products?


Edson



--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] PITR / progress

[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 that I can look 
at the creation timestamp of the xlog currently being replayed, but this might 
be prone to some error (due to archiving to remote destination / moving xlogs 
around).

Thank you!

Regards,
Andreas


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

[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

Re: [GENERAL] Improve MMO Game Performance

[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 compact format for the analysis, which 
is optimized for this.


Also: if you just need this data for further analysis: don't store them
together with the actual game data! Big Performance NO GO!

Set up a second database-server! It can be a simple and even slow 
machine. Cache the round-data compressed in RAM or another fast location 
and import them from there in a steady flow into the second 
database-server. Their you can do your heavy analyze at any time without 
annoying your users!
(You can even use more than a second server to do the analyze in 
parallel and sum up the aggregated data. Most the analyze must not be 
actual, so it doesn't bother if it takes some hours more. It is a big 
win for your user-performance)


Greetings from Germany,
Torsten


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

[GENERAL] progress of PITR

[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 that I can look 
at the creation timestamp of the xlog currently being replayed, but this might 
be prone to some error (due to archiving to remote destination / moving xlogs 
around).

Thank you!

Regards,
Andreas


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgresQL intallation error

[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.

--
Thanks&Regards,
Xiong He





 




-- Original --
From:  "Raul Feliu";
Date:  Sat, Oct 27, 2012 06:30 PM
To:  "pgsql-general"; 

Subject:  Re: [GENERAL] PostgresQL intallation error



  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] PostgresQL intallation error
Date: Sat, 27 Oct 2012 11:04:31 +0800

Seems you are using Win7 or above environment.
You perhaps need to run the installer in administrator mode. An alternative way 
is to disable UAC.

--
Thanks&Regards,
Xiong He





-- Original --
From:  "Raul Feliu";
Date:  Sat, Oct 27, 2012 04:04 AM
To:  "pgsql-general"; 

Subject:  [GENERAL] PostgresQL intallation error



  
Hi,

I am facing a problem when I try to install PostgresQL (version 9.2.1.). I get 
the following message:

"Unable to write inside TEMP environment variable path"

I need some help with this as I've read lots of posts about how to solve the 
problem and I have not succeed.

Here I forward to you the bitrock_installer text.

---
Log started 10/26/2012 at 19:06:53
Preferred installation mode : qt
Trying to init installer in mode qt
Mode qt successfully initialized
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Data 
Directory. Setting variable iDataDirectory to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Base 
Directory. Setting variable iBaseDirectory to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Service ID. 
Setting variable iServiceName to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Service 
Account. Setting variable iServiceAccount to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Super User. 
Setting variable iSuperuser to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Branding. 
Setting variable iBranding to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Version. 
Setting variable brandingVer to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Shortcuts. 
Setting variable iShortcut to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 
DisableStackBuilder. Setting variable iDisableStackBuilder to empty value
[19:07:01] Existing base directory: 
[19:07:01] Existing data directory: 
[19:07:01] Using branding: PostgreSQL 9.2
[19:07:01] Using Super User: postgres and Service Account: NT 
AUTHORITY\NetworkService
[19:07:01] Using Service Name: postgresql-9.2
Executing cscript //NoLogo "C:\Users\Raül\AppData\Local\Temp\prerun_checks.vbs"
Script exit code: 1

Script output:
 Error de CScript: No se encuentra el motor de secuencias de comandos 
"VBScript" para la secuencia 
"C:\Users\Ral\AppData\Local\Temp\prerun_checks.vbs".

Script stderr:
 Program ended with an error exit code

Error running cscript //NoLogo 
"C:\Users\Raül\AppData\Local\Temp\prerun_checks.vbs" : Program ended with an 
error exit code


I'm not a computer expert, so I'll need detailed steps to solve the problem.

Thanks in advance

Re: [GENERAL] Function Profiler in Postgre

[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 it's rather hard to say.

For PL/PgSQL check out the PL/PgSQL debugger.

There's also the `auto_explain` contrib module.

--
Craig Ringer


-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Re: [GENERAL] PostgresQL intallation error

[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.


From: iih...@qq.com
To: raulfp...@hotmail.com; pgsql-general@postgresql.org
Subject: Re: [GENERAL] PostgresQL intallation error
Date: Sat, 27 Oct 2012 11:04:31 +0800

Seems you are using Win7 or above environment.
You perhaps need to run the installer in administrator mode. An 
alternative way is to disable UAC.


--
Thanks&Regards,
Xiong He

-- Original --
*From: * "Raul Feliu";
*Date: * Sat, Oct 27, 2012 04:04 AM
*To: * "pgsql-general";
*Subject: * [GENERAL] PostgresQL intallation error


Hi,

I am facing a problem when I try to install PostgresQL (version 
9.2.1.). I get the following message:


"Unable to write inside TEMP environment variable path"

I need some help with this as I've read lots of posts about how to 
solve the problem and I have not succeed.


Here I forward to you the bitrock_installer text.

---
Log started 10/26/2012 at 19:06:53
Preferred installation mode : qt
Trying to init installer in mode qt
Mode qt successfully initialized
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 
Data Directory. Setting variable iDataDirectory to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 
Base Directory. Setting variable iBaseDirectory to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 
Service ID. Setting variable iServiceName to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 
Service Account. Setting variable iServiceAccount to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 
Super User. Setting variable iSuperuser to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 
Branding. Setting variable iBranding to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 
Version. Setting variable brandingVer to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 
Shortcuts. Setting variable iShortcut to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 
DisableStackBuilder. Setting variable iDisableStackBuilder to empty value

[19:07:01] Existing base directory:
[19:07:01] Existing data directory:
[19:07:01] Using branding: PostgreSQL 9.2
[19:07:01] Using Super User: postgres and Service Account: NT 
AUTHORITY\NetworkService

[19:07:01] Using Service Name: postgresql-9.2
Executing cscript //NoLogo 
"C:\Users\Raül\AppData\Local\Temp\prerun_checks.vbs"

Script exit code: 1

Script output:
 Error de CScript: No se encuentra el motor de secuencias de comandos 
"VBScript" para la secuencia 
"C:\Users\Ra?l\AppData\Local\Temp\prerun_checks.vbs".


Script stderr:
 Program ended with an error exit code

Error running cscript //NoLogo 
"C:\Users\Raül\AppData\Local\Temp\prerun_checks.vbs" : Program ended 
with an error exit code



I'm not a computer expert, so I'll need detailed steps to solve the 
problem.


Thanks in advance

Upgrade to a Linux distribution?  :-)

I guess I'm privileged, almost all my work is now in a Linux environment!

Re: [GENERAL] PostgresQL intallation error

[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] PostgresQL intallation error
Date: Sat, 27 Oct 2012 11:04:31 +0800

Seems you are using Win7 or above environment.
You perhaps need to run the installer in administrator mode. An alternative way 
is to disable UAC.

--Thanks&Regards,Xiong He
-- Original --From:  "Raul 
Feliu";Date:  Sat, Oct 27, 2012 04:04 AMTo:  
"pgsql-general"; Subject:  [GENERAL] PostgresQL 
intallation error





Hi,

I am facing a problem when I try to install PostgresQL (version 9.2.1.). I get 
the following message:

"Unable to write inside TEMP environment variable path"

I need some help with this as I've read lots of posts about how to solve the 
problem and I have not succeed.

Here I forward to you the bitrock_installer text.

---
Log started 10/26/2012 at 19:06:53
Preferred installation mode : qt
Trying to init installer in mode qt
Mode qt successfully initialized
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Data 
Directory. Setting variable iDataDirectory to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Base 
Directory. Setting variable iBaseDirectory to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Service ID. 
Setting variable iServiceName to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Service 
Account. Setting variable iServiceAccount to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Super User. 
Setting variable iSuperuser to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Branding. 
Setting variable iBranding to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Version. 
Setting variable brandingVer to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 Shortcuts. 
Setting variable iShortcut to empty value
Could not find registry key 
HKEY_LOCAL_MACHINE\SOFTWARE\PostgreSQL\Installations\postgresql-9.2 
DisableStackBuilder. Setting variable iDisableStackBuilder to empty value
[19:07:01] Existing base directory: 
[19:07:01] Existing data directory: 
[19:07:01] Using branding: PostgreSQL 9.2
[19:07:01] Using Super User: postgres and Service Account: NT 
AUTHORITY\NetworkService
[19:07:01] Using Service Name: postgresql-9.2
Executing cscript //NoLogo "C:\Users\Raül\AppData\Local\Temp\prerun_checks.vbs"
Script exit code: 1

Script output:
 Error de CScript: No se encuentra el motor de secuencias de comandos 
"VBScript" para la secuencia 
"C:\Users\Ral\AppData\Local\Temp\prerun_checks.vbs".

Script stderr:
 Program ended with an error exit code

Error running cscript //NoLogo 
"C:\Users\Raül\AppData\Local\Temp\prerun_checks.vbs" : Program ended with an 
error exit code


I'm not a computer expert, so I'll need detailed steps to solve the problem.

Thanks in advance