f
> 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
ure.html
--
Jonah H. Harris, Senior DBA
myYearbook.com
.com/doc/refman/5.0/en/index-merge-optimization.html
--
Jonah H. Harris, Senior DBA
myYearbook.com
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://www.p
On Mon, Dec 22, 2008 at 12:34 PM, Christophe wrote:
> Playing the straight man, I have to ask: Scalability issues with locks in PG
> vs Oracle?
(in slow motion) no. Locks aren't something particular I'd
like to discuss, this topic just came from a post upthread.
--
On Mon, Dec 22, 2008 at 9:35 AM, James B. Byrne wrote:
> I think that to describe either OS or commercial software as better or
> worse is misleading. The most that can be said is that each approach
> serves a different purpose and exists in a different environment.
Well said.
--
On Mon, Dec 22, 2008 at 8:22 AM, Alvaro Herrera
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, which you didn't this time.
On Mon, Dec 22, 2008 at 7:37 AM, Geoffrey 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-general mailing
On Sun, Dec 21, 2008 at 11:02 PM, Scott Marlowe 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 both sides, and ofte
: That's saying 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, Sen
On Sun, Dec 21, 2008 at 9:42 PM, David Fetter 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
>> wrote:
>> >> Oracle on the other hand stores the lock information directly in
>> >&
x27;t find any 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@po
cts/ora2pg/
You can 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%22&hl=en&ct=clnk&cd=1&gl=us
--
Jonah H. Harris, Senior DBA
myYearbook.com
--
Sent via pgsql-gene
ed.
Well, clustered indexes mean different things to different vendors.
Oracle's implementation stores the data with the index as does SQL
Server, 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
nstance.
> Actualy 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
--
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
docs/cd/A87860_01/doc/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
ing they stole it or something. Just that they're 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.
--
hey aren't borrowing anything, 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
ly consist of two or three integer columns)
Those 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
d be satisfied directly from the index (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.c
d
For the most part, that's all you needed to say :)
--
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
to the remote system because Postgres
can't give it access 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
and designed to replicate Oracle->MySQL, 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:
a schema redesign
> around skill 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
--
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 pgsq
to
> change a parameter with SET? Does anybody know 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 (pgsq
orm on a large
database.
What are you trying to accomplish? By itself, 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
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 Thorna
t of it had been zapped.
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]
I
ecause it will slow 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| [E
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.
--
J
e list?
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 Archit
ng the topic again? My vote is for
the latter; 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
-list gospel.
All of us have noticed the anti-MySQL 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
Mic
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 |
comparison.
--
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 o
ave no data type 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/
---(
lly had anything 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
that my advice is done with, could you explain 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
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
Enterp
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-3
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. H
end of broadcast)---
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
--
Jonah H. Harris, UNIX Administrator | phone: 505.224.4814
Albuquerque TVI | fax: 505.224.3014
525 Buena Vista SE | [EMAI
44 matches
Mail list logo