Re: [GENERAL] masking the code

types of security (i.e. the 3 foot high fence) this is really just a deterrent to most people who either aren't capable of reverse engineering or are just not interested in the first place. s/is declared/is NOT declared/g :) -- Jonah H. Harris, Senior DBA myYearbook.com

Re: [GENERAL] Need help using function

-structure.html -- Jonah H. Harris, Senior DBA myYearbook.com

Re: [GENERAL] does postgres has the same limitation as MySQL?

://dev.mysql.com/doc/refman/5.0/en/index-merge-optimization.html -- Jonah H. Harris, Senior DBA myYearbook.com

Re: [GENERAL] pl/proxy and sequence generation

the sequence on your main PL/Proxy hub and call the function with: SELECT some_func(nextval('my_seq'), foo, bar, baz, ...); -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http

Re: [GENERAL] How are locks managed in PG?

On Mon, Dec 22, 2008 at 7:37 AM, Geoffrey li...@serioustechnology.com wrote: I still haven't seen a post regarding the Oracle scalability issue. Where is the data?? You mean the PG scalability issue in comparison to Oracle? -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql

Re: [GENERAL] How are locks managed in PG?

On Mon, Dec 22, 2008 at 8:22 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: The other difference is that I said it jokingly, whereas you (Jonah) seem to be bitter about the whole matter. Well, it wasn't clear and I was just in a generally bad mood. Usually you'd add a :) at the end,

Re: [GENERAL] How are locks managed in PG?

. -- Jonah H. Harris, Senior DBA myYearbook.com -- 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] How are locks managed in PG?

. -- Jonah H. Harris, Senior DBA myYearbook.com -- 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] How are locks managed in PG?

description on which strategy PG applies. None of the above. We're smarter than everyone else. Which is why Oracle's locks are more scalable than PG's? -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your

Re: [GENERAL] How are locks managed in PG?

On Sun, Dec 21, 2008 at 9:42 PM, David Fetter da...@fetter.org wrote: On Sun, Dec 21, 2008 at 08:46:15PM -0500, Jonah H. Harris wrote: On Fri, Dec 19, 2008 at 7:49 AM, Alvaro Herrera alvhe...@commandprompt.com wrote: Oracle on the other hand stores the lock information directly in the data

Re: [GENERAL] How are locks managed in PG?

I get better service and such from pg users / developers than anywhere else. I'd agree with that. Unless you have lots of $$$ and/or know someone at the commercial companies, it takes a lot of work to get a hold of someone knowledgeable. -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent

Re: [GENERAL] How are locks managed in PG?

On Sun, Dec 21, 2008 at 11:02 PM, Scott Marlowe scott.marl...@gmail.com wrote: The difference is HE put forth an opinion about the pg developers being smarter, but you put forth what seems like a statement of fact with no evidence to back it up. One is quite subjective and open for debate on

Re: [GENERAL] converter pgplsql funcion

read about it and using it here: http://64.233.169.132/search?q=cache:ko5k7eHQvrgJ:kb.cospa-project.org/retrieve/4051/chapter6.pdf+%22Bridging+Tool:+OraToPG%22hl=enct=clnkcd=1gl=us -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org

Re: [GENERAL] MVCC and index-only read

all you needed to say :) /response -- Jonah H. Harris, Senior DBA myYearbook.com -- 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] MVCC and index-only read

(the attribute is covered by the index). Oracle sometimes satisfies it with an index fast full scan, but not always; it depends on the cost of other access methods and/or what Oracle believes is currently in cache. -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql-general mailing list (pgsql

Re: [GENERAL] MVCC and index-only read

are essentially clustered indexes, and they're not quite stored exactly the same.. -- Jonah H. Harris, Senior DBA myYearbook.com -- 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] MVCC and index-only read

, Oracle has had this functionality since at least Oracle 8i (1999). -- Jonah H. Harris, Senior DBA myYearbook.com -- 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] MVCC and index-only read

using the same basic concepts. Hmm... --- snip Sounds like they're borrowing the code from innodb that does much the same thing You can't borrow something you started developing prior to InnoDB's release. -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql-general mailing list

Re: [GENERAL] MVCC and index-only read

/server.817/a85397/statem3e.htm#2061671 -- Jonah H. Harris, Senior DBA myYearbook.com -- 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] MVCC and index-only read

On Tue, Nov 18, 2008 at 3:45 PM, Joshua D. Drake [EMAIL PROTECTED] wrote: Off topic much? Hey, all I did was make a joke; other people wanted to get all *correct* about it :) Anyway, as this has been discussed at least twenty times before, this is a waste of a thread. -- Jonah H. Harris

Re: [GENERAL] High Availability for PostgreSQL on Windows 2003.

there is a solution with standby. Is there a product of High Availability for PostgreSQL on Windows 2003? I successfully configured an active/passive cluster using Double-Take Software with Postgres 8.3 on Windows2003. -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql-general mailing list

Re: [GENERAL] MVCC and index-only read

, but in a little different fashion. -- Jonah H. Harris, Senior DBA myYearbook.com -- 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] syncing with a MySQL DB

to the predicate. Anybody knows how improve this? If I have to push the predicate down, I'll generally write a set-returning function which takes some of the predicate, limit, and offset info to build a dynamic sql query against the remote database using dblink. -- Jonah H. Harris, Senior DBA

Re: [GENERAL] syncing with a MySQL DB

, but you could easily emulate the Oracle-side by creating triggers in PG to capture the changes. -- Jonah H. Harris, Senior DBA myYearbook.com -- 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] More schema design advice requested

sets that would return results very quickly. The method described in the query was referred to as full disjunction. Perhaps you can try: http://pgfoundry.org/projects/fulldisjunction/ -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql-general mailing list (pgsql-general

Re: [GENERAL] Federated Server

On Mon, Oct 6, 2008 at 11:57 PM, searchelite [EMAIL PROTECTED] wrote: Is there any capability of PostgreSQL to become a federated server? See http://archives.postgresql.org/pgsql-performance/2008-06/msg00182.php -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql-general mailing

Re: [GENERAL] Import German Number Format

which parameter I have to change? Independent of locale-related settings, I don't believe PG will accept a comma as input in this case. -- Jonah H. Harris, Senior DBA myYearbook.com -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription

Re: [GENERAL] Free Cache Memory (Linux) and Postgresql

, sync will flush all dirty file system blocks to disk and leave them in memory. -- Jonah H. Harris, Senior DBA myYearbook.com -- 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] [pgsql-www] PostgreSQL user documentation wiki open for business

On Wed, Mar 12, 2008 at 11:53 AM, Dave Page [EMAIL PROTECTED] wrote: I'm pleased to announce that wiki.postgresql.org is now open for business! Awesome! -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor

Re: [HACKERS] [GENERAL] Undetected corruption of table files

down performance... which is exactly opposite of conventional PostgreSQL wisdom (no performance trade-off for durability). -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation| fax: 732.331.1301 33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED

Re: [HACKERS] [GENERAL] Undetected corruption of table files

. At least you would know it was corrupted, instead of getting funky errors and/or crashes. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation| fax: 732.331.1301 33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED] Iselin, New Jersey 08830

Re: [GENERAL] [PERFORM] Parrallel query execution for UNION ALL Queries

On 7/18/07, Benjamin Arai [EMAIL PROTECTED] wrote: But I want to parrallelize searches if possible to reduce the perofrmance loss of having multiple tables. PostgreSQL does not support parallel query. Parallel query on top of PostgreSQL is provided by ExtenDB and PGPool-II. -- Jonah H

Re: [GENERAL] [ADMIN] Postgres VS Oracle

. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation| fax: 732.331.1301 33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED] Iselin, New Jersey 08830| http://www.enterprisedb.com/ ---(end of broadcast

Re: [GENERAL] [PERFORM] [ADMIN] Postgres VS Oracle

On 6/18/07, Andreas Kostyrka [EMAIL PROTECTED] wrote: As a cynic, I might ask, what Oracle is fearing? As a realist, I might ask, how many times do we have to answer this type of anti-commercial-database flamewar-starting question? -- Jonah H. Harris, Software Architect | phone: 732.331.1324

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

bashing based on problems with MySQL 3.23... Berkus and others (including yourself, if I am correct), have corrected people on not making invalid comparisons against ancient versions. I'm only doing the same where Oracle, IBM, and Microsoft are concerned. -- Jonah H. Harris, Software Architect

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

; it served no purpose other than to push the competitiveness topic again. I haven't seen any bashing going on yet. Shall we start with the closed mindedness and unfairness of per cpu license and support models? Not preferably, you make me type too much :) -- Jonah H. Harris, Software Architect

Re: [GENERAL] [pgsql-advocacy] [PERFORM] [ADMIN] Postgres VS Oracle

? Yeah, Josh B. asked it to be toned down to the original list which should've been involved. Which I think should be pgsql-admin or pgsql-advocacy... your thoughts? I think the Oracle discussion is over, David T. just needs URL references IMHO. -- Jonah H. Harris, Software Architect | phone

Re: [GENERAL] [SQL] PostgreSQL to Oracle

issues. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation| fax: 732.331.1301 33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED] Iselin, New Jersey 08830| http://www.enterprisedb.com/ ---(end of broadcast

Re: [GENERAL] [SQL] PostgreSQL to Oracle

I'd call, flakey happen this way. -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation| fax: 732.331.1301 33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED] Iselin, New Jersey 08830| http://www.enterprisedb.com

Re: [GENERAL] [SQL] PostgreSQL to Oracle

why you need to move to Oracle from PostgreSQL? -- Jonah H. Harris, Software Architect | phone: 732.331.1324 EnterpriseDB Corporation| fax: 732.331.1301 33 Wood Ave S, 3rd Floor| [EMAIL PROTECTED] Iselin, New Jersey 08830| http://www.enterprisedb.com

Re: [GENERAL] [pgsql-advocacy] One of our own begins a new life

On 9/15/06, Joshua D. Drake [EMAIL PROTECTED] wrote: Tomorrow one of our own, Devrim Gunduz is becoming a man. He is sucking it up, and committing to the cvs repo of project marriage. Congratulations Devrim! -- Jonah H. Harris, Software Architect | phone: 732.331.1300 EnterpriseDB Corporation

Re: [HACKERS] [GENERAL] New project launched : PostgreSQL GUI

I had to deal with an installer written in python and several in Java... IMHO, Java would be a better language for this and you could build off some nice OSS installers that already exist (such as IzPack). Just my 2 cents :) On 1/30/06, Devrim GUNDUZ [EMAIL PROTECTED] wrote: Hi,On Mon, 2006-01-30

Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql

archives? http://archives.postgresql.org -- Jonah H. Harris, UNIX Administrator | phone: 505.224.4814 Albuquerque TVI | fax: 505.224.3014 525 Buena Vista SE | [EMAIL PROTECTED] Albuquerque, New Mexico 87106| http://w3.tvi.edu/~jharris

Re: [GENERAL] [HACKERS] mirroring oracle database in pgsql

I wouldn't say it's enterprise-grade, but one could probably make it work. Sean Davis wrote: There is DBI-link, but this probably isn't an enterprise solution http://www.pervasive-postgres.com/postgresql/tidbits.asp Sean On Jun 13, 2005, at 2:31 PM, Jonah H. Harris wrote: The contrib