Re: [HACKERS] QSoC proposal: date_trunc supporting intervals

2014-03-20 Thread Steve Atkins
On Mar 20, 2014, at 1:24 PM, Thom Brown t...@linux.com wrote: On 20 March 2014 20:07, Josh Berkus j...@agliodbs.com wrote: On 03/20/2014 09:56 AM, Alexandr wrote: Here is the text of my proposal which I've applied to GSoC. (and link

Re: [HACKERS] host name support in pg_hba.conf

2010-08-10 Thread Steve Atkins
On Aug 10, 2010, at 8:23 AM, Stephen Frost wrote: * Peter Eisentraut (pete...@gmx.net) wrote: On mån, 2010-08-09 at 13:56 -0500, Kevin Grittner wrote: Some IP addresses have several host names, including in reverse lookup; how is that handled? This is not possible, or at least the C

Re: [HACKERS] SHOW TABLES

2010-07-16 Thread Steve Atkins
On Jul 16, 2010, at 8:11 AM, Simon Riggs wrote: On Fri, 2010-07-16 at 14:07 +0100, Thom Brown wrote: The problem is people are stating different requirements. - to make it easy for new users of psql - to simplify fetching basic database information from any client application - to ease

Re: [HACKERS] psql: Add setting to make '+' on \d implicit

2010-04-23 Thread Steve Atkins
On Apr 23, 2010, at 11:28 AM, Tom Lane wrote: Ross J. Reedstrom reeds...@rice.edu writes: On Fri, Apr 23, 2010 at 10:58:40AM -0500, Terry Brown wrote: So the proposal would be: \d+ does as it has always done, no change \d- (new) always behaves like 'old' \d \d acts as 'old' \d or as

Re: [HACKERS] proposal: more practical view on function's source code

2010-03-22 Thread Steve Atkins
On Mar 22, 2010, at 2:23 PM, Peter Eisentraut wrote: On sön, 2010-03-21 at 20:40 -0400, Robert Haas wrote: \ef function-name line-number with suitable magic to get the editor to place the cursor at that line. I suspect this wouldn't be too hard to do with emacs --- what do you think

Re: [HACKERS] Re: [BUGS] BUG #5021: ts_parse doesn't recognize email addresses with underscores

2010-03-12 Thread Steve Atkins
On Mar 12, 2010, at 5:18 PM, Tom Lane wrote: Bruce Momjian br...@momjian.us writes: Well, I think the big question is whether we need to honor RFC 5322 (http://www.rfc-editor.org/rfc/rfc5322.txt). Wikipedia says these are all valid characters:

Re: [HACKERS] [patch] build issues on Win32

2010-03-11 Thread Steve Atkins
On Mar 11, 2010, at 1:06 PM, Tom Lane wrote: BTW, I'm not sure I buy the argument that commercial software requires static linking. Red Hat would be as interested in that market as anybody, and as I said, they don't think it's necessary to ship static libraries (with a *very* short list

Re: [HACKERS] tie user processes to postmaster was:(Re: [HACKERS] scheduler in core)

2010-02-23 Thread Steve Atkins
On Feb 22, 2010, at 9:02 PM, Tom Lane wrote: Alvaro Herrera alvhe...@commandprompt.com writes: Regarding hooks or events, I think postmaster should be kept simple: launch at start, reset at crash recovery, kill at stop. Salt and pepper allowed but that's about it -- more complex ingredients

Re: [HACKERS] Listen / Notify rewrite

2009-11-12 Thread Steve Atkins
On Nov 12, 2009, at 5:57 PM, Robert Haas wrote: On Thu, Nov 12, 2009 at 8:44 PM, Josh Berkus j...@agliodbs.com wrote: On 11/12/09 8:30 AM, Tom Lane wrote: So while a payload string for NOTIFY has been on the to-do list since forever, I have to think that Greg's got a good point questioning

Re: [HACKERS] [PATCH] Cleanup of GUC units code

2008-09-04 Thread Steve Atkins
On Sep 4, 2008, at 6:29 AM, Andrew Sullivan wrote: On Thu, Sep 04, 2008 at 01:26:44AM +0300, Hannu Krosing wrote: So Andrews opinion was that Mb (meaning Mbit) is different from MB (for megabyte) and that if someone thinks that we define shared buffers in megabits can get confused and

Re: [HACKERS] Proposal: new border setting in psql

2008-08-25 Thread Steve Atkins
On Aug 24, 2008, at 6:16 AM, Merlin Moncure wrote: On Sun, Aug 24, 2008 at 2:00 AM, D'Arcy J.M. Cain [EMAIL PROTECTED] wrote: On Sat, 23 Aug 2008 14:57:50 -0400 Tom Lane [EMAIL PROTECTED] wrote: Also, having now looked at the proposed patch, it seems clear that it isn't addressing the

Re: [HACKERS] Overhauling GUCS

2008-08-18 Thread Steve Atkins
On Aug 18, 2008, at 1:05 AM, Magnus Hagander wrote: Josh Berkus wrote: Steve, First pass is done. Needs a little cleanup before sharing. I spent a fair while down OS-specific-hardware-queries rathole, but I'm better now. Gods, I hope you gave up on that. You want to use SIGAR or

Re: [HACKERS] Overhauling GUCS

2008-08-17 Thread Steve Atkins
June, Steve Atkins was looking into writing a C++/Qt GUI tuning interface application, with the idea that somebody else would figure out the actual smarts to the tuning effort. Don't know where that's at. First pass is done. Needs a little cleanup before sharing. I spent a fair while down

Re: [HACKERS] Plugin system like Firefox

2008-08-12 Thread Steve Atkins
On Aug 12, 2008, at 12:42 PM, Bruce Momjian wrote: Markus Wanner wrote: Hi, Robert Haas wrote: I can't speak for anyone else, but I much prefer packages that make use of my operating system's package management system rather than rolling their own. If I need a perl package that I can't get

Re: [HACKERS] Overhauling GUCS

2008-06-12 Thread Steve Atkins
On Jun 12, 2008, at 11:21 AM, Bruce Momjian wrote: Josh Berkus wrote: Bruce, I am concerned that each wizard is going to have to duplicate the same logic each time, and adjust to release-based changes. I think that's a feature, not a bug. Right now, I'm not at all convinced that my

Re: [HACKERS] Overhauling GUCS

2008-06-06 Thread Steve Atkins
On Jun 6, 2008, at 12:22 PM, Greg Smith wrote: On Fri, 6 Jun 2008, Peter Eisentraut wrote: - What settings do newbies (or anyone else) typically need to change? Please post a list. - What values would you set those settings to? Please provide a description for arriving at a value, which

Re: [HACKERS] Overhauling GUCS

2008-06-04 Thread Steve Atkins
On Jun 4, 2008, at 1:57 PM, Tom Lane wrote: * Can we build a configuration wizard to tell newbies what settings they need to tweak? Probably. Given the demographics of a lot of the newbies is Windows this likely needs to be a pointy-clicky sort of thing if it's going to be widely useful.

Re: [HACKERS] Overhauling GUCS

2008-06-04 Thread Steve Atkins
On Jun 4, 2008, at 5:23 PM, Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Tom Lane wrote: * Can we build a configuration wizard to tell newbies what settings they need to tweak? That would trump all the other suggestions conclusively. Anyone good at expert systems? How

Re: [HACKERS] Overhauling GUCS

2008-06-04 Thread Steve Atkins
the extension) On Jun 4, 2008, at 6:20 PM, Steve Atkins wrote: I'd be interested in putting together a framework+GUI client to do this cleanly in a cross-platform (Windows, Linux, Solaris, OS X as a bare minimum) sort of way, if no-one else already has such a thing. /me makes go together

Re: [HACKERS] Core team statement on replication in PostgreSQL

2008-05-29 Thread Steve Atkins
On May 29, 2008, at 9:12 AM, David Fetter wrote: On Thu, May 29, 2008 at 11:58:31AM -0400, Bruce Momjian wrote: Josh Berkus wrote: Publishing the XIDs back to the master is one possibility. We also looked at using spillover segments for vacuumed rows, but that seemed even less viable. I'm

Re: [HACKERS] triggers on prepare, commit, rollback... ?

2008-05-20 Thread Steve Atkins
On May 19, 2008, at 6:53 PM, Tom Lane wrote: Another response I've heard is but I don't want to make inside-the-database changes, I want to propagate the state to someplace external. Of course that's completely broken too, because there is *absolutely no way* you will ever make such

Re: [HACKERS] SSL and USER_CERT_FILE

2008-05-15 Thread Steve Atkins
On May 15, 2008, at 6:31 AM, [EMAIL PROTECTED] wrote: Mark Woodward wrote: I am using PostgreSQL's SSL support and the conventions for the key and certifications don't make sense from the client perspective. Especially under Windows. I am proposing a few simple changes: Adding two API

[HACKERS] Standard metadata queries

2008-04-24 Thread Steve Atkins
I've been chatting with the Trolltech folks about the implementation of the Qt wrapper around libpq, and the issue of how to properly do metadata queries came up. That is things like What are the column names and types of the primary key of this table, and what index enforces it? or What

Re: [HACKERS] Standard metadata queries

2008-04-24 Thread Steve Atkins
On Apr 24, 2008, at 11:12 AM, Joshua D. Drake wrote: On Thu, 24 Apr 2008 11:01:13 -0700 Steve Atkins [EMAIL PROTECTED] wrote: I've been chatting with the Trolltech folks about the implementation of the Qt wrapper around libpq, and the issue of how to properly do metadata queries came up

Re: [HACKERS] Standard metadata queries

2008-04-24 Thread Steve Atkins
On Apr 24, 2008, at 2:22 PM, Tom Lane wrote: Steve Atkins [EMAIL PROTECTED] writes: On Apr 24, 2008, at 11:12 AM, Joshua D. Drake wrote: I believe the information_schema is standard. Standard, but woefully incomplete (by design). Sure, because it's restricted to standardized concepts

Re: [HACKERS] modules

2008-04-03 Thread Steve Atkins
On Apr 3, 2008, at 7:01 AM, Aidan Van Dyk wrote: * Greg Sabino Mullane [EMAIL PROTECTED] [080403 09:54]: Right now contrib is a real catch-all of various things; it would be nice to categorize them somehow. And by categorize, I emphatically do NOT mean move to pgfoundry, which is pretty

Re: [HACKERS] CLUSTER and synchronized scans and pg_dump et al

2008-01-28 Thread Steve Atkins
On Jan 28, 2008, at 8:36 AM, Tom Lane wrote: Andrew Dunstan [EMAIL PROTECTED] writes: Kevin Grittner wrote: It would seem reasonable to me for pg_dump to use ORDER BY to select data from clustered tables. What will be the performance hit from doing that? That worries me too. Also, in

Re: [HACKERS] Spinlock backoff algorithm

2007-11-14 Thread Steve Atkins
On Nov 14, 2007, at 6:57 PM, Josh Berkus wrote: Tom, I've got one upstairs (HPPA), and I believe that it's actually a pretty common situation in scientifically-oriented workstations from a few years back. Last I checked, scientific workstations aren't exactly a common platform for

Re: [HACKERS] Best implementation of PATRICIA

2007-08-25 Thread Steve Atkins
On Aug 25, 2007, at 11:37 AM, Alex Povolotsky wrote: Hello! I'm working on a project requiring fast query like 'does ADDRESS belongs to SET OF NETWORKS?'. Naturally, such a query is better implemented using PATRICIA, but building PATRICIA tree is a relatively long task and is better to

Re: [HACKERS] crypting prosrc in pg_proc

2007-08-10 Thread Steve Atkins
On Aug 10, 2007, at 12:00 PM, Gregory Stark wrote: Jonah H. Harris [EMAIL PROTECTED] writes: Obfuscation doesn't really work, it just makes big wigs in companies *think* it's not easily reversible. There is no real security. With enough time and experience, anything can be broken. But

Re: [HACKERS] Bugtraq: Having Fun With PostgreSQL

2007-06-23 Thread Steve Atkins
On Jun 23, 2007, at 11:03 AM, Magnus Hagander wrote: I would also argue that trust auth is not such an evil option that we mustn't allow it to be the default. On a single-user machine it's actually perfectly sane, seeing that we don't allow TCP connections by default. Is there really such

Re: [HACKERS] PG-MQ?

2007-06-19 Thread Steve Atkins
On Jun 19, 2007, at 2:45 PM, Chris Browne wrote: I'm seeing some applications where it appears that there would be value in introducing asynchronous messaging, ala message queueing. http://en.wikipedia.org/wiki/Message_queue Me too. My bias would be to have something that can basically run

Re: [HACKERS] storage of sensor data with Fourier transforms

2007-05-04 Thread Steve Atkins
On May 4, 2007, at 10:13 PM, Nathan Buchanan wrote: Hello! I have a potential situation where I will have a lot of sensor data coming in very often. (every second or so) The sensor data is from physics type measurements, and will normally follow a slowly changing pattern with sinusoidal

Re: [HACKERS] [GENERAL] Autovacuum Improvements

2007-01-22 Thread Steve Atkins
On Jan 22, 2007, at 11:16 AM, Richard Huxton wrote: Bruce Momjian wrote: Yep, agreed on the random I/O issue. The larger question is if you have a huge table, do you care to reclaim 3% of the table size, rather than just vacuum it when it gets to 10% dirty? I realize the vacuum is

Re: [HACKERS] pg_hba.conf hostname todo

2006-12-27 Thread Steve Atkins
On Dec 27, 2006, at 1:47 PM, Joshua D. Drake wrote: On Wed, 2006-12-27 at 16:41 -0500, Stephen Frost wrote: * Joshua D. Drake ([EMAIL PROTECTED]) wrote: Allow pg_hba.conf to specify host names along with IP addresses Excellent. Host name lookup could occur when the postmaster reads the

Re: [HACKERS] effective_cache_size vs units

2006-12-19 Thread Steve Atkins
On Dec 19, 2006, at 9:50 PM, Jonah H. Harris wrote: On 12/19/06, Tom Lane [EMAIL PROTECTED] wrote: I think we should just accept the strings case-insensitively, too. While acknowledging Peter's pedantically-correct points, I say +1 for ease of use. +1. I spend some time walking people

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-24 Thread Steve Atkins
On Oct 24, 2006, at 8:48 PM, Bruce Momjian wrote: Joshua D. Drake wrote: Josh Berkus wrote: Bruce, I have updated the text. Please let me know what else I should change. I am unsure if I should be mentioning commercial PostgreSQL products in our documentation. I think you should

Re: [DOCS] [HACKERS] Replication documentation addition

2006-10-24 Thread Steve Atkins
On Oct 24, 2006, at 9:20 PM, Bruce Momjian wrote: Steve Atkins wrote: If we are to add them, I need to hear that from people who haven't worked in PostgreSQL commerical replication companies. I'm not coming to PostgreSQL for open source solutions. I'm coming to PostgreSQL for _good_

Re: [HACKERS] Roadmaps 'n all that

2006-08-31 Thread Steve Atkins
On Aug 31, 2006, at 8:47 PM, Tom Lane wrote: [ hijacking this thread over to where the developers hang out ] Alvaro Herrera [EMAIL PROTECTED] writes: Tom Lane wrote: It's pointless to suppose that individual developers would really be answerable to any project-wide management, since that's

Re: pgsql-patches reply-to (was Re: [HACKERS] [PATCHES] selecting

2006-08-17 Thread Steve Atkins
On Aug 17, 2006, at 9:30 AM, Magnus Hagander wrote: Ever since pgsql-patches replies started going to -hackers, threading doesn't work anymore, so I for one can't tell what this refers to at all. Yeah, that experiment hasn't seemed to work all that well for me either. Do you have another

Re: [HACKERS] automatic system info tool?

2006-07-17 Thread Steve Atkins
On Jul 17, 2006, at 12:57 PM, Martijn van Oosterhout wrote: On Mon, Jul 17, 2006 at 11:06:50AM -0400, Bort, Paul wrote: If you can open a command shell you can get the OS version with the 'ver' command under Windows: C:\ver Microsoft Windows XP [Version 5.1.2600] How do you do this from a

Re: [HACKERS] vacuum, performance, and MVCC

2006-06-22 Thread Steve Atkins
On Jun 22, 2006, at 6:56 PM, Agent M wrote: On Jun 22, 2006, at 9:56 PM, Christopher Kings-Lynne wrote: The example is a very active web site, the flow is this: query for session information process HTTP request update session information This happens for EVERY http request. Chances are

Re: [HACKERS] CSV mode option for pg_dump

2006-06-13 Thread Steve Atkins
On Jun 13, 2006, at 7:34 AM, Martijn van Oosterhout wrote: What this tells me is that we need a tool somewhere between psql and pg_dump, say, pgquery. It's sole purpose in life is to generate output from various queries. Because it's a seperate tool there's no question of psql or pg_dump being

Re: [HACKERS] CSV mode option for pg_dump

2006-06-13 Thread Steve Atkins
On Jun 13, 2006, at 9:47 AM, Joshua D. Drake wrote: Would that be adequate, or do we really want to reimplement and maintain all the output format complexity in our own code, in C? I think the point is that we should provide a native implementation because not everyone is crazy enough to

Re: [HACKERS] Possible TODO item: copy to/from pipe

2006-05-31 Thread Steve Atkins
On May 31, 2006, at 12:58 PM, Dave Page wrote: On 31/5/06 19:13, Andreas Pflug [EMAIL PROTECTED] wrote: I wonder if we'd be able to ship gzip with the windows installer, to insure proper integration. 'Fraid not. It's GPL'd. Well, one implementation of it is. zlib is new-bsd-ish,

Re: [HACKERS] OSX intel

2006-03-18 Thread Steve Atkins
On Mar 18, 2006, at 1:39 PM, Neil Conway wrote: On Sat, 2006-03-18 at 22:36 +0900, Michael Glaesemann wrote: Yes, there have been reports that it builds. You can check the archives for details. Are we prepared to declare that OS/X on Intel is an officially supported platform for the 8.1

Re: [HACKERS] random observations while testing with a 1,8B row table

2006-03-10 Thread Steve Atkins
On Mar 10, 2006, at 11:54 AM, Tom Lane wrote: Stefan Kaltenbrunner [EMAIL PROTECTED] writes: 3. vacuuming this table - it turned out that VACUUM FULL is completly unusable on a table(which i actually expected before) of this size not only to the locking involved but rather due to a

Re: [HACKERS] pg_service.conf

2006-02-19 Thread Steve Atkins
On Feb 19, 2006, at 10:59 AM, Mark Woodward wrote: Mark Woodward [EMAIL PROTECTED] writes: DNS isn't always a better solution than /etc/hosts, both have their pros and cons. The /etc/hosts file is very useful for instantaneous, reliable, and redundent name lookups. DNS services, espcially

Re: [GENERAL] [HACKERS] New project launched : PostgreSQL GUI Installer for

2006-01-30 Thread Steve Atkins
On Jan 30, 2006, at 8:48 PM, Tony Caduto wrote: Devrim GUNDUZ wrote: Have you looked at AutoPackage? http://autopackage.org screen shots. http://autopackage.org/gallery.html Has a GUI wizard if X windows is available and a command line wizard if no X is available. Using autopackage

Re: [HACKERS] Cleaning up the INET/CIDR mess

2006-01-26 Thread Steve Atkins
On Jan 25, 2006, at 9:29 AM, Bruce Momjian wrote: Tom Lane wrote: Greg Stark [EMAIL PROTECTED] writes: I wonder if this would be an opportunity to fix Postgres's handling of addresses like '10.1'. You've mistaken this for a proposal to change the I/O behavior, which it is specifically

Re: [HACKERS] State of support for back PG branches

2005-09-27 Thread Steve Atkins
On Mon, Sep 26, 2005 at 09:54:46PM -0700, Joshua D. Drake wrote: [ raised eyebrow... ] Has bizgres obtained a crystal ball from somewhere? There is *no* way anyone could provide you anything that has any legitimate claim on the name PG 8.2 three months from now. I **think** what he

Re: [HACKERS] State of support for back PG branches

2005-09-26 Thread Steve Atkins
On Mon, Sep 26, 2005 at 09:27:28PM -0400, Andrew Dunstan wrote: Tom Lane wrote: Marc G. Fournier [EMAIL PROTECTED] writes: On Mon, 26 Sep 2005, Andrew Dunstan wrote: Maybe something like this would do: We will attempt to maintain support of each major version for 3 years after

Re: [HACKERS] initdb profiles

2005-09-09 Thread Steve Atkins
On Thu, Sep 08, 2005 at 08:29:38PM -, Andrew - Supernews wrote: On 2005-09-08, Peter Eisentraut [EMAIL PROTECTED] wrote: Andrew - Supernews wrote: Running initdb behind the scenes is a proven dangerous practice Please elaborate. Example instance:

Re: [HACKERS] initdb profiles

2005-09-08 Thread Steve Atkins
On Thu, Sep 08, 2005 at 09:54:59AM +0800, Christopher Kings-Lynne wrote: I think we should just do what MySQL does and include: postgresql.conf postgresql-large.conf postgresql-huge.conf I do that, in the package of PG I distribute with my application. I tell the user that they should use

Re: [HACKERS] Call for 7.5 feature completion

2005-09-01 Thread Steve Atkins
On Thu, Sep 01, 2005 at 09:17:38AM +0800, William ZHANG wrote: Dave Page wrote: * Compile with MSVC on Win32 platforms. MySQL support it. So what? It would take a major amount of work, with no useful benefits. ... and you can compile all the client and library stuff with MSVC

Re: [HACKERS] Remote administration functionality

2005-07-30 Thread Steve Atkins
On Sat, Jul 30, 2005 at 11:39:20PM -0400, Bruce Momjian wrote: Let me try to outline where I think our goals are for remote administration. I will not comment on Dave's analysis of the patch review process, but I think he has some valid points that this patch was not treated properly.

Re: [HACKERS] pl/pgsql: END verbosity

2005-06-22 Thread Steve Atkins
On Thu, Jun 23, 2005 at 01:41:49AM +1000, Neil Conway wrote: Andrew Dunstan wrote: But this doesn't make it easier to use - users don't just include those who write it. The antecedent language of these, Ada, from which this syntax comes, was explicitly designed to be reader-friendly as opposed

Re: [HACKERS] Autovacuum in the backend

2005-06-16 Thread Steve Atkins
On Wed, Jun 15, 2005 at 09:07:30PM -0700, Josh Berkus wrote: Josh, Just my own two cents. First I am not knocking the work that has been on autovacuum. I am sure that it was a leap on its own to get it to work. However I will say that I just don't see the reason for it. I've personally

Re: [HACKERS] NOLOGGING option, or ?

2005-06-02 Thread Steve Atkins
On Thu, Jun 02, 2005 at 07:33:13AM -0700, Luke Lonergan wrote: Oliver, Haven't you just replaced one preprocessing step with another, then? Generally not. The most common problem with the current choice of escape character is that there are *lots* of data load scenarios with backslash in

Re: [HACKERS] NOLOGGING option, or ?

2005-06-01 Thread Steve Atkins
On Wed, Jun 01, 2005 at 07:35:33PM -0700, Luke Lonergan wrote: I propose an extended syntax to COPY with a change in semantics to remove the default of WITH ESCAPE '\'. Er, doesn't this break existing database dumps? Yes, one of the previously stated reasons to create another command

Re: Learning curves and such (was Re: [HACKERS] pgFoundry)

2005-05-20 Thread Steve Atkins
On Fri, May 20, 2005 at 11:59:00PM +0900, Michael Glaesemann wrote: Right, if you classify the information coming in, you can set controls over who sees it. What we don't do now is any kind of classification. This may be a bit off-the-wall, but I recall Joel Spolsky recently writing

Re: Learning curves and such (was Re: [HACKERS] pgFoundry)

2005-05-17 Thread Steve Atkins
On Tue, May 17, 2005 at 06:25:16PM -0400, Alvaro Herrera wrote: On Wed, May 18, 2005 at 08:04:51AM +1000, Brendan Jurd wrote: On 5/18/05, Stephen Frost [EMAIL PROTECTED] wrote: * Brendan Jurd ([EMAIL PROTECTED]) wrote: In the interests of putting my money where my mouth is, I would be

Re: Learning curves and such (was Re: [HACKERS] pgFoundry)

2005-05-17 Thread Steve Atkins
On Wed, May 18, 2005 at 12:07:14AM -0400, Tom Lane wrote: Steve Atkins [EMAIL PROTECTED] writes: The useful bug tracking systems I've used have also included QA. Any bug submitted doesn't get accepted without a standalone test case. Side note: while test cases are certainly Good Things

Re: [HACKERS] [BUGS] Bug in create operator and/or initdb

2005-01-31 Thread Steve Atkins
On Sun, Jan 30, 2005 at 09:49:43PM -0600, Larry Rosenman wrote: On Sun, 30 Jan 2005, Tom Lane wrote: Steve Atkins [EMAIL PROTECTED] writes: For a replacement type, how important is it that it be completely compatible with the existing inet/cidr types? Is anyone actually using inet types

Re: [HACKERS] [BUGS] Bug in create operator and/or initdb

2005-01-31 Thread Steve Atkins
On Mon, Jan 31, 2005 at 12:16:26PM -0500, Tom Lane wrote: Steve Atkins [EMAIL PROTECTED] writes: The cidr type, including it's external interface, is simply broken. That is a large claim that I don't think you have demonstrated. The only one of your examples that seems to me to contradict

Re: [HACKERS] [BUGS] Bug in create operator and/or initdb

2005-01-29 Thread Steve Atkins
On Sat, Jan 29, 2005 at 10:07:30PM -0500, Tom Lane wrote: John Hansen [EMAIL PROTECTED] writes: In that case may I suggest fixing the catalog so network_* functions exists for both datatypes! Redesigning the inet/cidr distinction is on the to-do list (though I'm afraid not very high on

Re: [HACKERS] apparent problem on linux/s390

2004-12-10 Thread Steve Atkins
On Tue, Dec 07, 2004 at 10:37:36AM +0200, Nicolai Tufar wrote: On Mon, 06 Dec 2004 19:15:23 -0500, Andrew Dunstan [EMAIL PROTECTED] wrote: problems apparently with NaNs, infinities and negative zeros. Sure smells more like an IEEE issue than a postgresql issue (built for IBM FP rather than

Re: [HACKERS] embedded postgresql

2004-10-19 Thread Steve Atkins
On Thu, Oct 14, 2004 at 09:49:47AM +0200, [EMAIL PROTECTED] wrote: Dear Sirs, I would like to know if there are any discussions about creating an embedded version on postgresql. My thoughts go towards building/porting a sqlite equivalent of pg. The discussion comes up occasionally. After

Re: [HACKERS] fsync and hardware write cache

2004-08-23 Thread Steve Atkins
On Mon, Aug 23, 2004 at 10:19:20PM +0200, Manfred Spraul wrote: Does it make sense to add a platform specific call that will flush a write cache when fsync is enable? Pete Zaitsev from mysql wrote that there is a special call on Mac OS: Quoting him: Mac OS X also has this optimization,

Re: [HACKERS] Version Numbering -- The great debate

2004-07-31 Thread Steve Atkins
On Sun, Aug 01, 2004 at 12:20:59PM +0800, Christopher Kings-Lynne wrote: This is more features worth mentioning than we've ever had in a single release before -- and if you consider several add-ons which have been implemented/improved at the same time (Slony, PL/Java, etc.) it's even more

Re: [HACKERS] localhost redux

2004-07-20 Thread Steve Atkins
On Tue, Jul 20, 2004 at 08:32:00AM -0400, Tom Lane wrote: Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes: I think you should first trace down what the problem really is --- is your system just misconfigured or is there some fundamental issue that we really ought to answer to? The

[HACKERS] Accelerating aggregates

2004-06-11 Thread Steve Atkins
Stop me if you've heard this before. I'm looking at fast calculation of aggregates (sum(), max(), count()) across large tables, or across fairly simply defined subsets of those tables. Lets say that, for a given aggregate function on a given table (with a given where clause, perhaps), each

Re: [HACKERS] Accelerating aggregates

2004-06-11 Thread Steve Atkins
On Fri, Jun 11, 2004 at 09:27:07AM +0100, Richard Huxton wrote: If the transaction is rolled back, the local state variable is thrown away. If the transaction is commited and the local state variable has been invalidated then the global state variable is invalidated, otherwise the global

Re: [HACKERS] Accelerating aggregates

2004-06-11 Thread Steve Atkins
On Fri, Jun 11, 2004 at 12:17:57PM -0400, Greg Stark wrote: Steve Atkins [EMAIL PROTECTED] writes: So, if you take a local snapshot of the global at the beginning of your transaction then the visible changes at any point are those from transactions that commited before your transaction

Re: [HACKERS] Accelerating aggregates

2004-06-11 Thread Steve Atkins
On Fri, Jun 11, 2004 at 01:49:18PM -0400, Tom Lane wrote: Steve Atkins [EMAIL PROTECTED] writes: Uhm... only updates within the current transaction. So if you merge the global state and the local state that's exactly what you'll see. The only way this would work is if at every

Re: [HACKERS] Email data type

2004-05-17 Thread Steve Atkins
On Mon, May 17, 2004 at 05:01:36PM +0200, Gaetano Mendola wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Bruno Wolff III wrote: | On Sun, May 16, 2004 at 04:36:55 +0200, | Gaetano Mendola [EMAIL PROTECTED] wrote: | |The type is indexable and provide also conversion methods: |

Re: [HACKERS] Email data type

2004-05-17 Thread Steve Atkins
On Mon, May 17, 2004 at 05:01:05PM +0100, Dave Page wrote: [EMAIL PROTECTED] is syntactically valid. [EMAIL PROTECTED] is syntactically valid, but should be immediately rejected. I disagree - just because the database server cannot verify the the existence of a domain does not mean that

Re: [HACKERS] Email data type

2004-05-17 Thread Steve Atkins
On Mon, May 17, 2004 at 09:21:54AM -0700, Steve Crawford wrote: Along those lines [EMAIL PROTECTED] and [EMAIL PROTECTED] are valid but they don't necessarily refer to the same mailbox (depends on the mx for foo.bar.com). I don't believe the latter is actually valid, as it has to be an

Re: [HACKERS] PostgreSQL pre-fork speedup

2004-05-05 Thread Steve Atkins
On Wed, May 05, 2004 at 02:12:58PM -0400, Rod Taylor wrote: Most of it has been. It's the duty cycle. As stated in another email, only about 20% of the work a script does is database related -- which occurs all at one time. Even when all Apache backends are active, a large number of

Re: [HACKERS] Socket communication for contrib

2004-04-16 Thread Steve Atkins
On Fri, Apr 16, 2004 at 08:10:20AM -0400, Andrew Sullivan wrote: On Mon, Apr 05, 2004 at 06:33:51PM +0200, Hans-J?rgen Sch?nig wrote: I have learned (please correct me if I am wrong) that people tend to look in contrib before they look at gborg. This may be true, but if so, perhaps

Re: [HACKERS] PostgreSQL configuration

2004-04-11 Thread Steve Atkins
On Sat, Apr 10, 2004 at 03:53:49PM -0400, [EMAIL PROTECTED] wrote: The whole idea of having multiple command-line switches to pick config and data separately bothers me. ISTM this would mostly create great new opportunities to shoot yourself in the foot (by accidentally picking the wrong

Re: [PERFORM] [HACKERS] fsync method checking

2004-03-26 Thread Steve Atkins
On Fri, Mar 26, 2004 at 07:25:53AM +0100, Manfred Spraul wrote: Compare file sync methods with one 8k write: (o_dsync unavailable) open o_sync, write 6.270724 write, fdatasync13.275225 write, fsync, 13.359847 Odd. Which filesystem,

Re: [HACKERS] Mixing threaded and non-threaded

2004-01-30 Thread Steve Atkins
On Fri, Jan 30, 2004 at 11:10:49AM -0600, Scott Lamb wrote: On Jan 30, 2004, at 3:18 AM, Bruce Momjian wrote: Manfred Spraul wrote: Bruce Momjian wrote: Woh, as far as I know, any application should run fine with -lpthread, threaded or not. What OS are you on? This is the first I have

Re: [HACKERS] Mixing threaded and non-threaded

2004-01-27 Thread Steve Atkins
On Fri, Jan 23, 2004 at 10:03:30PM -0500, Bruce Momjian wrote: Steve Atkins wrote: When I rebuilt libpq to use threads, I started seeing a bunch of weird failures in many of the older applications. The change in libpq meant that libpthread was being dynamically linked into the non-thread

Re: [HACKERS] Mixing threaded and non-threaded

2004-01-27 Thread Steve Atkins
On Tue, Jan 27, 2004 at 02:07:44PM -0500, Bruce Momjian wrote: Steve Atkins wrote: My guess is that creating applications against the non-thread libpq and then replacing it with a threaded libpq is your problem. Yes. It seems to make no difference whether the application is rebuilt