Re: [HACKERS] Open Sourcing pgManage

to include one of these GUIs with the source and not the others. I do think that we should consider offering the GUIs alongside the source on the FTP mirrors. Or at least having a big link on the downloads page and the users page to the GUI list. -- -Josh Berkus Aglio Database Solutions San

[HACKERS] Changes to Contributor List

are missing from the list? B) What contributors are listed under Major Developers who haven't contributed any code since 7.1.0? C) Who needs their e-mail address updated? D) Who needs their description updated? (Text, please ... I won't write it) -- -Josh Berkus Aglio Database Solutions San

Re: [HACKERS] Schema boggle...

and then construct *views* which are available in each schema only to that client. Otherwise, as you've discovered, top-level management becomes a royal pain. I'd be happy to discuss this further on PGSQL-SQL, which is really the appropriate mailing list. -- -Josh Berkus Aglio Database

Re: [HACKERS] Changes to Contributor List

Contributors to just Contributors. We'd rather have a Past Contributors? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [pgsql-www] [HACKERS] Changes to Contributor List

Guys, Oh, and how about we kill the Image Map of major developers? It's about 4 years out of date, and makes developers.postgresql.org load like molasses in January. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [pgsql-www] [HACKERS] Changes to Contributor List

Tom, Yeah. It was cute when we did it but it's overkill as a way of pointing out that we have a worldwide development community. We can just say that... I'll be happy to re-do it someday using OOo's imagemapper. But not this week ... -- -Josh Berkus Aglio Database Solutions San

Re: [HACKERS] Changes to Contributor List

dudes. Yeah, you're right,it's confusing we should have two seperate pages, one for What is the PGDG possibly linking to developer., and one page for Contact Us. As it is, they two are munged together. The problem is getting it fixed before 7.4 there are 7 translations -- -Josh

Re: [HACKERS] Changes to Contributor List

, but not come to a specific determination of the level required. However, between you M LinuxWorld etc. your company definitely qualifies. And if we're gonna continue this thread, we should move it to -Advocacy. -- Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] Changes to Contributor List

Peter, I'm a bit lost here. I was discussing specifically the Recognized Corporate Contributors which is, AFAIK, strictly a PHB thing, no? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you

Re: [HACKERS] Changes to Contributor List

Peter, I was discussing specifically the Recognized Corporate Contributors which is, AFAIK, strictly a PHB thing, no? No. Please explain. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1: subscribe

Re: [HACKERS] [pgsql-advocacy] Changes to Contributor List

is not there for you or for people like you. It is there for IT department managers, PHBs, people considering PostgreSQL, and people looking for high-end paid support. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2

Re: [HACKERS] [pgsql-advocacy] Changes to Contributor List

looking for high-end paid support. Great, that's exactly what I wanted to hear. I can't tell over e-mail whether you're agreeing with me or being sarcastic. Clue? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [pgsql-www] [HACKERS] Changes to Contributor List

ambitions to be a PHB? ;-p -- -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] [pgsql-advocacy] Changes to Contributor List

will stay seperate becuase they're based on different technology. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister

Re: [pgsql-www] [HACKERS] Changes to Contributor List

to ditch the old VM the site lives on and get it on our new web VM. On techdocs? What part of that needs to be migrated? -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [pgsql-www] [HACKERS] Changes to Contributor List

Tom, Peter appeared to be asking how additional people could get involved. Or do you *want* to keep the web group too small to get things done? Ooops! Sorry, Peter, I *completely* mis-read your e-mail. -- Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] [DOCS] Annotated release notes

be more than happy to help you. -- 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

Re: [pgsql-www] [HACKERS] Changes to Contributor List

the surveys, I want a Powered by PostgreSQL bug on them, dammit. Those get 21,000 views a week. -- 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

Re: [CORE] [HACKERS] 7.4RC2 regression failur and not running stats collector process

acceptably on other people's Solaris boxes? If this bug is preventing running on Solaris at all, I'd say fix it ... Solaris is a major platform. If it only affects users of one particular Solaris patch version, then we do a big warning and save it for 7.4.1. -- Josh Berkus Aglio Database

[HACKERS] Not 7.5, but 8.0 ?

want PostgreSQL to be the best possible database. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] [pgsql-advocacy] Win32 Port WAS: Not 7.5, but 8.0 ?

it not on Windows. You probably aren't faced with this issue as much in Germany, but it happens often to us folks in the US Canada. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 6: Have you searched our list

Re: [HACKERS] [pgsql-advocacy] Not 7.5, but 8.0 ?

is interested in PostgreSQL Advocacy from whatever perspective, including if you want us to stop doing it. It's an open list ... come join! -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off

Re: [pgsql-www] [HACKERS] Release cycle length

more testing myself is external to PostgreSQL; most of our apps are PHP apps and you can't compile PHP against two different versions of PostgreSQL on the same server. Maybe with User Mode Linux I'll be able to do more testing now.) -- Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Sponsoring enterprise features

are welcome to contact me. -- -Josh Berkus Aglio Database Solutions San Francisco ---(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] [PERFORM] More detail on settings for pgavd?

to play around. I will have real data very soon . -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] [PERFORM] More detail on settings for pgavd?

threshold: 50 records Analyze scale factor: 0.3 -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] [PERFORM] More detail on settings for pgavd?

it? See my post to Matthew. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] [PERFORM] More detail on settings for pgavd?

it in production. Now that I do, I'm interested in improving 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] [PERFORM] More detail on settings for pgavd?

count of tuples or of dead tuples; pg_class holds a reasonable accurate count of pages per table as of last vacuum. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map

Re: [HACKERS] [PERFORM] More detail on settings for pgavd?

, and update after we issue a vacuum. Even easier then. BTW, do we have any provisions to avoid overlapping vacuums? That is, to prevent a second vacuum on a table if an earlier one is still running? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] [PERFORM] More detail on settings for pgavd?

to finish. OK, then, we just need to detect the condition of the vacuums piling up because they are happening too often. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Sponsoring enterprise features

the fruits of this effort. From my perspective, the other oracle-killer that we're missing includes some isolated but difficult improvements in the Query Planner necessary to pass the TPC benchmarks. I'd be happy to discuss those as well, if you like. -- Josh Berkus Aglio Database Solutions San

Re: [HACKERS] Commercial binary support?

Josh, Hans, et. al. Please take this thread OFF LIST IMMEDIATELY. Its content is no longer appropriate for the Hackers mailing list, and we get enough traffic. Flamewars are not a part of our community. -- Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] Commercial binary support?

Hans, Josh, Please take this thread OFF LIST IMMEDIATELY. Sorry. Not enough coffee this AM -- should know better than to send e-mail when I'm short beans. Overreacted a bit, there.Apologies. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] request for feedback - read-only GUC variables,

decoupled and won't be in the forseable future, why bother with 2 variables? -- 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

[HACKERS] Proposed Query Planner TODO items

to: a) recognize an or group query when it sees one; b) break down that query into a multi-part union and estimate the cost However, I'm sure there are other possible solutions. Oracle and MSSQL have solved this particular query problem; anybody know how they do it? -- Josh Berkus Aglio Database

Re: [HACKERS] Proposed Query Planner TODO items

; I copied UNION ALL from a test case which was not generic. In general, one would want UNION. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Proposed Query Planner TODO items

something other than what the planner currently does, which does not complete. Explains later today. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Proposed Query Planner TODO items

to dismantling my office, and running the TPC stuff on my laptop is a joke. I'll contact the OSDL folks to see if they can run it. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once

[HACKERS] Issue with Linux+Pentium SMP Context Switching

of choice: the multi-processor Xeon system. Ideas, anyone? -- 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

Re: [HACKERS] Issue with Linux+Pentium SMP Context Switching

simultaneosly. To me this can only make sense in case there is an other backend trying to use the same memory, and it needs to be moved from 1 CPU to an other. Yes. See above. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] Proposed Query Planner TODO items

Tom, I've made some progress on this over the last week or two. Would it be possible to retry that benchmark with CVS tip? Yes! I'll just need some time to get my laptop set up for running it. My server is, alas, in storage due to me being between offices. -- -Josh Berkus Aglio

Re: [HACKERS] VACUUM delay (was Re: What's planned for 7.5?)

certainly better than not doing anything, particularly if it can be turned off at startup time. -- -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] [pgsql-advocacy] PostgreSQL installation CD based on Morphix

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

Re: [HACKERS] PITR Dead horse?

on Advocacy. The image and the reality don't sync much; we're already about 500% more reliable than MS SQL Server but ask any ten CIOs what they think? That's just marketing. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

[HACKERS] Preventing duplicate vacuums?

crucial issue now since the introduction of vacuum_delay makes overlapping vacuums more probable. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] Preventing duplicate vacuums?

vacuums yet. When tablespaces is finished, presumably the lock would be per tablespace. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

Re: [HACKERS] Preventing duplicate vacuums?

Tom, Yes we do: there's a lock. Sorry, bad test. Forget I said anything. Personally, I would like to have the 2nd vacuum error out instead of blocking. However, I'll bet that a lot of people won't agree with me. -- -Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] session persistent data for plperl

the kinks in error-trapping via eval{}. This would be far more useful that session variables. Just a thought. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map

Re: [HACKERS] RFC: Security documentation

access to the database, a break-in is only a matter of time -- if through nothing else than password-guessing attacks. I'm not sure such a paper is appropriate for the main docs. But it is definitely appropriate for TechDocs. -- Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] RFC: Very large scale postgres support

checked out Clusgres from Linux Labs? One of my clients will be testing this application soon. While we haven't run into transaction throughput limits, a couple of my client's seem to be running in x86's limits on very large queries, particularly on vendor hardware. -- Josh Berkus Aglio

Re: [HACKERS] Proposed Query Planner TODO items

Jenny, For 19, we moved the common conditions out of the big ORs, for 20, we added distinct. We can change the query back if the optimizer can handle it now. Well, we want to test if it can. -- Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] Proposed Query Planner TODO items

Mark, Oh sorry, I completely forgot that Q19 the whole purpose of this. So #60 doesn't have the right Q19. I'll run with the one you want now. Thanks! And the original, not the fixed, Q19 if you please. It's the original that wouldn't finish on Postgres 7.3. -- -Josh Berkus Aglio

Re: [HACKERS] Transaction aborts on syntax error.

to this by default with postgresql; I still prefer the default abort transaction. What would be a much easier integration, IMHO, is offering something like Perl's eval{ } that would allow for special rollback conditions in an application-defined block. -- -Josh Berkus Aglio Database Solutions

Re: [HACKERS] [pgsql-www] Collaboration Tool Proposal

rather have a single copy of a test case on our web site than a couple dozen being e-mailed out. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http

[HACKERS] Collaboration Tool Proposal

. -- -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] bgwriter never dies

one expects occasional failures due to load, one depends on the application log, the syslog and the transaction log being in synch. Otherwise on restart one doesn't know what has or hasn't been committed. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] Collaboration Tool Proposal

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

Re: [pgsql-www] [HACKERS] Collaboration Tool Proposal

it. However, keep in mind that this is a proposal to *try* migrating to GForge. We can reverse the process if we decide it's not worth it. That's why I'd like to start with a few projects at a time. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [pgsql-www] [HACKERS] Collaboration Tool Proposal

insofar as I have time. Terrific! -- -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] [pgsql-www] Collaboration Tool Proposal

People, The question is, do we need BZ right off or should we try GForge's lightweight tool first?Personally I find that BZ is a little intimidating to new users, particularly for searching on issues; as a result it tends to lead to a lot of duplicate filings. -- -Josh Berkus Aglio

Re: [HACKERS] [pgsql-www] Collaboration Tool Proposal

BugZilla to GForge's lighter-weight bug tracking, it turns out that there is a BZ plug-in for GForge. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send

Re: [HACKERS] [pgsql-www] Collaboration Tool Proposal

BZ or GForge; anyone know? Usually it works the other way around; people can't subscribe until they've registered via web. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [HACKERS] [pgsql-www] Collaboration Tool Proposal

with the site. This may be a chicken-and-egg thing, but unless there are several untapped Perl Hackers/Java programmers waiting to jump in and do integration work for RT, Jira, or whatever, any non-PHP solution automatically carries a detraction. -- -Josh Berkus Aglio Database Solutions San

Re: [HACKERS] [pgsql-www] Collaboration Tool Proposal

on MySQL. So, questions: 1) can you compare/contrast RT vs. BZ vs. Simplified bug-tracking, like GForge? 2) What help, if any, would we be able to get in supporting RT from the RT community? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] [pgsql-www] Collaboration Tool Proposal

Mikhail, For a standalone bug/issue tracking tool take a look on http://roundup.sourceforge.net I don't see PostgreSQL support listed -- just SQLite and MySQL. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] Collaboration Tool Proposal -- Summary to date

to current issue processing. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] Collaboration Tool Proposal -- Summary to date

there are people offering to help us. THIS JUST IN: as if we didn't have enough options, Talli of the OpenACS community has offered their help with using OpenACS modules for any of the web tasks we've discussed. More later. -- -Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Collaboration Tool Proposal -- Summary to date

. A revised summary will be fortcoming tommorrow. -- -Josh Berkus __AGLIO DATABASE SOLUTIONS___ Josh Berkus Complete information technology [EMAIL PROTECTED] and data management solutions (415) 565-7293 for law firms

Re: [HACKERS] Slony-I makes progress

. Seriously. I think that Slony should focus on a command-line api and catalogs, and allow the existing GUI projects to build a slony-supporting interface. But I'll join the project and we can have this discussion there. -- Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] raising the default default_statistics_target

in this department would be to extend the multi-column correlation statistics to cover foriegn keys, as a way of improving cross-table estimates. Anyway, keep me in the loop on this, I have a lot of very complex databases I can test such issues on. -- -Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] raising the default default_statistics_target

impossible to find anything in the archives if you don't have some good keywords or at least the author. Is the autor reading this? Will you speak up? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1

Re: [HACKERS] raising the default default_statistics_target

posts per month August to October, I can't find it, and the keywords that I think are obvious don't turn anything up. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once

Re: [HACKERS] raising the default default_statistics_target

possible I'm remembering something else. Darn it, though! 'cause multi-column correlation is one of our big issues on estimates for complex queries. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get

Re: [HACKERS] PITR Functional Design v2 for 7.5

of the DB system is not. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 7: don't forget to increase your free space map settings

Re: [HACKERS] PITR Functional Design v2 for 7.5

, but by the Superuser only. This is used for several settings which are possible to change at runtime but take effect system-wide. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through

Re: [HACKERS] [DEFAULT] Daily digest v1.4318 (23 messages)

are an inefficient throwback to the pre-relational databases of the early 1980's; why would we want them? -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

[HACKERS] Default Stats Revisited

anyway If this proposal is worth considering, I will spend some time building up a test case to demonstrate the cost and utility of the plan. With Neil's help, of course! -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] Default Stats Revisited

wanted to increase the default stats but *forgot* that the index_stats were a multiplier ... I think a straight number is less confusing. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all

Re: [HACKERS] Default Stats Revisited

of DBAs to find out which they would find more accessable. But since most people seem to be ignoring this thread, I'm not sure we'll get much response ... -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3

Re: [HACKERS] Default Stats Revisited

, but will it really help or just be another useless setting? Yeah, that's our next step, a test. On Monday, I hope to have comparative stats for a difficult database on the 3 solutions (leaving things as-is, raising the general default stats, and doing index_stats). -- -Josh Berkus Aglio Database

Re: [HACKERS] Default Stats Revisited

. These columns will be ignored. Expressions have their own stats. Final thought... I'm a DBA and I think the straight number is simpler, though could be convinced to go with whichever is higher... Thanks. -- -Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] The Name Game: postgresql.net vs. pgfoundry.org

, not including the http ... To speak up, I'd rather have either options (A) or (B) thank this option. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please send an appropriate

Re: [HACKERS] Default Stats Revisited

it a practice to hand-hold for database designers who don't know when to index, so I don't think we should start now. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 3: if posting/reading through Usenet, please

Re: [HACKERS] The Name Game: postgresql.net vs. pgfoundry.org

Robert, maybe pgsqlfoundry is a better compromise? No, too long.People'd end up calling it pgFoundry anyway. Besides, Gavin Roy already designed us a nice pgFoundry logo. ;-) -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

Re: [HACKERS] [DEFAULT] Daily digest v1.4327 (22 messages)

but isn't particularly important given the truly substantial number of external OSS tools designed to handle the problem. You might consider educating your customers about those tools instead -- several of which ship on the redhat CDs, I believe. -- Josh Berkus Aglio Database Solutions San

Re: [HACKERS] The Name Game: postgresql.net vs. pgfoundry.org

convince him to let us have the domain. Is it worth asking? Hmmm ... please let Core handle this. -- 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

Re: [pgsql-www] [HACKERS] The Name Game: postgresql.net vs.

Tom, Since we do already own pgfoundry.org, could we satisfy everybody by dual-naming the project sites? That is, have both project.pgfoundry.org project.pgfoundry.postgresql.org point to the same place? Sounds good to me if it's doable via DNS. -- -Josh Berkus Aglio

Re: [HACKERS] listening addresses

that this wouldn't work with packages. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Further thoughts about warning for costly FK checks

of DBAs are the same. -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] listening addresses

Tom, No, the default should be localhost. Your thinking is too IPv4-centric. Good point. My clients are all years away from implementing Ipv6, so I tend to forget about it. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast

[HACKERS] Constraints pg_dump

Folks, Last month, there was a discussion about deferring constraints that use user-defined functions to the end of the pg_dump file, like we do with FK constraints.Did this go anywhere, or is it still a TODO in search of an owner? -- -Josh Berkus Aglio Database Solutions San Francisco

Re: [HACKERS] Constraints pg_dump

-constraint issues ... is to push all constraints containing a user-defined function to the end of the file with the foriegn keys. (this is for the Bricolage project) -- Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 9

Re: [HACKERS] Constraints pg_dump

that is the appropriate topic for a constraint.However, I can see how it would be difficult to implement as one What about table-level check constraints? Seems like one of those should be able to be used to check a vertical assertion within a table. Or do we need SQL ASSERTION for this? -- -Josh Berkus

Re: [HACKERS] Constraints pg_dump

... they want only active user names to be unique. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere

Re: [HACKERS] Constraints pg_dump

Tom, Oh, why didn't you say so? Seems like the correct tool to solve that is a partial unique index, not a constraint at all. Hmmm we support that?Darn, how do I miss these things. When did we start supporting it? Bric still has a lot of users who use 7.2. -- -Josh Berkus

Re: [HACKERS] COPY formatting

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

[HACKERS] Authentication drop-down?

of applicable lines in pg_hba.conf would the user be rejected. Any reason why this is a bad idea? It would improve the lives of a lot of kerberos and SSL users who have to deal with flaky authentication issues. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end

Re: [HACKERS] COPY formatting

.We should be looking at a client utility, like pg_import and pg_export. The primary purpose of COPY is bulk loads for backup/restore, and I'm against doing a lot of tinkering which might make it less efficient or introduce new issues into what's currently very reliable. -- -Josh Berkus

Re: [PERFORM] [HACKERS] fsync method checking

. Why not just recruit a bunch of people on PERFORMANCE and GENERAL to test the 4 different synch methods using real databases? No test like reality, I say 2) Won't Jan's work on 7.5 memory and I/O management mean that we have to re-evaluate synching anyway? -- -Josh Berkus Aglio

  1   2   3   4   5   6   7   8   9   10   >