Re: [ADMIN] Query performance difference
It may be worth-wile to generate an explain plan http://www.postgresql.org/docs/8.3/interactive/sql-explain.html From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of c k Sent: Thursday, August 21, 2008 2:49 PM To: [EMAIL PROTECTED]; pgsql-admin@postgresql.org Subject: [ADMIN] Query performance difference Hello, I have a question regarding query performance from two pgsql applications. PGadmin III 1.8 and Navicat for postgresql 8. Both connected to same server on local machine 8.3 and runs a same query for appox. 1,60,000 rows with one min, one max and addition of the min and max values on two tables joined on an integer column gives different query execution times with noticible difference. PGAdmin gives 9350ms and Navicat gives 2110ms. Why? What will be the difference? Is it in their query execution methods, with/without indexes etc?. Thanks CPK ___ The information in this email or in any file attached hereto is intended only for the personal and confiden- tial use of the individual or entity to which it is addressed and may contain information that is propri- etary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communica- tion is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email trans- mission cannot be guaranteed to be secure or error- free. P6070214
Re: [ADMIN] Catalog
There are tools that allow you to reverse engineer schemas.. or to generate ERD's .. visio comes to mind. It works on odbc connections. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Sergio Gabriel Rodriguez Sent: Wednesday, July 23, 2008 10:32 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Catalog Hi for all, is possible to get PostgreSQL Catalog EER diagram? where can I get it? regards Sergio Gabriel Rodriguez -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ___ The information in this email or in any file attached hereto is intended only for the personal and confiden- tial use of the individual or entity to which it is addressed and may contain information that is propri- etary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communica- tion is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email trans- mission cannot be guaranteed to be secure or error- free. P6070214 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] Query
These docs are pretty good... .. release notes.. http://www.postgresql.org/docs/8.3/static/release.html From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of kartik Sent: Friday, June 27, 2008 12:33 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] Query Hello there, Can anyone tell me the differences between postgresql 8.1 and postgresql 8.3.3 Thanks Waiting for your reply ___ The information in this email or in any file attached hereto is intended only for the personal and confiden- tial use of the individual or entity to which it is addressed and may contain information that is propri- etary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communica- tion is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email trans- mission cannot be guaranteed to be secure or error- free. P6070214
Re: [ADMIN] How is the default encoding determined
This looks like what you are looking for. http://www.postgresql.org/docs/8.2/static/app-initdb.html The character set encoding can be set separately for a database when it is created. initdb determines the encoding for the template1 database, which will serve as the default for all other databases. To alter the default encoding use the --encoding option. More details can be found in Section 21.2. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Geoffrey Sent: Thursday, June 12, 2008 11:21 AM To: Postgres-Admin list Subject: [ADMIN] How is the default encoding determined I recently was bitten by having two servers where the database encoding was different. When I do an 'initdb' how does it determine the 'default' encoding? -- Until later, Geoffrey Those who would give up essential Liberty, to purchase a little temporary Safety, deserve neither Liberty nor Safety. - Benjamin Franklin -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin ___ The information in this email or in any file attached hereto is intended only for the personal and confiden- tial use of the individual or entity to which it is addressed and may contain information that is propri- etary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communica- tion is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email trans- mission cannot be guaranteed to be secure or error- free. P6070214 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
Re: [ADMIN] how i can restrict databaseusers ?
how i can restrict dbusers ( user's db size, cpu time)? http://www.enterprisedb.com/documentation/kernel-resources.html#AEN32652 how i can monitoring this parameters perl /proc maybe.. From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of pronix pronix Sent: Tuesday, May 20, 2008 8:57 AM To: pgsql-admin@postgresql.org Subject: [ADMIN] how i can restrict databaseusers ? hello ___ The information in this email or in any file attached hereto is intended only for the personal and confiden- tial use of the individual or entity to which it is addressed and may contain information that is propri- etary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communica- tion is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email trans- mission cannot be guaranteed to be secure or error- free. P6070214
[ADMIN] EDB database link to Oracle
When using a database link in Postgres Plus AS 8.3 to an Oracle instance I receive... SQL create database link ezdev connect to pguser identified by pguser 2 using oci '//devdb:1521/ezdev' 3 ; Database Link created. SQL select * from [EMAIL PROTECTED]; ERROR near line 1: unable to load OCI library: Access is denied. Im on windows the enterprisedb user is an Administrator. What am I missing? Thanks -TaS ___ The information in this email or in any file attached hereto is intended only for the personal and confiden- tial use of the individual or entity to which it is addressed and may contain information that is propri- etary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communica- tion is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email trans- mission cannot be guaranteed to be secure or error- free. P6070214
Re: [ADMIN] EDB database link to Oracle
Thanks for the head up. I was just informed. -Original Message- From: Joshua D. Drake [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 13, 2008 8:56 AM To: Travis Smith Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] EDB database link to Oracle Travis Smith wrote: When using a database link in Postgres Plus AS 8.3 to an Oracle instance I receive... You should contact EnterpriseDB for support with their products. Joshua D. Drake ___ The information in this email or in any file attached hereto is intended only for the personal and confiden- tial use of the individual or entity to which it is addressed and may contain information that is propri- etary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communica- tion is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email trans- mission cannot be guaranteed to be secure or error- free. P6070214 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
[ADMIN] Postgres cluster on Solaris
Hello All, I am interested in running Postgres on Solaris using SunCluster. I am hoping that someone this list has experience with this configuration. To be honest I am having a difficult time understanding the concept of Postgres clusters. I originally began looking at Linux HA, I would like to run on Suns' T5220 and I at a loss to how well this setup runs. Thanks, Travis Smith ___ The information in this email or in any file attached hereto is intended only for the personal and confiden- tial use of the individual or entity to which it is addressed and may contain information that is propri- etary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communica- tion is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email trans- mission cannot be guaranteed to be secure or error- free. P6070214
[ADMIN] Postgres Cluster on Solaris
Hello All, I am interested in running Postgres on Solaris using SunCluster. I am hoping that someone this list has experience with this configuration. To be honest I am having a difficult time understanding the concept of Postgres clusters. I originally began looking at Linux HA, I would like to run on Suns' T5220 and I at a loss to how well this setup runs. Thanks, Travis Smith ___ The information in this email or in any file attached hereto is intended only for the personal and confiden- tial use of the individual or entity to which it is addressed and may contain information that is propri- etary and confidential. If you are not the intended recipient of this message you are hereby notified that any review, dissemination, distribution or copying of this message is strictly prohibited. This communica- tion is for information purposes only and should not be regarded as an offer to sell or as a solicitation of an offer to buy any financial product. Email trans- mission cannot be guaranteed to be secure or error- free. P6070214