Re: [HACKERS] pg_class catalog question...

dd the overhead of any variable-length handling. -- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporation 732.331.1324 ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] pg_class catalog question...

but that's just a kludge. Now that I've had some sleep, I'm sure I'll get it working :) -- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporation 732.331.1324 ---(end of broadcast)--- TIP 9: In versions below 8.0

Re: [HACKERS] pg_class catalog question...

On 3/30/06, Tom Lane <[EMAIL PROTECTED]> wrote: > Here are a couple of possibilities; the first > one is smaller but it's touching pg_proc not pg_class. > Yeah, I noticed that one. How would you suggest setting CLASS_TUPLE_SIZE in that case? -- Jonah H. Harris, Database

[HACKERS] pg_class catalog question...

struct, but it still dies on me. I've never tried to do a fixed length char in the catalogs... any suggestions on the field, datatype, or bootstrapping? Of course, if there's another way to avoid the cost of variable length, I'm all ears. -- Jonah H. Harris, Database Inte

Re: [HACKERS] control pg_hba.conf via SQL

On 3/29/06, Andrew Dunstan <[EMAIL PROTECTED]> wrote: > ISTM that the first requirement is for a sane API that will handle the > fact that HBA lines are ordered. Persistence in itself shouldn't be a > big problem - we already do that with some shared tables, iirc. I agree.

Re: [HACKERS] control pg_hba.conf via SQL

ast)--- > TIP 9: In versions below 8.0, the planner will ignore your desire to >choose an index scan if your joining column's datatypes do not >match > -- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporatio

Re: [HACKERS] Issue on Varchar Ordering

--- 36 | GABRIELA HELEDA DE SOUZA 37 | GABRIELA JACOBY NOS 38 | GABRIEL ALCIDES KLIM PERONDI 39 | GABRIELA LETICIA BATISTA NUNES 40 | GABRIEL ALEXANDRE DA SILVA MANICA (5 rows) -- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporation 732.331.1324 -

Re: [HACKERS] Issue in Mapping varchar datatype of Postgre to Oracle

st_tbl"@pgdb; Where test_tbl is: postgres=# \d test_tbl Table "public.test_tbl" Column | Type | Modifiers ---+---+--- test_id | numeric(10,0) | not null test_name | character varying(32) | -- Jonah H. Har

[HACKERS] Request from Tom--offlist

o the list guys!-- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] 8.2 planning features

urrent timeline, I'll have hierarchical queries, nonrecursive introspective sort, and insert/update/delete returning ready for 8.2.  -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] qsort, once again

t; and medians of the partitions which are * known to be already sorted. * * This is also the reasoning behind selecting a small THRESH value (see * Knuth, page 122, equation 26), since the quicksort algorithm does less * comparisons than the insertion sort. */ -- Jonah H. Harris, Database Internals

Re: [HACKERS] qsort, once again

On 3/16/06, Tom Lane <[EMAIL PROTECTED]> wrote: "Jonah H. Harris" <[EMAIL PROTECTED]> writes:> doh! Sorry for the duplicate (again) Tom...  I wish Gmail would auto-reply to all.  grr.  Anyway, this is copied for others and the archives: There's a program I had

Re: [HACKERS] qsort, once again

doh!On 3/16/06, Dann Corbit <[EMAIL PROTECTED]> wrote: I sent him  a copy   From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] On Behalf Of Jonah H. Harris Sent: Thursday, March 16, 2006 11:43 AM To: Tom Lane Cc: pgsql-hackers@postgresql.org; Jerry Sievers S

Re: [HACKERS] qsort, once again

ort Function". */ Yes, I have it somewhere, let me dig it up for ya. -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] Separate BLCKSZ for data and logging

ng to try it out, here's a starting point based on the block sizes used by Oracle: 512 bytes on Linux, Solaris, AIX, Windows 1K on HP-UX and Tru64 2K on SCO 4K on MVS -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] [PATCHES] About the structure of WAL Files.

here but it needs to be updated a little such as changing the CRC and rtree calls. -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] Restoring a Full Cluster on a Different Architecture (32 x 64)

to go.  If it's a one-time shot, I'd just pipe pg_dump to a psql that's connected to PostgreSQL on your 32-bit system. -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] DB2-style INS/UPD/DEL RETURNING

E ... WHERE ... Yes, I believe it supports SELECT .. FROM NEW TABLE (UPDATE .. WHERE ..) WHERE IBM's paper, "Returning Modified Rows--SELECT Statements with Side Effects" is here:  http://www.isys.ucl.ac.be/vldb04/eProceedings/contents/pdf/IND1P1.PDF I'll look up more.-- Jona

Re: [HACKERS] Restoring a Full Cluster on a Different Architecture (32 x 64)

m architecture is key.  You won't be able to read the 64-bit data files on a 32-bit box. What could be done in order to fix it? Is there any kind of application to translate it or the only solution was to "pg_dumpall" and "pg_restore" the cluster? Yes, dump and restore is th

[HACKERS] Fwd: DB2-style INS/UPD/DEL RETURNING

al('test_id_seq'), 'John Doe'); Based on your statement, this should be really easy.  It's easy to make generalized statements, so let's see an example to compare. -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] DB2-style INS/UPD/DEL RETURNING

bl SET test_name = 'John Doe' WHERE test_id = 1; would return "John Doe" Again, I haven't really used it, but have read over the docs briefly.  I'm just wondering if anyone has used it and likes/dislikes it. -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

[HACKERS] DB2-style INS/UPD/DEL RETURNING

er... logically it seems nicer, but I've never used it. -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] Proposal for SYNONYMS

n later.  I'm not averse to removing ACLs from synonyms right now at all as we'd still benefit from the same functionality.  -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] Proposal for SYNONYMS

#x27;t have a problem switching create synonym to actually create a view.-- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] Proposal for SYNONYMS

Thanks for adding that. -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

[HACKERS] Proposal for SYNONYMS

ching the additional number of synonym objects in the catalog - In catalog searches which use a synonym, an additional cost is incurred to reference the real object - If no synonyms are created, no additional costs are incurred -- Jonah H. Harris, Database Internals ArchitectEnterpr

Re: [HACKERS] Merge algorithms for large numbers of "tapes"

testing several cases.It is not a bad idea to enable more than one method of performing an operation.In the ideal case, you would have specific information about drives,spindles, rates for seek, transfer, etc.It all depends on how much effort you want to throw at it.---

Re: [HACKERS] Coverity Open Source Defect Scan of PostgreSQL

On 3/8/06, Josh Berkus <josh@agliodbs.com> wrote: Actually, I thougth that Neil/eDB did this with their copy.  Is there anyway to get a copy of that "training configuration"? I think we have a backup of it somewhere.  I'll look into it. -- Jonah H. Harris, Database Internals

Re: [HACKERS] Merge algorithms for large numbers of "tapes"

t after reading the entire algorithm, discussion, and thinking it over for a couple minutes, I could see it as potentially better. Guess we won't really know 'til it can be tested :) -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] INS/UPD/DEL Returning P.tch

If this is the consensus, then I'm fine with posting to -patches... I just want to make sure people are aware of it so it can get tested.  Thanks.On 3/2/06, Alvaro Herrera <[EMAIL PROTECTED]> wrote: Jonah H. Harris wrote:> All,>> This is only the current patch updated to

Re: [HACKERS] INS/UPD/DEL Returning Patch

LETE RETURNING     DELETE FROM test_tbl WHERE test_id = current_rec.test_id     RETURNING * INTO current_rec;     -- This DOES NOT WORK     RAISE NOTICE 'test_id is %', current_rec.test_id;     RAISE NOTICE 'test_name is %', current_rec.test_name;     RETURN; END; $$ LANGUAGE

Re: [HACKERS] qsort again (was Re: [PERFORM] Strange Create Index behaviour)

st)---> > TIP 3: Have you checked our extensive FAQ?> >> >http://www.postgresql.org/docs/faq>> -----------(end of broadcast)---> TIP 2: Don't 'kill -9' the postmaster >--  Bruce Momjian   http://candle.pha.pa.us  SRA OSS, Inc.   http://www.sraoss.com  + If your life is a hard drive, Christ can be your backup. + ---(end of broadcast)---TIP 6: explain analyze is your friend-- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporation732.331.1324

[HACKERS] INS/UPD/DEL Returning Patch

NS/UPD/DEL RETURNING ready for 8.2... all comments, suggestions, issues would be appreciated. -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324 diff -cr pgsql/src/backend/access/common/printtup.c pgsql-iudret/src/backend/access/common/printtup.c *** pgsql/src/backend/acc

Re: [HACKERS] 8.2 Feature Freeze Rough Estimate

--------TIP 6: explain analyze is your friend-- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporation732.331.1324

Re: [HACKERS] Status of INS/UPD/DEL RETURNING?

OK... I guess I'll go through the archives and see what Tom et al's comments were and work from there.  I tried to contact Omar a couple times via email and got no response. Thanks!On 3/1/06, Gavin Sherry <[EMAIL PROTECTED]> wrote: On Wed, 1 Mar 2006, Bruce Momjian wrote:> Jo

Re: [HACKERS] Status of INS/UPD/DEL RETURNING?

http://candle.pha.pa.us/mhonarc/patches_hold/msg00014.html On 3/1/06, Bruce Momjian <pgman@candle.pha.pa.us> wrote: Jonah H. Harris wrote:> Hey guys,>> What's the status of the current INSERT/UPDATE/DELETE RETURNING patch?  Is> it ready to go or does it need to be cleaned

[HACKERS] Status of INS/UPD/DEL RETURNING?

Hey guys, What's the status of the current INSERT/UPDATE/DELETE RETURNING patch?  Is it ready to go or does it need to be cleaned up? -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] 8.2 Feature Freeze Rough Estimate

//candle.pha.pa.us  SRA OSS, Inc.   http://www.sraoss.com  + If your life is a hard drive, Christ can be your backup. +---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?   http://www.postgresql.org/docs/faq-- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporation732.331.1324

Re: [HACKERS] bug in 7.3.2

s tend to skip few numbers.After restarting the server the nextval of sequence doest matchwith the last number. -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] Remove ora2pg from contrib

l it.--Peter Eisentrauthttp://developer.postgresql.org/~petere/ ---(end of broadcast)---TIP 4: Have you searched our list archives?   http://archives.postgresql.org -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] Feature Request

)----------- TIP 3: Have you checked our extensive FAQ?   http://www.postgresql.org/docs/faq-- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporation732.331.1324

Re: [HACKERS] Updated email signature

IL PROTECTED] so that your   message can get through to the mailing list cleanly -- Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation732.331.1324

Re: [HACKERS] qsort again (was Re: [PERFORM] Strange Create Index

p://archives.postgresql.org-- Jonah H. Harris, Database Internals Architect EnterpriseDB Corporation732.331.1324

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-3

Re: [HACKERS] Want to add to contrib.... xmldbx

On 1/29/06, Mark Woodward <[EMAIL PROTECTED]> wrote: I generally agree as well, but.I think there is always a balance between "out of the box" vs"extensibility." I think integration and extensibility is fantastic foraddaptation of your product, but "oobe" (out of box experience) is important fo

Re: [HACKERS] ROLLBACK triggers?

My read is such that he is using Senna as follows (where external means outside of PostgreSQL):1. Create external FTI2. BEGIN TRANS3a. Insert record into PostgreSQL3b. Insert record into Senna4. Commit His problem is that the PostgreSQL record (3a) *could* be rolled-back after he adds them to the S

Re: [HACKERS] ROLLBACK triggers?

ah of expanding your work to include 'on user login/logout' ?     As an aside, a trigger on rollback seems... unlikely (at least to my mind). What is the functionality if your rollback trigger fails ? Ugh. Down that road I can see madness looming, however, this -is- monday so ... :)     Re

Re: [HACKERS] ROLLBACK triggers?

Daisuke,A patch was done for replication hooks which implements global database-level triggers for connection startup and shutdown, and transaction begin, commit, and rollback; they may help you out in this situation. http://gorda.di.uminho.pt/community/pgsqlhooks/-Jonah On 1/23/06, Daisuke Maki <[

Re: [HACKERS] No heap lookups on index

On 19 Jan 2006 11:25:21 -0500, Greg Stark <[EMAIL PROTECTED]> wrote: Well it seems there were lots of facts posted. Yes you can avoid headachescaused by these issues, but we're not really talking about the headaches.Several were mentioned; some of which could generally be avoided by good tuning. We

Re: [HACKERS] No heap lookups on index

As an Oracle internals person myself, I don't see how making a comparison between the specifics of Oracle's MVCC to PostgreSQL's MVCC is relevant to this discussion.As does *MOST* other commercial databases, Oracle's storage manager performs an update-in-place whereas PostgreSQL's (for the most par

Re: [HACKERS] No heap lookups on index

David,You can find some of this discussion in "Much Ado About COUNT(*)".  Related to that discussion, I had written a patch which added visibility information to the indexes.If you're interested in the patch and/or consulting, contact me offline. -JonahOn 1/18/06, Tom Lane <[EMAIL PROTECTED]> wrote

Re: [HACKERS] Unique constraints for non-btree indexes

GIST.  It just seems to me like the access methods should keep the handling internal to themselves. On the chance that I'm not be understanding what you're saying, sorry.On 1/18/06, Martijn van Oosterhout <kleptog@svana.org> wrote: On Wed, Jan 18, 2006 at 09:15:04AM -0500, Jon

Re: [HACKERS] Unique constraints for non-btree indexes

I thought gistinsert had checkUnique, it was just ifdef'd out because there was no code to enforce it... and as such, during bootstrap it was marked as amcanunique = false.  Would it be that hard to enable it?On 1/18/06, Martijn van Oosterhout wrote:Hi,Currently due to the way

Re: [HACKERS] Anyone see a need for BTItem/HashItem?

>From what I've seen, I don't think we need to keep them around.On 1/16/06, Tom Lane <[EMAIL PROTECTED]> wrote: I'm considering getting rid of the BTItem/BTItemData andHashItem/HashItemData struct definitions and just referencing IndexTuple(Data) directly in the btree and hash AMs.  It appears that

Re: [HACKERS] simple utility commands (src/backend/commands)

You should look at something like the LOCK table command.  The following areas will help:src/backend/tcop/utility.csrc/backend/commands/lockcmds.csrc/backend/nodes/*funcs.csrc/backend/parser-Jonah On 1/13/06, Gevik babakhani <[EMAIL PROTECTED]> wrote: Folks,   I would like to underst

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

It's implemented in the server with extensions for psql to support it.On 12/23/05, Bruce Momjian wrote:Jonah H. Harris wrote:> I know this is a tech forum and as such, I don't generally plug products too > much.  However, EnterpriseDB has anonymous PL/SQL if you need it.In

Re: [HACKERS] Oracle PL/SQL Anonymous block equivalent in postgres

I know this is a tech forum and as such, I don't generally plug products too much.  However, EnterpriseDB has anonymous PL/SQL if you need it. On 12/22/05, Bruce Momjian wrote: Wow, that is large.  I think PL/pgSQL is your best approach.  Irecommend you create a schema that

Re: [HACKERS] HOOKS for Synchronous Replication?

True, I think we need hooks for both methods.On 12/8/05, Jan Wieck <[EMAIL PROTECTED]> wrote: On 12/8/2005 2:05 PM, Jim C. Nasby wrote:> On Thu, Dec 08, 2005 at 08:33:59AM -0800, Darcy Buskermolen wrote:>> On Wednesday 07 December 2005 20:24, Tom Lane wrote:>> > Christopher Kings-Lynne < [EMAIL PR

Re: [HACKERS] HOOKS for Synchronous Replication?

On 12/8/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote: While this code might be useful, whouldn't it be much more valuable toprovide hooks into xlog so that we could do non-trigger-basedreplication? (As well as non-trigger-based materialized views...) If we're going to do hooks for replication, I thi

Re: [HACKERS] Reducing contention for the LockMgrLock

Tom, This would also explain some things we've seen during benchmarking here at EnterpriseDB.  I like your idea and, as I'm on my way out, will think about it a bit tonight. Similarly, I don't see the any forward-looking reason for keeping the separate hash tables used for the LockMethodIds.  Or,

Re: [HACKERS] generalizing the planner knobs

tter spent enhancing the system as a whole.  My only suggestion was that it would be better than Part 1 of Neil's statement.  Somehow I missed the end mention of multipliers which I agree requires less effort. On 12/1/05, Tom Lane <[EMAIL PROTECTED]> wrote: "Jonah H. Harris"

Re: [HACKERS] generalizing the planner knobs

Hey Neil, In the last couple weeks I too have been thinking about planner hints.  Assuming I have read your post correctly, the issue I see with this idea is that, in most cases, there won't be much of a difference between adding an arbitrary cost value to each type of node and disabling it comple

Re: [HACKERS] ice-broker scan thread

FYI, I've personally used Oracle 9.2.0.4's async IO on Linux and have seen several installations which make use of it also.   On 11/28/05, Gavin Sherry <[EMAIL PROTECTED]> wrote: On Mon, 28 Nov 2005, Tom Lane wrote:> Gavin Sherry <[EMAIL PROTECTED] > writes:> > I haven't had time to prototype wheth

Re: [HACKERS] PCTFree Results

Josh, Do you have an 8.1 patch for this or only the 8.0.x? On 9/22/05, Josh Berkus wrote: Folks,Well, it took a while but I finally have the results of Satoshi's PCTFreepatch back from the STP.  Bad news about the STP, see below ...Anyway, a series of DBT2 runs doesn't seem to

Re: [HACKERS] CLUSTER and clustered indices

I agree, keeping it clustered would be very nice. On 11/17/05, Alvaro Herrera <[EMAIL PROTECTED]> wrote: Simon Riggs wrote:> On Thu, 2005-11-17 at 10:58 -0500, Tom Lane wrote:> > Simon Riggs < [EMAIL PROTECTED]> writes:>> The use case exists and the technique is low overhead, but the main> question

Re: [HACKERS] Improving count(*)

Simon,   Nice suggestion, I think it's workable but (like all other methods) has some technical/pseudo-political challenges.   I'm still voting for my old, "Much Ado About COUNT(*)" topic; adding visibiility to the indexes and counting them like the other RDBMS vendors.  True, it would add storage

Re: [HACKERS] bind variables, soft vs hard parse

In some cases, Oracle will also replace literals with bind variables so that it can perform a sort-of-bind-value soft parse later.   On 11/15/05, Jim C. Nasby <[EMAIL PROTECTED]> wrote: PostgreSQL combines both parses into one, so every new query iseffectively a hard parse (unless it's prepared, th

Re: [HACKERS] CONNECT BY PRIOR

Hey Simon,   I'm doing some research into recursive query planning in terms of theory as-well-as actual implementation in other RDBMS.  Let me get back to you when I have some more definitive info.     On 11/14/05, Simon Riggs <[EMAIL PROTECTED]> wrote: On Sat, 2005-11-12 at 15:27 -05

Re: [HACKERS] [ADMIN] Major Problem, need help! Can't run our

I agree.  (sorry again Tom... dang GMAIL should default reply to all g!)  On 11/14/05, Tom Lane <[EMAIL PROTECTED]> wrote: Rod Taylor <[EMAIL PROTECTED]> writes:> On Mon, 2005-11-14 at 23:02 -0500, Tom Lane wrote: >> There's something in what you say.  We'd have to rename pg_clog as well,>>

Re: [HACKERS] CONNECT BY PRIOR

Yann, I am working on the standard WITH syntax for recursive query support and hope to get it into 8.2. On 11/12/05, Yann Michel <[EMAIL PROTECTED]> wrote: Hi,I'm just a little bit confused because I expected postgresql to be ablet "connect by prior" but as I have seen it is not. :-(Are there

Re: [HACKERS] 8.1-compatible xlogdump

I agree. On 11/1/05, Alvaro Herrera <[EMAIL PROTECTED]> wrote: Jonah H. Harris wrote:> Does anyone have a copy of xlogdump updated for 8.1? If so, please send me a > copy. Otherwise I'll update it and forward the diffs.We should definitely consider completing it and includ

[HACKERS] 8.1-compatible xlogdump

Does anyone have a copy of xlogdump updated for 8.1?  If so, please send me a copy.  Otherwise I'll update it and forward the diffs.   -Jonah

Re: [HACKERS] Optimization system

TIP 5: don't forget to increase your free space map settings-- Respectfully,Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporation http://www.enterprisedb.com/

Re: [HACKERS] Problem in ExecEvalExpr function

; Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a > tool for doing 5% of the work and then sitting around waiting for someone> else to do the other 95% so you can sue them.-- Respectfully,Jonah H. Harris, Database Internals Architect EnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] PostgreSQL roadmap for 8.2 and beyond.

regards, tom lane---(end of broadcast)-----------TIP 2: Don't 'kill -9' the postmaster-- Respectfully,Jonah H. Harris, Database Internals Architect EnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] slow IN() clause for many cases

--Andrew, Supernewshttp://www.supernews.com - individual and corporate NNTP services---(end of broadcast)---TIP 3: Have you checked our extensive FAQ?   http://www.postgresql.org/docs/faq-----------(end of broadcast)-

Re: [HACKERS] definition of evalfunc for execution of join condition

ted(for example may be for Nested Loop Joins)Thanx in advanceEsha---(end of broadcast)---TIP 4: Have you searched our list archives?    http://archives.postgresql.org-- Respectfully,Jonah H. Harris, Database Internals ArchitectEnterprise

Re: [HACKERS] slow IN() clause for many cases

s=1117 width=600) (actual> time=0.542..2.898 rows=138 loops=1)Hmm, sure looks from here like the bitmap plan is faster.regards, tom lane---(end of broadcast)---TIP 2: Don't 'kill -9' the postmaster-- Respectfu

Re: [HACKERS] slow IN() clause for many cases

ackend could do that in a much faster and elegant fasion.Bitmap-or is nice, but for many IN arguments it is still much slower thanjoin.---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?   http://www.postgresql.org/docs/faq--

Re: [HACKERS] Need A Suggestion

help, with no results. I > am a Windows 2003 user, version 8.0.1 > > > > ---(end of broadcast)--- > TIP 2: Don't 'kill -9' the postmaster > -- Respectfully, Jonah H. Harris, Database Internals Architect EnterpriseDB

[HACKERS] Oracle buys Innobase

I know it's off-topic, but I just love it. Excerpt, "InnoDB's contractual relationship with MySQL comes up for renewal next year. Oracle fully expects to negotiate an extension of that relationship". Good for Heikki. -- Respectfully, Jonah H. Harris, Database Internals Ar

Re: [HACKERS] Vote needed: revert beta2 changes or not?

#x27; suggestion of having > both > > int pg_cancel_backend(int) > bool pg_backend_cancel(int) > > with the former deprecated but still there for backward compatibility? > > regards, tom lane > > ---(end of broadc

Re: [HACKERS] Vote needed: revert beta2 changes or not?

enforce it next > > time? > > Because we will know better. > > -- > Alvaro Herrera Architect, http://www.EnterpriseDB.com > "La fuerza no está en los medios físicos > sino que reside en una voluntad indomable" (Gandhi) > >

Re: [HACKERS] [PERFORM] A Better External Sort?

positive all of us that can, would put resources into > fixing the issue had we a specific direction to attack. > > Sincerely, > > Joshua D. Drake > > ---(end of broadcast)--- > TIP 9: In versions below 8.0, the planner will ign

Re: [HACKERS] External Sort timing debug statements

-(end of broadcast)---TIP 2: Don't 'kill -9' the postmaster-- Respectfully,Jonah H. Harris, Database Internals Architect EnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] PCTFree Results

ervasive.vcf   cell: 512-569-9461---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ?       http://www.postgresql.org/docs/faq-- Respectfully, Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] postgresql clustering

mation about "real-world" clustering, read the research for DB2 (Mainframe) and Oracle RAC. -- Respectfully,Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] [DOCS] Added documentation about caching, reliability

d drive, |  13 Roberts Road  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073---(end of broadcast)---TIP 1: if posting/reading through Usenet, please send an appropriate   subscribe-nomail command to [EMAIL PROTECTED] so that your  

Re: [HACKERS] Added documentation about caching, reliability

-(end of broadcast)---TIP 1: if posting/reading through Usenet, please send an appropriate   subscribe-nomail command to [EMAIL PROTECTED] so that your   message can get through to the mailing list cleanly-- Respectfully,Jonah H. Harris, Database Internals Architect En

Re: [HACKERS] PostgreSQL overall design

t your   message can get through to the mailing list cleanly-- Respectfully,Jonah H. Harris, Database Internals Architect EnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] [PERFORM] A Better External Sort?

ying very hard NOT to waste anyone's time around here. Including my ownRon---(end of broadcast)---TIP 5: don't forget to increase your free space map settings-- Respectfully,Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] [PERFORM] A Better External Sort?

orting conditions.>> What do people think?I think that your analysis is very interesting.  I would like to see theresult of the experiment. I think that the btrees are going to be O(n*log(n)) in construction ofthe indexes in disk access unless you memory map them [which means youwould need stupendous memory volume] and so I cannot say that I really understand your idea yet.  Can you draw a picture of it for me?  (I amdyslexic and understand things far better when I can visualize it).---(end of broadcast)--- TIP 4: Have you searched our list archives?   http://archives.postgresql.org-- Respectfully,Jonah H. Harris, Database Internals Architect EnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] PCTFree Results

of> PCTFREE?Lots, look up the tests on OSDL, per link.JoshJosh BerkusAglio Database SolutionsSan Francisco -- Respectfully,Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] PCTFree Results

n appropriate   subscribe-nomail command to [EMAIL PROTECTED] so that your   message can get through to the mailing list cleanly-- Respectfully,Jonah H. Harris, Database Internals Architect EnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

ce of Evgen to re-license, but the license was *not*theprimary thing blocking acceptance of the patch.JoshJosh Berkus Aglio Database SolutionsSan Francisco---(end of broadcast)---TIP 4: Have you searched our list archives?   http

Re: [HACKERS] Hierarchical Queries--Stalled No Longer...

guys want. -Jonah On 9/22/05, Alvaro Herrera <[EMAIL PROTECTED]> wrote: On Thu, Sep 22, 2005 at 11:19:13AM -0400, Jonah H. Harris wrote:Hi,> Evgen Potemkin has granted me a BSD license on the patch for hierarchical> queries (WITH and CONNECT BY) and I'd like to get it on track for

[HACKERS] Hierarchical Queries--Stalled No Longer...

x27;d like to see. In the mean time, I'll pull 8.1, patch it, write some regression tests, test it, and submit it back.  BTW, what's the estimated schedule of 8.2?-- Respectfully,Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] postgresql clustering

o vote!---(end of broadcast)---TIP 5: don't forget to increase your free space map settings -- Respectfully,Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporationhttp://www.enterprisedb.com/

Re: [HACKERS] 64-bit API for large objects

Cool.  We look forward to it.On 9/19/05, Mark Dilger <[EMAIL PROTECTED]> wrote: Jonah H. Harris wrote:> Mark,>> If you don't mind contributing the changes, we'd be glad to take a look> at them.  Thanks.>> -Jonah>Ok, we will post it back soon.  We h

Re: [HACKERS] 64-bit API for large objects

index scan if your joining column's datatypes do not        match-- Respectfully,Jonah H. Harris, Database Internals ArchitectEnterpriseDB Corporationhttp://www.enterprisedb.com/

<    1   2   3   4   5   6   >