Re: [HACKERS] Open Sourcing pgManage

2003-11-04 Thread Josh Berkus
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

2003-11-05 Thread Josh Berkus
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...

2003-11-05 Thread Josh Berkus
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

2003-11-05 Thread Josh Berkus
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

2003-11-05 Thread Josh Berkus
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

2003-11-05 Thread Josh Berkus
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

2003-11-05 Thread Josh Berkus
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

2003-11-06 Thread Josh Berkus
, 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

2003-11-06 Thread Josh Berkus
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

2003-11-06 Thread Josh Berkus
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

2003-11-06 Thread Josh Berkus
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

2003-11-06 Thread Josh Berkus
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

2003-11-06 Thread Josh Berkus
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

2003-11-07 Thread Josh Berkus
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

2003-11-07 Thread Josh Berkus
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

2003-11-07 Thread Josh Berkus
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

2003-11-03 Thread Josh Berkus
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

2003-11-10 Thread Josh Berkus
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

2003-11-14 Thread Josh Berkus
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 ?

2003-11-17 Thread Josh Berkus
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 ?

2003-11-18 Thread Josh Berkus
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 ?

2003-11-18 Thread Josh Berkus
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

2003-11-18 Thread Josh Berkus
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

2003-11-18 Thread Josh Berkus
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?

2003-11-19 Thread Josh Berkus
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?

2003-11-20 Thread Josh Berkus
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?

2003-11-20 Thread Josh Berkus
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?

2003-11-20 Thread Josh Berkus
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?

2003-11-21 Thread Josh Berkus
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?

2003-11-21 Thread Josh Berkus
, 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?

2003-11-21 Thread Josh Berkus
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

2003-11-22 Thread Josh Berkus
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?

2003-11-25 Thread Josh Berkus
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?

2003-11-25 Thread Josh Berkus
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,

2003-12-05 Thread Josh Berkus
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

2003-12-05 Thread Josh Berkus
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

2003-12-05 Thread Josh Berkus
; 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

2003-12-09 Thread Josh Berkus
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

2003-12-19 Thread Josh Berkus
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

2003-12-19 Thread Josh Berkus
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

2003-12-19 Thread Josh Berkus
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

2004-01-06 Thread Josh Berkus
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?)

2004-01-19 Thread Josh Berkus
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

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

Re: [HACKERS] Recursive queries?

2004-02-04 Thread Josh Berkus
are of course good for GBorg. If we're to implement recursive queries, we should implement the SQL99 standard. -- -Josh Berkus Aglio Database Solutions San Francisco ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [HACKERS] Recursive queries?

2004-02-04 Thread Josh Berkus
of functionality that the SQL99 standard is missing, which would be persuasive; we have included sequences and LIMIT, after all.But even then I would question the term; I've never found CONNECT BY to be particularly intuitive. RECURSIVE JOIN would make far more sense. -- -Josh Berkus Aglio Database

Re: [HACKERS] PITR Dead horse?

2004-02-04 Thread Josh Berkus
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?

2004-02-05 Thread Josh Berkus
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?

2004-02-05 Thread Josh Berkus
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?

2004-02-05 Thread Josh Berkus
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

2004-02-09 Thread Josh Berkus
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

2004-02-09 Thread Josh Berkus
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

2004-02-09 Thread Josh Berkus
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

2004-02-09 Thread Josh Berkus
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

2004-02-12 Thread Josh Berkus
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.

2004-02-13 Thread Josh Berkus
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

2004-02-26 Thread Josh Berkus
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

2004-02-26 Thread Josh Berkus
. -- -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

2004-02-26 Thread Josh Berkus
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

2004-02-26 Thread Josh Berkus
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

2004-02-26 Thread Josh Berkus
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

2004-02-26 Thread Josh Berkus
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

2004-02-26 Thread Josh Berkus
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

2004-02-26 Thread Josh Berkus
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

2004-02-26 Thread Josh Berkus
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

2004-02-27 Thread Josh Berkus
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

2004-02-27 Thread Josh Berkus
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

2004-02-27 Thread Josh Berkus
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] [pgsql-www] Collaboration Tool Proposal

2004-02-28 Thread Josh Berkus
Folks, Tim Perdue sent me this. -- -Josh Berkus Aglio Database Solutions San Francisco ---BeginMessage--- Josh Berkus wrote: Tim, To follow up on the previous question, there are a few features that I'm not seeing in the GForge demo online. These are all features that our developers

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

2004-02-29 Thread Josh Berkus
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

2004-02-29 Thread Josh Berkus
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

2004-03-01 Thread Josh Berkus
. 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

2004-03-04 Thread Josh Berkus
. 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

2004-03-08 Thread Josh Berkus
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

2004-03-08 Thread Josh Berkus
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

2004-03-08 Thread Josh Berkus
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

2004-03-09 Thread Josh Berkus
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

2004-03-09 Thread Josh Berkus
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

2004-03-09 Thread Josh Berkus
, 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)

2004-03-10 Thread Josh Berkus
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

2004-03-10 Thread Josh Berkus
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

2004-03-11 Thread Josh Berkus
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

2004-03-11 Thread Josh Berkus
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

2004-03-11 Thread Josh Berkus
, 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

2004-03-11 Thread Josh Berkus
. 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

2004-03-11 Thread Josh Berkus
, 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

2004-03-11 Thread Josh Berkus
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

2004-03-12 Thread Josh Berkus
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)

2004-03-12 Thread Josh Berkus
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

2004-03-12 Thread Josh Berkus
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.

2004-03-12 Thread Josh Berkus
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

2004-03-15 Thread Josh Berkus
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

2004-03-15 Thread Josh Berkus
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

2004-03-15 Thread Josh Berkus
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

2004-03-15 Thread Josh Berkus
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

2004-03-16 Thread Josh Berkus
-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

2004-03-17 Thread Josh Berkus
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

2004-03-17 Thread Josh Berkus
... 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

2004-03-17 Thread Josh Berkus
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

2004-03-18 Thread Josh Berkus
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

  1   2   3   4   5   6   7   8   9   10   >