Re: [HACKERS] nomenclature

2004-01-16 Thread Jeff Davis
character to the software. Unless there's some kind of advocacy issue (i.e. people are avoiding the database because of perception), I can't think of much reason. Regards, Jeff Davis ---(end of broadcast)--- TIP 4: Don't 'kill

Re: [HACKERS] License question

2004-04-22 Thread Jeff Davis
it along with the postgresql-licensed code. Regards, Jeff Davis ---(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

Re: FW: [HACKERS] Advice: Where could I be of help?

2002-10-02 Thread Jeff Davis
to the statistics system. The planner might be smart, but if it doesn't have any more information you might not be able to get any more out of it. Autovacuum might help with that as well (i.e. the info will be more up to date). Regards, Jeff Davis ---(end

Re: [HACKERS] Anyone else having list server problems?

2002-10-05 Thread Jeff Davis
I believe I've missed some mails as well, but I think that was a day or two ago. I don't think I've missed any in the last day. Regards, Jeff Davis On Saturday 05 October 2002 06:41 am, Curtis Faith wrote: I've been getting only about 60% of the emails sent to the list. I see many

Re: [HACKERS] [GENERAL] Postgres-based system to run .org registry?

2002-10-14 Thread Jeff Davis
dept. (wink wink) should come up with a press release. Robert Treat Don't worry about Oracle, they don't need real customers. Their database market consists of a healthy balance of real and fictitious people. See http://slashdot.org/articles/02/04/17/179252.shtml?tid=98 Regards, Jeff

Re: [HACKERS] MySQL vs PostgreSQL.

2002-10-11 Thread Jeff Davis
They also state that they have more sophisticated ALTER TABLE... Only usable feature in their ALTER TABLE that doesn't (yet) exist in PostgreSQL was changing column order (ok, the order by in table creation could be nice), and that's still almost purely cosmetic. Anyway, I could have used

Re: [HACKERS] MySQL vs PostgreSQL.

2002-10-11 Thread Jeff Davis
I still remember a post from somebody on the phpbuilder site that had changed a field from varchar to date and all the dates he had got changed to -00-00. He most unimpressed, especially since he (being typical of a lot of MySQL users) didn't have a backup. Ah, yes. Classic. I was

Re: [HACKERS] MySQL vs PostgreSQL.

2002-10-11 Thread Jeff Davis
, that doesn't lose your data until after you've had a chance to look at the new stuff. Regards, Jeff On Friday 11 October 2002 07:16 pm, you wrote: On Fri, Oct 11, 2002 at 07:08:18PM -0700, Jeff Davis wrote: And it really is a minor matter of convenience. I end up dropping and recreating

Re: Changing Column Order (Was Re: [HACKERS] MySQL vs PostgreSQL.)

2002-10-12 Thread Jeff Davis
Did attlognum's (for changing column order) get implemented for 7.2 ? I cannot think of any reason why changing column order should be implemented in Postgres. Seems like a waste of time/more code bloat for something which is strictly asthetic. Regardless, I do have collegues/clients who

Re: [HACKERS] Windows Build System - My final thoughts

2003-01-31 Thread Jeff Davis
. Interesting consolation :) Regards, Jeff Davis ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Re: [HACKERS] Roadmap for FE/BE protocol redesign

2003-03-20 Thread Jeff Davis
handled in the query-result output formatting functions like you suggest, that would seem like a much cleaner solution. Regards, Jeff Davis ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command

Re: [HACKERS] pgsql_data/base mapping

2002-05-06 Thread Jeff Davis
The numbers are the same as the oids found in pg_database (as you expected). This question is better suited for the -general list, for future reference. Regards, Jeff On Monday 06 May 2002 04:31 pm, Laurette Cisneros wrote: Are the numbers of the directories in the base diretory and

[HACKERS] listen/notify argument (old topic revisited)

2002-07-02 Thread Jeff Davis
A while ago, I started a small discussion about passing arguments to a NOTIFY so that the listening backend could get more information about the event. There wasn't exactly a consensus from what I understand, but the last thing I remember is that someone intended to speed up the notification

Re: [HACKERS] listen/notify argument (old topic revisited)

2002-07-03 Thread Jeff Davis
On Tuesday 02 July 2002 06:03 pm, Bruce Momjian wrote: Let me tell you what would be really interesting. If we didn't report the pid of the notifying process and we didn't allow arbitrary strings for notify (just pg_class relation names), we could just add a counter to pg_class that is

Re: [HACKERS] Why is MySQL more chosen over PostgreSQL?

2002-07-30 Thread Jeff Davis
2. I expect that even most PostgreSQL--or even database--experts don't have a real understanding of relational theory, anyway. That we still have table inheritance shows that. As far as I can tell, there is nothing whatsoever that table inheritance does that the relational model does not

Re: [HACKERS] Why is MySQL more chosen over PostgreSQL?

2002-08-02 Thread Jeff Davis
Well, if you also have soundcard_products, in your example you could have a product which is both a networkcard AND a soundcard. No way to restrict that a product can be only one 'subclass' at a time... If you can make that restriction using the relational model, you can do the same as with

Re: [HACKERS] Beta1 schedule

2002-09-04 Thread Jeff Davis
Line 72 of the HISTORY file (the one in 7.3b1 that Marc just packaged) reads: * Pre-6.3 clients are no longer supported. Is that supposed to be 7.3? I assume you're referring to the catalog changes, c. that make old clients that are dependent on them behave incorrectly. Regards, Jeff

Re: [HACKERS] Inheritance

2002-09-05 Thread Jeff Davis
, but can with inheritance, I might be convinced otherwise. Regards, Jeff Davis On Thursday 05 September 2002 01:05 am, Hannu Krosing wrote: On Thu, 2002-09-05 at 03:57, Curt Sampson wrote: On Tue, 3 Sep 2002, Bruce Momjian wrote: Yep, this is where we are stuck; having an index

Re: [HACKERS] Inheritance

2002-09-05 Thread Jeff Davis
agreed with everything else you said. As you might have guessed, I don't much like most object-oriented languages if that's what they're going to try to tell me I have to do. Python works nicely, however :) Regards, Jeff Davis [1] Come to think of it, the JOIN operator seems to, at least

Re: [HACKERS]

2002-09-11 Thread Jeff Davis
Is it not enough to defer all views until the end? Why would they be needed any sooner? I would think that views of views, or permissions on views, or prepared statements might need the right view to be declared first. There may be other examples as well. Your solution might be better

Re: [HACKERS]

2002-09-13 Thread Jeff Davis
My vote is tough, time to fix your SQL code. Sounds good to me, but please document it in the migration notes. No need for a surprise. Regards, Jeff ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister

[HACKERS] A couple items on TODO

2001-08-23 Thread Jeff Davis
the difficulties or affected areas of code would be appreciated. I suppose if the items made it to TODO, they will take more than a couple minutes to fix. Regards, Jeff Davis ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] A couple items on TODO

2001-08-23 Thread Jeff Davis
*Add use of 'const' for variables in source tree I would discuss this item with the hackers list and see exactly what people want done with it. I have noticed while working on command.c and heap.c that half the functions pass 'const char *' and the other half pass just 'char *'. This

Re: [HACKERS] Again, sorry, caching.

2002-03-19 Thread Jeff Davis
Yes...I was thinking that a generic library interface with a nice design pattern might meet this need rather well. Done properly, I think we can make it where all that, more or less, would be needed is application hooks which accept the result set to be cached and a mechanism to signal

Re: [HACKERS] Suggestion for optimization

2002-04-05 Thread Jeff Davis
It would be nice if total table cardinality could be maintained live. How would this work with MVCC? It wouldn't. That's why it's not there. Under MVCC, table cardinality is in the eye of the beholder... That makes me curious how oracle implements it. I was under the impression that

Re: [HACKERS] Suggestion for optimization

2002-04-05 Thread Jeff Davis
I don't think your idea would work for a concurrent user setup where people have different transactions started at different times with different amounts of changes inside each transaction. That's why it would have to be tracked on a per connection basis for all the tables. I tried it out

Re: [HACKERS] Why hash indexes suck

2004-06-05 Thread Jeff Davis
On Sat, 2004-06-05 at 13:31, Tom Lane wrote: Only if you want to require a hash opclass to supply ordering operators, which sort of defeats the purpose I think. Hash is only supposed to need equality not ordering. Is it possible to assume some kind of ordering (i.e. strcmp() the binary data

Re: [HACKERS] Slony-I goes BETA (possible bug)

2004-06-06 Thread Jeff Davis
case someone had in mind when implementing the SET ADD SEQUENCE for slonik? Regards, Jeff Davis ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

Re: [HACKERS] Slony-I goes BETA (possible bug)

2004-06-06 Thread Jeff Davis
commits. Perhaps you can issue a notify for each transaction that modifies a replicated table and slon could listen for that notification? That way, it wouldn't SYNC before the transaction commits and miss the uncommitted data. Regards, Jeff Davis ---(end

Re: [HACKERS] Slony-I goes BETA (possible bug)

2004-06-07 Thread Jeff Davis
On Mon, 2004-06-07 at 06:20, Jan Wieck wrote: I tend to agree with you that spurious SYNC's aren't the end of the world. The idea of using notify to tell the syncThread somthing happened is probably the right way to do it, but at this time a little invasive. We need more time to investigate

Re: [HACKERS] Open items

2004-08-02 Thread Jeff Davis
, Jeff Davis ---(end of broadcast)--- TIP 6: Have you searched our list archives? http://archives.postgresql.org

Re: [HACKERS] How to crash postgres using savepoints

2004-08-03 Thread Jeff Davis
for me. Regards, Jeff Davis Sequence that causes crash: test=# begin; BEGIN test=# savepoint a; SAVEPOINT test=# rollback to b; server closed the connection unexpectedly This probably means the server terminated abnormally before or while processing the request

Re: [HACKERS] How to crash postgres using savepoints

2004-08-03 Thread Jeff Davis
On Tue, 2004-08-03 at 03:41, Gavin Sherry wrote: Attached is a patch fixing this. One question I do have: if (target-savepointLevel != s-savepointLevel) Will this ever be true in the current code? I cannot see anything setting savepointLevel explicitly. From reading the lists, it

Re: [HACKERS] 8.0 Open Items

2004-08-21 Thread Jeff Davis
On Sat, 2004-08-21 at 11:26, Bruce Momjian wrote: Tom Lane wrote: snip No, not at all. A nonfunctional catalog entry gets in the way of the user replacing the function, should he wish to do that. Yea, but I would call the odds of that pretty negligible. What if they're trying to restore

Re: [HACKERS] Aubit 4GL for postgresql

2004-11-29 Thread Jeff Davis
I just finished doing a brief evaluation of informix-4gl. I was going to do some non-4gl work for a company that uses 4gl extensively, so I just wanted to get an idea where they were coming from. I am interested in that PostgreSQL port, but right now it's just academic. Regards, Jeff

Re: [HACKERS] Enticing interns to PostgreSQL

2005-07-20 Thread Jeff Davis
there will be opportunities to mention PostgreSQL. Also, there's a PostgreSQL project that I'm planning on working on (not even much work left, really), so I'll see if the professor shows any interest in my project. Regards, Jeff Davis ---(end of broadcast

Re: [HACKERS] #escape_string_warning = off

2005-08-02 Thread Jeff Davis
, Jeff Davis Marko Kreen wrote: On Mon, Aug 01, 2005 at 11:58:34AM -0700, Joshua D. Drake wrote: What might this be? Whether to warn on '\' in non-E'' strings. AFAIK Bruce wants to turn this to 'on' in 8.2. ---(end of broadcast

Re: [HACKERS] #escape_string_warning = off

2005-08-02 Thread Jeff Davis
Dennis Bjorklund wrote: On Mon, 1 Aug 2005, Jeff Davis wrote: Does the SQL standard provide no way to have a NULL character in a string constant? Is single-quote the only special character? I don't think it forbids you from using the null character. It's not like the strings are zero

Re: [HACKERS] #escape_string_warning = off

2005-08-02 Thread Jeff Davis
Dennis Bjorklund wrote: On Tue, 2 Aug 2005, Jeff Davis wrote: Does the SQL standard provide no way to have a NULL character in a string constant? Is single-quote the only special character? I don't think it forbids you from using the null character. It's not like the strings are zero

Re: [HACKERS] TODO questions

2005-08-24 Thread Jeff Davis
The current behavior is (b), but many think (a) is more intuitive in the context of a configuration file. Perhaps (b) would be more intuitive if it were in the context of (for example) an admin tool that took options on standard input. Regards, Jeff Davis ---(end

Re: [HACKERS] PG Killed by OOM Condition

2005-10-03 Thread Jeff Davis
that feature in linux. Nobody has been able to explain to me why linux is the only OS with an OOM Killer. If someone here has more information, I'd like to know. When using linux I always set vm_overcommit=2. Regards, Jeff Davis ---(end of broadcast

Re: [HACKERS] PG Killed by OOM Condition

2005-10-04 Thread Jeff Davis
, mark Thanks, a very informative reply. Do you have some references where I can learn more? I think that I've run into the OOM killer without a fork() being involved, but I could be wrong. Is it possible to be hit by the OOM killer if no applications use fork()? Regards, Jeff Davis

Re: [HACKERS] PG Killed by OOM Condition

2005-10-25 Thread Jeff Davis
to 2, wouldn't postgres get a memory allocation error, rather than a hung machine? By the way, what does FreeBSD do? I've never had any memory allocation related headaches on that platform (although I'm fairly new to FreeBSD). Regards, Jeff Davis ---(end

Re: [HACKERS] Improving count(*)

2005-11-17 Thread Jeff Davis
one key indexed on the table would counteract those benefits. I haven't noticed any recent comments by the hackers on this subject. Maybe they have some more details? I think MS SQL has something similar to that also. Regards, Jeff Davis ---(end of broadcast

Re: [HACKERS] Where do I get the spec for PostgreSQL

2005-01-01 Thread Jeff Davis
I think that the documentation as well as the code itself are the specifications of postgresql. Regards, Jeff Davis On Mon, 2004-12-27 at 18:02 -0800, Benjamin Arai wrote: Where can I obtain a spec for postgresql, so I can start looking at the code? Benjamin [EMAIL PROTECTED

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-12 Thread Jeff Davis
of other operations). Now, it seems like it might make a little more sense to use an index for min()/max(), but that's a different story. Regards, Jeff Davis ---(end of broadcast)--- TIP 8: explain analyze is your friend

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-12 Thread Jeff Davis
a smaller amount of data (so that the visibility information is more dense). Make a narrow table, and seqscan over that. Then, if you need more attributes in the table, just do a one-to-one join with a seperate table. Regards, Jeff Davis ---(end of broadcast

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-12 Thread Jeff Davis
actually does? Regards, Jeff Davis ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-12 Thread Jeff Davis
worries away in an efficient way. I am just saying that hopefully we don't have to seqscan a table with wide tuples very often :) Regards, Jeff Davis ---(end of broadcast)--- TIP 9: the planner will ignore your desire to choose an index

Re: [HACKERS] ARC patent

2005-01-17 Thread Jeff Davis
I think there is zero probability of being sued by IBM in the near future. They would instantly destroy the credibility and good relationships they've worked so hard to build up with the entire open source community. However, I don't want to be beholden to IBM indefinitely --- in five

Re: [HACKERS] ARC patent

2005-01-17 Thread Jeff Davis
, or only the didn't-know-better kind? Right now I don't think we can claim didn't-know-better. Also, does stop mean stop distributing the patented process, or stop using all installations? Regards, Jeff Davis ---(end of broadcast)--- TIP 3

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-18 Thread Jeff Davis
compliant? Regards, Jeff Davis ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-18 Thread Jeff Davis
wanted to be reminded about complicated locking issues ( I suppose I must have known that at one time, but perhaps I surpressed it ;-) Regards, Jeff Davis ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ

Re: [HACKERS] Much Ado About COUNT(*)

2005-01-19 Thread Jeff Davis
and you don't need to think about it. Regards, Jeff Davis On Wed, 2005-01-19 at 17:40 -0300, Alvaro Herrera wrote: On Wed, Jan 19, 2005 at 10:16:38AM -0600, Bruno Wolff III wrote: On Wed, Jan 19, 2005 at 14:59:17 -, Mark Cave-Ayland [EMAIL PROTECTED] wrote: So then I would

Re: [HACKERS] Proposed TODO: fetch-INT8

2005-01-24 Thread Jeff Davis
Is there a practical use for retrieving 2^31 records at once? (this is a serious question, I'm not arguing that it should cause a syntax error) Regards, Jeff Davis On Mon, 2005-01-24 at 14:13 -0500, Merlin Moncure wrote: I was browsing the TODO list and I noticed the todo to bump

Re: [HACKERS] Interpretation of TRUSTED

2005-02-08 Thread Jeff Davis
to the language, not the user of the language. Regards, Jeff Davis ---(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] Transaction Aborted

2005-02-20 Thread Jeff Davis
I think that the feature you're looking for is a SAVEPOINT. After the import, create a savepoint, and then if the user makes a typo revert to that savepoint. Regards, Jeff Davis On Sun, 2005-02-20 at 22:05 -0500, Edwin S. Ramirez wrote: Hello, This may sound familiar since

[HACKERS] idea for concurrent seqscans

2005-02-25 Thread Jeff Davis
, and I'd also be happy to bring the code to production quality. However, before I spend too much more time on that, I'd like to get a general response from a 3rd party to let me know if I'm off base. Regards, Jeff Davis --- postgresql-8.0.0/src/backend/access/heap/heapam.c 2004-12-31 13:59

Re: [HACKERS] idea for concurrent seqscans

2005-02-25 Thread Jeff Davis
On Fri, 2005-02-25 at 13:38 +, Simon Riggs wrote: On Fri, 2005-02-25 at 00:34 -0800, Jeff Davis wrote: I had an idea that might improve parallel seqscans on the same relation. If you have lots of concurrent seqscans going on a large relation, the cache hit ratio is very low

Re: [HACKERS] idea for concurrent seqscans

2005-02-25 Thread Jeff Davis
On Fri, 2005-02-25 at 12:54 -0500, Tom Lane wrote: Jeff Davis [EMAIL PROTECTED] writes: (1) Do we care about reverse scans being done with synchronized scanning? If so, is there a good way to know in advance whether it is going to be a forward or reverse scan (i.e. before heap_getnext

Re: [HACKERS] idea for concurrent seqscans

2005-02-25 Thread Jeff Davis
On Fri, 2005-02-25 at 13:30 -0500, Tom Lane wrote: Jeff Davis [EMAIL PROTECTED] writes: I didn't consider that. Is there a reason the regression tests assume the results will be returned in a certain order (or a consistent order)? We use diff as the checking tool. Well, that does make

Re: [HACKERS] idea for concurrent seqscans

2005-02-25 Thread Jeff Davis
On Fri, 2005-02-25 at 18:03 -0600, Jim C. Nasby wrote: On Fri, Feb 25, 2005 at 01:30:57PM -0500, Tom Lane wrote: Jeff Davis [EMAIL PROTECTED] writes: I didn't consider that. Is there a reason the regression tests assume the results will be returned in a certain order (or a consistent

Re: [HACKERS] idea for concurrent seqscans

2005-02-26 Thread Jeff Davis
. If someone thinks locks are required, please let me know. Currently, if there is inconsistent data in the shared memory area the worst that can happen is no worse than the current behavior. Regards, Jeff Davis --- postgresql-8.0.0/src/backend/access/heap/heapam.c 2004-12-31 13:59

Re: [HACKERS] idea for concurrent seqscans

2005-02-26 Thread Jeff Davis
Thanks for the information. On Sat, 2005-02-26 at 23:39 +1100, Neil Conway wrote: Jeff Davis wrote: I have a newer version of my Synchronized Scanning patch which hopefully makes it closer to a real patch, the first one was more of a proof of concept. A few minor comments: - context

Re: [HACKERS] idea for concurrent seqscans

2005-02-26 Thread Jeff Davis
On Sat, 2005-02-26 at 10:16 -0600, Jim C. Nasby wrote: On Sat, Feb 26, 2005 at 12:22:45AM -0800, Jeff Davis wrote: * I expanded the shared memory to be a static hash table (currently set to a size of 8KB, but that is a one line change if that's too big). Now it can keep track of many scans

Re: [HACKERS] About b-tree usage

2005-03-06 Thread Jeff Davis
the spatial locality of the tuples in the table). Index size alone shouldn't destroy your performance, since the idea of an index lookup is that it only has to read O(log n) pages from the disk per lookup. Regards, Jeff Davis On Sun, 2005-03-06 at 23:33 +0200, Ioannis Theoharis wrote

Re: [HACKERS] About b-tree usage

2005-03-07 Thread Jeff Davis
) It doesn't have to read the index's disk pages at all. I suspect you don't need to return all the tuples in the table. If you include the details of a real scenario perhaps the people on the list could be more helpful. Regards, Jeff Davis On Mon, 2005-03-07 at 20:43 +0200, Ioannis

Re: [HACKERS] About b-tree usage

2005-03-09 Thread Jeff Davis
into account in postgres? I don't entirely understand what you're asking. It seems like you're talking about a relatively minor implementation issue, and if it does make a difference, it would probably not be very much. Perhaps rephrase your question? On Mon, 7 Mar 2005, Jeff Davis wrote

Re: [HACKERS] Problem with PITR recovery

2005-04-17 Thread Jeff Davis
a little clarification on the steps to make absolutely sure that the base backup I have is viable. Can you sort of run through the failure case again, and how to prevent it? Regards, Jeff Davis On Sun, 2005-04-17 at 21:38 -0400, Bruce Momjian wrote: Bruce Momjian wrote: I figured

Re: [HACKERS] Problem with PITR recovery

2005-04-18 Thread Jeff Davis
On Mon, 2005-04-18 at 00:20 -0400, Bruce Momjian wrote: Jeff Davis wrote: Can you sort of run through the failure case again, and how to prevent it? The failure case in the original docs is that you do your pg_stop_backup(), and then delete all the WAL file before the *.backup file

Re: [HACKERS] Problem with PITR recovery

2005-04-19 Thread Jeff Davis
. (2) Making PITR easier to administer, probably for 8.1. (3) Adding features to PITR, probably for 8.1. If what I said above is incorrect, please correct me, because that means that I'm one of the lost DBAs that Oleg is talking about. Regards, Jeff Davis ---(end

Re: [HACKERS] Google's Summer of Code ...

2005-06-05 Thread Jeff Davis
in PostgreSQL, I would certainly talk with any mentors about the potential project, and what the scope would be. Regards, Jeff Davis ---(end of broadcast)--- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org

[HACKERS] alter table drop column

2001-01-11 Thread Jeff Davis
t is cleaned out with a vacuum (before it is cleaned out), although I am not sure how feasible this is, and it isn't particularly important to me. Regards, Jeff -- Jeff Davis Dynamic Works [EMAIL PROTECTED] http://dynworks.com

Re: [HACKERS] User-defined typle similar to char(length)

2006-08-04 Thread Jeff Davis
a database to PostgreSQL. For instance, if they are using MySQL and use the enum type, they might not have the time to change all the database schema to be relational. Instead, they could create their own enum type in postgresql and it could work the same way. Regards, Jeff Davis

Re: [HACKERS] Plugins redux (was Re: [PATCHES] PL instrumentation

2006-08-09 Thread Jeff Davis
this is a trivial question, but is there some kind of lock that would prevent the PG_fini for the plpgsql debugger from executing after if(*plugin_ptr) and before ((*plugin_ptr)-function_field)(...)? Regards, Jeff Davis ---(end of broadcast)--- TIP 4

[HACKERS] Coding style for emacs

2006-08-10 Thread Jeff Davis
columns. What emacs scripts do the hackers use? Is that documentation out of date? Regards, Jeff Davis ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL

Re: [HACKERS] Replication

2006-08-21 Thread Jeff Davis
On Mon, 2006-08-21 at 11:33 -0400, AgentM wrote: I would imagine that multi-master synchronous replication would be fairly trivial to implement with 2PC and wal-shipping available, no? How does WAL shipping help synchronous replication? Regards, Jeff Davis

Re: [HACKERS] Replication

2006-08-21 Thread Jeff Davis
On Mon, 2006-08-21 at 19:42 +0200, Markus Schiltknecht wrote: Jeff Davis wrote: How does WAL shipping help synchronous replication? The WAL is written _before_ commit, logging all the changes the transaction wants to write to the disk. This makes it look very similar to what is needed

Re: [HACKERS] Replication

2006-08-23 Thread Jeff Davis
to replicate over), but clients can still connect to both servers? Then you have two systems that both think that the other system went down, and both start accepting transactions. Now you no longer have replication at all. Regards, Jeff Davis ---(end of broadcast

Re: [HACKERS] Replication

2006-08-24 Thread Jeff Davis
On Thu, 2006-08-24 at 11:18 +0200, Markus Schiltknecht wrote: Hi, Jeff Davis wrote: I disagree about high-availability. In fact, I would say that sync replication is trading availability and performance for synchronization (which is a valid tradeoff, but costly). In a way, replication

Re: [HACKERS] Replication

2006-08-25 Thread Jeff Davis
On Fri, 2006-08-25 at 11:23 +0200, Markus Schiltknecht wrote: Jeff Davis wrote: Which doesn't work very well in the case of two groups of servers set up in two physical locations. I can see two possibilities: (1) You require a quorum to be effective, in which case your cluster

Re: [HACKERS] Prepared statements considered harmful

2006-08-31 Thread Jeff Davis
implementations of planner hints, but there is some reasonable level of discussion. Regards, Jeff Davis ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] @ versus ~, redux

2006-09-05 Thread Jeff Davis
to me to do: x @= y x contains or equals y x =@ y y is contained in or equals y It seems more natural to me because the operators are symmetrical. Am I missing the mnemonic value of your form? Regards, Jeff Davis ---(end

Re: [HACKERS] New Linux Filesystem: NILFS

2006-09-05 Thread Jeff Davis
the data all over the disk, which destroys the sequential access that PostgreSQL depends on for efficient index and table scans. Do you see an advantage in using LFS for PostgreSQL? Did the quotation refer to people leaving write cache enabled on a journaling filesystem? Regards, Jeff

Re: [HACKERS] @ versus ~, redux

2006-09-06 Thread Jeff Davis
On Tue, 2006-09-05 at 23:00 -0400, Tom Lane wrote: Jeff Davis [EMAIL PROTECTED] writes: On Mon, 2006-09-04 at 10:45 -0400, Tom Lane wrote: The existing geometric containment tests seem to be nonstrict, so if we wanted to leave room to add strict ones later, it might be best to settle

Re: [HACKERS] New Linux Filesystem: NILFS

2006-09-06 Thread Jeff Davis
On Tue, 2006-09-05 at 23:28 -0400, [EMAIL PROTECTED] wrote: On Tue, Sep 05, 2006 at 05:54:50PM -0700, Jeff Davis wrote: On Tue, 2006-09-05 at 18:24 -0400, Chris Browne wrote: Recently seen in ACM Operating Systems Review (this is the first time I've found as many as 1 interesting article

Re: [HACKERS] New Linux Filesystem: NILFS

2006-09-06 Thread Jeff Davis
On Wed, 2006-09-06 at 18:55 -0400, Chris Browne wrote: [EMAIL PROTECTED] (Jeff Davis) writes: Do you see an advantage in using LFS for PostgreSQL? Hey guys - I think the original poster only meant to suggest that it was *interesting*... :-) I see, my mistake. From

Re: [HACKERS] New Linux Filesystem: NILFS

2006-09-07 Thread Jeff Davis
security (aside from the obvious don't pull cables)? Regards, Jeff Davis ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] GIN documentation

2006-09-13 Thread Jeff Davis
GIN, but I hope this is helpful. Regards, Jeff Davis --- gindocs.orig 2006-09-13 10:07:57.0 -0700 +++ gindocs 2006-09-13 10:43:25.0 -0700 @@ -89,7 +89,7 @@ +acronymGIN/acronym stands for Generalized Inverted Index. It is +an index structure storing a set of (key

Re: [HACKERS] [ADMIN] Vacuum error on database postgres

2006-09-14 Thread Jeff Davis
in random order? Regards, Jeff Davis ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [HACKERS] [ADMIN] Vacuum error on database postgres

2006-09-14 Thread Jeff Davis
On Thu, 2006-09-14 at 18:25 -0400, Tom Lane wrote: Jeff Davis [EMAIL PROTECTED] writes: How would creating a new lock type avoid deadlocks when an ANALYZE is accumulating the locks in random order? In itself it wouldn't. Josh Drake sketched the idea in more detail later

Re: [HACKERS] [PATCHES] Patch for UUID datatype (beta)

2006-09-18 Thread Jeff Davis
, Jeff Davis ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

Re: [HACKERS] [GENERAL] 'pg_ctl -w' times out when unix_socket_directory is

2006-09-28 Thread Jeff Davis
On Thu, 2006-09-28 at 10:05 -0400, Tom Lane wrote: Jeff Davis [EMAIL PROTECTED] writes: I have attached a patch. I wrote it very quickly, but it seems to work as I expect. I don't think this is very workable as a postgresql.conf parser ... at minimum it needs to handle quoted strings

Re: [HACKERS] archive_timeout?

2006-10-10 Thread Jeff Davis
compression in the docs so that people don't get worried about many gigabytes of mostly- empty files filling up their backup storage. Regards, Jeff Davis ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [HACKERS] archive_timeout?

2006-10-10 Thread Jeff Davis
On Tue, 2006-10-10 at 13:12 -0400, Tom Lane wrote: Jeff Davis [EMAIL PROTECTED] writes: There should be a documentation note to let people know that the archive will grow even when idle. Perhaps we should suggest compression in the docs so that people don't get worried about many gigabytes

Re: [HACKERS] Planner question

2008-09-05 Thread Jeff Davis
/pgsql-general/2008-08/msg00967.php My understanding from that thread is that if one table has high ndistinct and the other has low ndistinct, one plan may require more re-scanning than the other. Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

[HACKERS] SQL standard question about Common Table Expressions

2008-09-08 Thread Jeff Davis
of indirection in the 200n standard by using an intervening table subquery. I'm not an authority, but I believe this is a mistake. Regards, Jeff Davis * Having AQEk = WQEi disturbs me, too, because in the Framework part of the standard, section 6.3.3.1, the definition of contains does

[HACKERS] Common Table Expressions (WITH RECURSIVE) patch

2008-09-08 Thread Jeff Davis
. Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Common Table Expressions (WITH RECURSIVE) patch

2008-09-08 Thread Jeff Davis
On Mon, 2008-09-08 at 21:13 +0100, Gregory Stark wrote: Jeff Davis [EMAIL PROTECTED] writes: * Mutual Recursion: with recursive foo(i) as (values(1) union all select i+1 from bar where i 10), bar(i) as (values(1) union all select i+1 from foo where i 10) select * from

Re: [HACKERS] Common Table Expressions (WITH RECURSIVE) patch

2008-09-08 Thread Jeff Davis
support these things in a subquery, so shouldn't we support them in all subqueries? Regards, Jeff Davis -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

  1   2   3   4   5   6   7   8   9   10   >