[HACKERS] SELECT DISTINCT never uses an index?

2016-07-07 Thread Bill Moran
that all exhibit the same behavior) and yes I've done ANALYZE and VACUUM and the behavior doesn't change. -- Bill Moran -- 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] Postgres 9.6 scariest patch tournament

2016-04-18 Thread Bill Moran
sources of major > bugs or instabilities in PostgreSQL 9.6. Wow ... this may be the most unusual survey I've seen in a while. -- Bill Moran -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] Can we improve this error message?

2016-04-17 Thread Bill Moran
he problem is that the second error masks the first one, hiding the real cause of the connection failure, and causing a lot of confusion. If we could keep both errors and report them both, I feel like it would be an improvement to our client library behavior. -- Bill Moran -- Sent via pgs

Re: [HACKERS] Proposal: custom compression methods

2015-12-14 Thread Bill Moran
you decide to start actually writing code, please contact me so we don't double up on the work. -- Bill Moran -- 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] Disabling an index temporarily

2015-12-13 Thread Bill Moran
table. Just my $.02 ... -- Bill Moran -- 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] remapped localhost causes connections to localhost to fail using Postgres

2015-12-04 Thread Bill Moran
machine named localhost. On posix systems, it's cusomary to put multiple names in the hosts file, localhost included. I expect that Windows is the same, but I haven't used it in so long that I can't be sure. -- Bill Moran -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)

Re: [HACKERS] RFC/WIP: adding new configuration options to TOAST

2015-11-04 Thread Bill Moran
On Wed, 4 Nov 2015 13:07:09 +0800 Craig Ringer <cr...@2ndquadrant.com> wrote: > On 4 November 2015 at 10:58, Bill Moran <wmo...@potentialtech.com> wrote: > > On Tue, 3 Nov 2015 18:34:39 -0800 > > Jeff Janes <jeff.ja...@gmail.com> wrote: > > > >>

[HACKERS] RFC/WIP: adding new configuration options to TOAST

2015-11-03 Thread Bill Moran
one: https://github.com/williammoran/postgres -- Bill Moran diff -r --exclude=.git --exclude=src/test --exclude=README postgres_head/doc/src/sgml/config.sgml postgres_new/doc/src/sgml/config.sgml 6708a6709,6773 > > TOAST > > > > >

Re: [HACKERS] RFC/WIP: adding new configuration options to TOAST

2015-11-03 Thread Bill Moran
On Tue, 3 Nov 2015 18:34:39 -0800 Jeff Janes <jeff.ja...@gmail.com> wrote: > On Tue, Nov 3, 2015 at 5:21 PM, Craig Ringer <cr...@2ndquadrant.com> wrote: > > On 3 November 2015 at 23:04, Bill Moran <wmo...@potentialtech.com> wrote: > >> > >> Looking

[HACKERS] Is there any ordering to the values in guc.c?

2015-10-28 Thread Bill Moran
See subject. Aside from them being divvied up by datatype, they seem to be ordered randomly. Since I'm putting together a patch that will add some GUCs, do I just add them to the end of the list? -- Bill Moran -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Is there any ordering to the values in guc.c?

2015-10-28 Thread Bill Moran
On Wed, 28 Oct 2015 16:58:30 -0400 Peter Eisentraut <pete...@gmx.net> wrote: > On 10/28/15 10:27 AM, Bill Moran wrote: > > See subject. Aside from them being divvied up by datatype, they seem > > to be ordered randomly. Since I'm putting together a patch that will > > a

Re: [HACKERS] [COMMITTERS] pgsql: Use gender-neutral language in documentation

2015-09-22 Thread Bill Moran
rsy by actually rewording > into the plural, where possible? > > So > > "any user can make such a change for his session." > > becomes > > "Users can make such a change for their individual sessions" > > or similar? +1 As an American/

Re: [HACKERS] how to write/setup a C trigger function in a background worker

2015-08-19 Thread Bill Moran
action you actually want to trigger, and call that second in your background worker. Cheers, David. -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Bill Moran wmo

[HACKERS] Anyone working on the TOAST items on the TODO list?

2015-07-25 Thread Bill Moran
If not, I'm going to make a little personal project of them for myself (targeting 9.6). -- Bill Moran -- 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] Anyone working on the TOAST items on the TODO list?

2015-07-25 Thread Bill Moran
On Sat, 25 Jul 2015 11:39:15 -0700 Josh Berkus j...@agliodbs.com wrote: On 07/25/2015 07:05 AM, Bill Moran wrote: If not, I'm going to make a little personal project of them for myself (targeting 9.6). Nope. In fact, even the one which was 90% complete (replacing zlib with lz4

Re: [HACKERS] Anyone working on the TOAST items on the TODO list?

2015-07-25 Thread Bill Moran
On Sat, 25 Jul 2015 16:06:28 -0400 Tom Lane t...@sss.pgh.pa.us wrote: Bill Moran wmo...@potentialtech.com writes: On Sat, 25 Jul 2015 11:39:15 -0700 Josh Berkus j...@agliodbs.com wrote: Nope. In fact, even the one which was 90% complete (replacing zlib with lz4) completely dropped off

Re: [HACKERS] Why don't we accept exponential format for integers?

2010-12-17 Thread Bill Moran
is the only example that comes to mind, but it's a pretty common language) which may cause numbers formatted thusly to be included in queries without the programmers prior realization. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql

Re: [HACKERS] Why don't we accept exponential format for integers?

2010-12-17 Thread Bill Moran
... -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- 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] Why don't we accept exponential format for integers?

2010-12-17 Thread Bill Moran
In response to Jeff Janes jeff.ja...@gmail.com: On Fri, Dec 17, 2010 at 12:16 PM, Bill Moran wmo...@potentialtech.com wrote: In response to Tom Lane t...@sss.pgh.pa.us: Josh Berkus j...@agliodbs.com writes: postgres=# select '1e+01'::Integer postgres-# ; ERROR:  invalid input

Re: [HACKERS] PG 9.0 and standard_conforming_strings

2010-01-29 Thread Bill Moran
walking. When the decision is made to remove the standard_conforming_string config option altogether ... that'll be a different story! -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Going, going, GUCs!

2009-10-20 Thread Bill Moran
in for a few more releases until newer versions of FreeBSD are the standard. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Limit allocated memory per session

2009-10-01 Thread Bill Moran
ulimit? I have a hard time believing that Windows doesn't have a ulimit equivalent. I don't want to degrade this thread into MS-bashing, but if that were the case, it would make Windows a pretty crippled OS. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran

Re: [HACKERS] Rejecting weak passwords

2009-09-28 Thread Bill Moran
irrelevant. Note the paragraph that I didn't snip where Albe points this out. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] happy birthday Tom Lane ...

2009-09-18 Thread Bill Moran
the party? ;) In any event, happy birthday. -- Bill Moran http://www.potentialtech.com -- 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] DELETE syntax on JOINS

2009-08-24 Thread Bill Moran
for a long time they didn't have proper foreign keys and referential integrity. With proper foreign keys and ON DELETE CASCADE, why would supporting such syntax even be necessary? -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- Sent via pgsql-hackers

Re: [HACKERS] New types for transparent encryption

2009-07-07 Thread Bill Moran
with a methodology for this is non-trivial, though. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- 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] pre-proposal: permissions made easier

2009-06-28 Thread Bill Moran
and add users to the group as appropriate. -- Bill Moran http://www.potentialtech.com -- 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] RFE: Transparent encryption on all fields

2009-04-24 Thread Bill Moran
In response to to...@tuxteam.de: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Apr 23, 2009 at 10:38:55AM -0400, Bill Moran wrote: [...] It's possible that this could be accomplished by something like Veil, or the built-in implementation that's coming in some future version

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-24 Thread Bill Moran
In response to to...@tuxteam.de: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thu, Apr 23, 2009 at 01:31:39PM -0700, Marc Munro wrote: [...] In principle it could be used in the way that Bill Moran suggests though I have never used it that way. I am somewhat suspicious

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-23 Thread Bill Moran
queries to encrypted fields. Since each user has their own key, the data is protected from all sorts of priv escalations, theft, etc (really, just about every attack vector aside from password brute forcing and social engineering ... and those will require other methods of protection anyway.) -- Bill

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-23 Thread Bill Moran
In response to to...@tuxteam.de: On Thu, Apr 23, 2009 at 10:38:55AM -0400, Bill Moran wrote: [...] It's possible that this could be accomplished by something like Veil, Veil? Care to share an URL? Google knows :) http://veil.projects.postgresql.org/curdocs/index.html -- Bill Moran

Re: [HACKERS] Why do we let CREATE DATABASE reassign encoding?

2009-04-23 Thread Bill Moran
it to create a utf8 encoded database ... -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- 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] Why do we let CREATE DATABASE reassign encoding?

2009-04-23 Thread Bill Moran
In response to Tom Lane t...@sss.pgh.pa.us: Bill Moran wmo...@potentialtech.com writes: In response to Tom Lane t...@sss.pgh.pa.us: We should presumably let the encoding be changed when cloning from template0, and probably it's reasonable to trust the user if either source or destination

Re: [HACKERS] Prepping to break every past release...

2009-03-04 Thread Bill Moran
people. -- Bill Moran http://www.potentialtech.com http://people.collaborativefusion.com/~wmoran/ -- 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] [pgsql-patches] [PATCHES] Patch to log usage of temporary files

2007-01-12 Thread Bill Moran
query, on production systems, without too much disruption of the rest of the work that's going on: set log_temp_files = 0; run suspect query set log_temp_files = -1; investigate logs At least, those are my current plans ... -- Bill Moran Collaborative Fusion Inc

Re: [HACKERS] [PATCHES] Patch to log usage of temporary files

2007-01-04 Thread Bill Moran
In response to Tom Lane [EMAIL PROTECTED]: Bill Moran [EMAIL PROTECTED] writes: Andrew Dunstan [EMAIL PROTECTED] wrote: Might be more robust to say if (trace_temp_files = 0) I specified in the GUC config that minimum allowable value is -1. I'd still tend to go with Andrew's

Re: [HACKERS] [PATCHES] Patch to log usage of temporary files

2007-01-03 Thread Bill Moran
In response to Simon Riggs [EMAIL PROTECTED]: On Tue, 2007-01-02 at 18:20 -0500, Tom Lane wrote: Bill Moran [EMAIL PROTECTED] writes: In response to Alvaro Herrera [EMAIL PROTECTED]: Please change things to save the stat() syscall when the feature is not in use. Do you have

[HACKERS] What's the difference between postgresql.conf.sample and postgresql.conf.sample.orig

2006-12-29 Thread Bill Moran
adding a GUC variable to submit a patch to allow tracing temp file usage. Do I need to add it to both? -- Bill Moran Collaborative Fusion Inc. ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] What's the difference between postgresql.conf.sample

2006-12-29 Thread Bill Moran
In response to Andrew Dunstan [EMAIL PROTECTED]: Bill Moran wrote: I see the above-mentioned files in src/backend/utils/misc. A diff shows the following: $ diff postgresql.conf.sample.orig postgresql.conf.sample 223a224 log_destination = 'syslog' 302a304

[HACKERS] Logging temp file useage ... a little advice would be appreciated

2006-12-29 Thread Bill Moran
something such as file sparseness? Is this entire endeavour doomed from the start? Or am I just making some sort of dumb mistake? Any pointers are welcome. -- Bill Moran Collaborative Fusion Inc. diff -r src.orig/backend/storage/file/fd.c src/backend/storage/file/fd.c 52a53 #include utils

Re: [HACKERS] Regarding development and the submittal of patches

2004-01-25 Thread Bill Moran
Bruce Momjian wrote: Bill Moran wrote: Hey all, I hope this isn't off-topic or inapropriate to this list ... I'm not familiar with the PostgreSQL patch-submittal/development cycle. I recently submitted a patch regarding \copy syntax in psql, and I'd like to keep an eye on it to see that it gets

[HACKERS] Regarding development and the submittal of patches

2004-01-20 Thread Bill Moran
suggestions, or links to information would be equally welcome. Thanks. -- Bill Moran Potential Technologies http://www.potentialtech.com ---(end of broadcast)--- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]