Re: [HACKERS] Chapter on PostreSQL in a book

is superiority. You should mention eRServer, SlonyI, DBmirror, and Mammoth Replication. What are distribution external data? - Database Administration Tools How is this different from the first item? -- Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] pg_advisor schema proof of concept

index on an FK, or even no index at all! The docs for pg_advisor need to reflect that it only catches little details the developer might otherwise have missed. It's not smarter than a DBA. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [PERFORM] [HACKERS] fsync method checking

writes, when WAL files are getting added/recycled? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Better support for whole-row operations and composite types

on the implementation. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

[HACKERS] Inconsistent behavior on Array Is Null?

15 net_test=# select ARRAY[]::INT[]; ERROR: syntax error at or near ] at character 14 net_test=# -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

Re: [HACKERS] Inconsistent behavior on Array Is Null?

? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] Inconsistent behavior on Array Is Null?

and unknown and a not applicable value instead of the unitary NULL. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] PITR for replication?

that Command Prompt's Mammoth Replicator works on something like log shipping.There are both advantages and disadvantages to the approach, meaning that we will still need other replication strategies, like Slony and DBMirror. Also, the jump from PITR -- Log Shipping is not a trivial one. -- Josh

Re: [HACKERS] Function to kill backend

. In fact, it would be nice if they started killing random backends because then I'd know something was wrong. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [HACKERS] Function to kill backend

want to be convinced that someone really needs it. It is *not* our practice to add features just because we can. Otherwise, I'll stick by my assertion that idle connection management should be done in the middleware and NOT by psql. -- -Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Function to kill backend

, someone can give us a real business case that they have actually encountered in production. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Function to kill backend

suspect that most platforms that use connection pooling are the same. So your case would only work if you actually blocked all connections from that host -- not a capability we'd discussed. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] make == as = ?

; no !=, no SELECT DISTINCT ON and no alias references in the GROUP BY clause. Allowing your students to use a non-standard operator that will fail them the instant they leave the classroom is serving them badly indeed. -- Josh Berkus Aglio Database Solutions San Francisco ---(end

[HACKERS] Code Sprint at OSCON?

melee of coding to fix some problem or implement some feature (for example, a platform port or PITR). Would we have enough people interested in this? I've a feeling not, but I wanted to ask. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] [DEFAULT] Daily digest v1.4379 (25 messages)

/ interface) code and not queries, and b) they will never themselves be a search condition. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] make == as = ?

of international standards for educators. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] make == as = ?

, then. From my perspective, it is better to teach a student nothing at all than to teach them something which is wrong. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

Re: [HACKERS] make == as = ?

Fabien, You're arguing that pg should help its customers to leave it easilly, what is quite paradoxical! ;-) grin If we're going to embrace and extend, we need more market share first. ;-) -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

[HACKERS] Remove MySQL Tools from Source?

Folks, I'm thinking it's time to remove the MySQL conversion tools from the PostgreSQL source tree and put them somewhere they might be maintained. I've just done some testing, and neither one works with current versions of MySQLdump. -- -Josh Berkus Aglio Database Solutions San

Re: [HACKERS] Socket communication for contrib

Hans, Andrew, I have learned (please correct me if I am wrong) that people tend to look in contrib before they look at gborg. pgFoundry/project.postgresql.org will be up by next week, I promise. Working on it now. This should increase the visibility of non-core components. -- -Josh

Re: [HACKERS] Remove MySQL Tools from Source?

feel pretty strongly that it will be more visible and easier to maintain on its own than in /contrib. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Remove MySQL Tools from Source?

system. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [HACKERS] Remove MySQL Tools from Source?

, GForge's Code Snippets, has a bug that will prevent us from using it immediately. But I'll see what I can do. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

? 2) Is the module being considered for eventual incorporation into the mainstream backend? That being said, let us get projects.postgresql.org up and running first ... we've hit some technical snags today. -- -Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] contrib vs. gborg/pgfoundry for replication solutions

-- putting more stuff in pgFoundry, and letting packagers know that they should package and include all mature projects on pgFoundry if they can. (our earlier discussion proved that this list cannot realistically designate approved vs. unapproved projects). -- -Josh Berkus Aglio Database

[HACKERS] pgFoundry delayed -- some setup issues

Folks, Well, as someone could have predicted, once we actually tried running some new projects on pgFoundry we ran into setup issues.We're resolving these and should have stuff up and running soon. -- Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] Proposed Query Planner TODO items

that fixed. If #19 is missing it's because Oleg I could not get it to complete. That was also the query which we are most interested in testing. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched

Re: [HACKERS] Bringing PostgreSQL torwards the standard regarding case folding

. Tri-state. Folder upper, if failes, fold lower, if succeeds, warn. Can't see this being possible. 2. Dual state. Fold lower or upper. Break if client is broken. Best, I think. But it should be client-side. 3. Create a database conversion tool to change existing case. No thanks. -- Josh

Re: [HACKERS] [pgsql-advocacy] Do we prefer software that works or software that looks good?

some, though, I've been sick) Unless the 5 of us take a vote, Tom Lane speaks for Tom Lane, not for Core.Also, usually this list or Patches determines by consensus what gets in; the Core only gets involved in very unusual cases. -- Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib, etc.

, emacs. Or Linux. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Bringing PostgreSQL torwards the standard regarding case folding

entirely, which maybe you're prepared to do. If you want to change case folding for the system catalogs, though, you'll need to update code in thousands of places, becuase the back-end code is expecting lower-case identifiers -- -Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib, etc.

like a company does. Um, and pay them with what? Cowrie shells? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Usability, MySQL, Postgresql.org, gborg, contrib, etc.

convinces companies that he approaches about case studies that he's for real). Titles are not at all useful *inside* the community, we don't need them. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have

Re: [HACKERS] Call for 7.5 feature completion

the interfaces, such as JDBC and libpqxx to seperate modules in pgFoundry. Either we're trying to lighten up the core, or we're not.But right now there seems to be no logic in operation. I do think, though, that we need some system to build RPMs for all the pgFoundry stuff ... -- Josh

Re: [HACKERS] Call for 7.5 feature completion

' feedback. Anybody wanna volunteer to be 7.5 testing coordinator? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan if your joining column's datatypes

Re: [HACKERS] Call for 7.5 feature completion

. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Call for 7.5 feature completion

... -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through

Re: [HACKERS] [SQL] Inconsistent or incomplete behavior obverse in where

to numeric for equality comparison, would it be possible to convert a literal value to match the column to which it is compared? Or is literal processing completed before any expressions are evaluated? -Josh Berkus ---(end of broadcast)--- TIP 6: Have

[HACKERS] Need Quote for 7.3

, please e-mail me, Marc ([EMAIL PROTECTED]) and Justin ([EMAIL PROTECTED]) off-list so we can quote you! -Josh Berkus ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

mailing list. BTW, we do coordinate with the Website development group, and for that matter TechDocs. -Josh Berkus ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

offered to help the WWW team and were rejected. If this is true, I'd like to see that person say so explicitly and we can find out from Vince and Marc what happened; if not, I think the insinuations about exclusiveness by the WWW team are completely uncalled for. -Josh Berkus

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

need to have a group making a loud enough noise to get the world to pay attention. I'm not asking everyone on this list to participate, but I am asking everyone on this list to recognize the utility of the effort. -Josh Berkus ---(end of broadcast

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

in a way that's inconsistent with the development goals for the database. We *want* Advocacy to be an integral part of the Postgres community, serving the general goal of making Postgres the best possible ORDBMS in existence. -Josh Berkus ---(end of broadcast

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

PostgreSQL. I'm against promoting PostgreSQL in ways that embarrass me. What, specifically, were you embarassed by? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] [GENERAL] PostgreSQL Global Development Group

. Would you be willing to act as a reviewer on future press releases? That way, we can get the benefit of your insight in a manner that will benefit the press release process. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

[HACKERS] Suggestion; WITH VACUUM option

, and are currently getting around that by vacuuming every 5 mintutes. Easy? Hard? Insane? What do you think? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [HACKERS] Suggestion; WITH VACUUM option

, either. Funny, it sounded like a really good idea on the phone. In the words of Rosanne Rosanna Danna, Neeeveer mind. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through

Re: [HACKERS] Can we revisit the thought of PostgreSQL 7.2.4?

source code so that we don't set a precedent for branching development. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs

Re: [HACKERS] [PERFORM] Proposal: relaxing link between explicit JOINs and execution order

for these variables? The best I'd been able to come up with is MAX_JOIN_COLLAPSE and MAX_FROM_COLLAPSE, but neither of these exactly sing... How about: EXPLICIT_JOIN_MINIMUM and FROM_COLLAPSE_LIMIT Just to make the two params not sound so identical? -- -Josh Berkus Aglio Database Solutions San

Re: [HACKERS] Release Scheduales: 7.2.4 7.3.2

Folks, I've been following this discussion, but I still haven't seen a definitive list of patches included in 7.2.4. Where can I find one? -- -Josh Berkus ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL

Re: [HACKERS] [PERFORM] not using index for select min(...)

it. What I'm concerned about is the possibility of having any idea or fix I come up with dismissed out of hand because it's a low-priority todo. Please add up the questions and complaints of the users on SQL, NOVICE, and PERFORMANCE ... I know you read them. Thanks for reading, Tom. -- Josh

Re: [HACKERS] [PERFORM] not using index for select min(...)

exactly how it's done? If I knew that, I'd have proposed a patch already, yes? I'm working on it. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Changing the default configuration (was Re: [pgsql-advocacy]

. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Changing the default configuration (was Re: [pgsql-advocacy]

-language sort of function, anyway. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message

Re: [HACKERS] Changing the default configuration

, and we'd need to build it up before we could use it as the basis of a PG tuner. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [pgsql-advocacy] [HACKERS] Changing the default configuration

HEY PEOPLE! How about we take this discussion to the Performance List, where it belongs? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] ILIKE

'jehosaphat' ~* '^Jehosaphat$', and certainly much faster than lower('jehosaphat') = lower('Jehosaphat') Why this sudden urge to prune away perfectly useful operators? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] ILIKE

Peter, 4) It's just as indexible (or not indexable) as regexp comparisons, and easier to understand for users from the Microsoft world than regexp. ILIKE is not indexible at all. Other forms of pattern comparisons are at least indexible sometimes. And how is ~* indexable? -- Josh

Re: [HACKERS] ILIKE

(or not indexable) as regexp comparisons, and easier to understand for users from the Microsoft world than regexp. And, on a quick search, one of my applications uses ILIKE 21 times in the built in functions and views. -- Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] Can pessimistic locking be emulated?

be processed-type error messages by showing the user up front which records are locked, as well as allowing the admin to decide when locks should time out. I tend to find in general that database locking mechanisms are a very poor locking strategy for a good UI. -- Josh Berkus [EMAIL PROTECTED] Aglio

Re: [HACKERS] [SQL] Cursors and backwards scans and SCROLL

concerned. PL/pgSQL's FOR record IN query is currently both easier and faster than cursors so I use that 90% of the time. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] Timestamp Interval - Part 1

. -- -Josh Berkus ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Interval oddities

Thomas, ./configure --help Isn't anywhere else yet. Not seeing it. Is this a 7.3 thing? What does it do? -- -Josh Berkus ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs

Re: [HACKERS] Interval oddities

Thomas, ./configure --help Isn't anywhere else yet. Not seeing it. Is this a 7.3 thing? What does it do? Sorry, yes it is a 7.3 thing. What does --enable-interval-integers do? I don't want to bother writing up issues you've already taken care of. -- -Josh Berkus

Re: [HACKERS] finding medians

. Can I talk you into submitting your code to Techdocs? I'd love to have it somewhere where it won't get buried in the mailing list archives. -- -Josh Berkus ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] pgaccess.org - invitation for a working meeting

. Your contribution will be widely appreciated by Postgres users everywhere. -Josh Berkus PostgreSQL/Techdocs Writer ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

[HACKERS] Timestamp/Interval proposals: Part 2

into account local laws and wierdnesses. Alternative: We can allow users to designate timezones according to GMT offset and whether or not they support DST. Example -8:00 DST for PST/PDT, and -7:00 NDS for the Arizona example above. -- -Josh Berkus Techdocs Writer ---(end

Re: [HACKERS] Timestamp/Interval proposals: Part 2

a link? __AGLIO DATABASE SOLUTIONS___ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small businessesfax 621-2533 and non-profit

Re: [HACKERS] Timestamp/Interval proposals: Part 2

15 hrs 10 min 33 sec  This needs more polishing, of course, but you can see where I'm going with it. -Josh __AGLIO DATABASE SOLUTIONS___ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management

Re: Default privileges for new databases (was Re: [HACKERS] Can't import large objects in most recent cvs)

usually know at the time of installation whether they're building a web server (secure) or a home workstation (permissive). Depending on the setting, this should set either a grant all or revoke all for non-db owners as default, including such things as temp table creation. -- -Josh Berkus

Re: [HACKERS] [SQL] Efficient DELETE Strategies

. Personally, I would *not* want the database to guess what I want in a delete statement; it might guess wrong and there go my records ... Heck, one of the things I need to research how to turn off in PostgreSQL is the Add missing FROM-clause feature, which has tripped me up many times. -- -Josh

Re: [HACKERS] Will postgress handle too big tables?

whitepapers and Oracle migration tips. -- -Josh Berkus __AGLIO DATABASE SOLUTIONS___ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms, small

Re: [HACKERS] Timestamp/Interval proposals: Part 2

up my databases, which have to_interval as a replacement for the problematically named interval function. -- -Josh Berkus __AGLIO DATABASE SOLUTIONS___ Josh Berkus Complete information technology [EMAIL PROTECTED

Re: [HACKERS] New string functions; initdb required

... this replaces several of my custom PL/pgSQL functions. How is SIMILAR TO different from ~ ? -- -Josh Berkus __AGLIO DATABASE SOLUTIONS___ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management

Re: [HACKERS] Making serial survive pg_dump

data type, because I feel that I need naming control as well as explicit permissions. SERIAL is a convenience for those who don't want to be bothered ... serious developers hould use DEFAULT NEXTVAL('sequence_name'). -- -Josh Berkus ---(end of broadcast

[HACKERS] Indexing for DESC sorts

Tom, Bruce, Back in 7.1.0, we had a problem where no index could be used on ORDER BY ... DESC statements. Has this been fixed? I'm writing an article on indexing. -Josh Berkus ---(end of broadcast)--- TIP 6: Have you searched our list archives

Re: [HACKERS] [SQL] Request for builtin function: Double_quote

passed to it, including quote marks. Useful for nesting quotes, such as in the EXECUTEing dynamic queries. example result quote_literal('O''Reilly') 'O''Reilly' -Josh Berkus -Josh Berkus ---(end of broadcast)--- TIP 3

Re: [HACKERS] Democracy and organisation : let's make a revolution in the Debian way

. OpenOffice.org is a different story, as an end-user application. So we have a Marketing Project. -- -Josh Berkus Porject Lead, OpenOffice.org Marketing ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

Re: [HACKERS] [SQL] Request for builtin function: Double_quote

Tom, Done; I also added its sister function quote_ident. See the devel docs at http://candle.pha.pa.us/main/writings/pgsql/sgml/functions-string.html Tante Grazie. -- -Josh Berkus ---(end of broadcast)--- TIP 1: subscribe

Re: [HACKERS] Postgres idea list

. -- -Josh Berkus ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] Postgres idea list

, here. 3. There are compatiblity issues between the various JVMs. We'd have to pick a particular JVM and stick with it, and get a lot of complaints from users on other JVMs. I don't know how serious the issues are. -- -Josh Berkus __AGLIO DATABASE SOLUTIONS___

Re: [HACKERS] Postgres idea list

. BTW, does anyone on this list know about Command Prompt, Inc.'s tools? There seems to be a lot of duplicte development going on in the commercial space. -Josh Berkus ---(end of broadcast)--- TIP 6: Have you searched our list archives? http

Re: [HACKERS] Democracy and organisation : let's make a

. I've used it. One area where there is a monumental difference is in license fees. For a single corporation, it does not matter. But for someone who writes database applications that will be delivered to thousands of customers, it is an enormous advantage. Yup. -- -Josh Berkus

Re: [HACKERS] Database comparison ideas

it myself. -- -Josh Berkus ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [HACKERS] Support (was: Democracy and organisation)

- $20,000 a year in licnesing fees -- *not including any support*. Just $2000-$5000 buys you a pretty good $10 million software failure insurance policy. Do the math. As I said, I don't disreagard your argument. Just because it's hogwash doesn't mean that people don't believe it. -Josh Berkus

Re: [HACKERS] Object Oriented Features

, who claims that every OODBMS feature has an answer in the SQL spec that is more consistent and better thought out. -- -Josh Berkus ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [pgaccess-users] RE: [HACKERS] bugzilla.pgaccess.org

Iavor, Any other suggestions? I can tell you from experience that Double-Choco-Latte, another PHP/PostgreSQL tool, is really set up just for single projects. So it would work fine for PGAccess-only. However, DCL has its own problems and is not necessarily better than Mozilla; I personally

Re: [HACKERS] Optimizer bug??

for a tuning discussion. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] tablespaces and DB administration

and/or mounts. P.S. if you signed your e-mails, I'd stop calling you mohawksoft. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe

Re: [HACKERS] On query rewrite

Sailesh, BTW, do lots of people use the GEQO ? I do. I've several clients with data mining databases that literally require 45-way joins on some queries. Even a state-of-the-art CPU balks at that. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] Proposed Query Planner TODO items

to complete, or not? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Converting postgresql.conf parameters to kilobytes

, and as I've thought about the idea over the last 6 months I've come to like it. I'm happy to do the work for this ... it should be relatively easy if everyone's Doc patches are up to date.I can't see any drawback to it; is there something I'm missing? -- -Josh Berkus Aglio Database Solutions San

Re: [pgsql-advocacy] [HACKERS] Slony-I goes BETA

performance (load time) issues with pgFoundry. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so

Re: [HACKERS] Tablespaces

Partition Tables is developed for a combined solution.    But it would be nice to have. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Frequently updated tables

for manufacturers which run on PostgreSQL.What is your definition of enterprise deployment, exactly? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] Improving postgresql.conf

. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] 7.5-dev, pg_dumpall, dollarquoting

as the superuser. Another switch, telling pg_restore to attempt to ignore all errors and restore anyway, would also be keen (though I can see potential abuse issues). Has this already been addressed in CVS? -- Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] 7.5-dev, pg_dumpall, dollarquoting

sorting, and a few objects with long dependency chains simply don't get backed up. I'll see if I can put together a nice demo for this. My concern in reporting this is that there are still a lot of commercial users out there running 7.2, and I'd like to minimize upgrade pain. -- Josh Berkus

Re: [HACKERS] [DEFAULT] Daily digest v1.4537 (18 messages)

far This is the line you should pursue, rather than trying to get people to accept Evgen's patch. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index scan

Re: [HACKERS] lock timeout patch

for this; bascially, the data entry waits for 30 seconds, and then tells the user to try again in 10 minutes. I could do the same thing in PostgreSQL using NOWAIT and a loop on the client side. But the lock timeout is somewhat easier. -- Josh Berkus Aglio Database Solutions San Francisco

<    1   2   3   4   5   6   7   8   9   10   >