Re: [HACKERS] Covering Indexes

indexed columns. And I wonder if it would work well with expressions, too? David IRC MS SQL also allow unindexed columns in the index. -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Streaming-only Remastering

master could deliver the last bit of the old masters logs that would be very nice. -- Rob Wultsch wult...@gmail.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] swapcache-style cache?

On Mon, Feb 27, 2012 at 11:54 PM, Andrea Suisani sick...@opinioni.net wrote: On 02/28/2012 04:52 AM, Rob Wultsch wrote: On Wed, Feb 22, 2012 at 2:31 PM, jamesja...@mansionfamily.plus.com  wrote: Has anyone considered managing a system like the DragonFLY swapcache for a DBMS like PostgreSQL

Re: [HACKERS] swapcache-style cache?

On Wed, Feb 22, 2012 at 2:31 PM, james ja...@mansionfamily.plus.com wrote: Has anyone considered managing a system like the DragonFLY swapcache for a DBMS like PostgreSQL? https://www.facebook.com/note.php?note_id=388112370932 -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers

Re: [HACKERS] MySQL search query is not executing in Postgres DB

several companies use comparisons of dissimilar data types as part of their stump the prospective DBA test and they stump lots of folks. -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Page Checksums + Double Writes

the number of writes is potentially halving the life of the flash. Something to think about... -- Rob Wultsch wult...@gmail.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] pg_dump.c

to generate SQL in the server can be very nice. -- Rob Wultsch wult...@gmail.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] crash-safe visibility map, take five

On Fri, May 6, 2011 at 2:47 PM, Robert Haas robertmh...@gmail.com wrote: Comments? At my day job there is saying: Silence is consent. I am surprised there has not been more discussion of this change, considering the magnitude of the possibilities it unlocks. -- Rob Wultsch wult...@gmail.com

Re: [HACKERS] making an unlogged table logged

On Wed, Jan 5, 2011 at 7:48 AM, David Fetter da...@fetter.org wrote: On Wed, Jan 05, 2011 at 09:04:08AM -0500, Robert Haas wrote: On Tue, Jan 4, 2011 at 10:56 PM, Rob Wultsch wult...@gmail.com wrote: 1. Could the making a table logged be a non-exclusive lock if the ALTER is allowed to take

Re: [HACKERS] making an unlogged table logged

BLACKHOLE because they held data that was not vital, but the server was out of IO. Going logged - unlogged has a significant placed, I think. -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Can postgres create a file with physically continuous blocks.

=194501560932 Also, InnoDB has an option for how much data should be allocated at the end of a tablespace when it needs to grow: http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html#sysvar_innodb_data_file_path -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] Can postgres create a file with physically continuous blocks.

On Wed, Dec 22, 2010 at 12:15 AM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 22.12.2010 03:45, Rob Wultsch wrote: On Tue, Dec 21, 2010 at 4:49 AM, Robert Haasrobertmh...@gmail.com  wrote: On Sun, Dec 19, 2010 at 1:10 PM, Jim Nasbyj...@nasby.net  wrote: On Dec 19, 2010

Re: [HACKERS] ALTER TABLE ... ADD FOREIGN KEY ... NOT ENFORCED

The Enterprise PostgreSQL Company MySQL does in fact have this feature and it is used by mysqldump. This feature is very useful. -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] unlogged tables

MyISAM /troll -- Rob Wultsch wult...@gmail.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] ALTER TABLE ... ADD FOREIGN KEY ... NOT ENFORCED

are implemented by the trigger system somehow seems surprising. -- Rob Wultsch wult...@gmail.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] unlogged tables

On Sun, Dec 12, 2010 at 7:33 PM, Robert Haas robertmh...@gmail.com wrote: On Sun, Dec 12, 2010 at 9:31 PM, Rob Wultsch wult...@gmail.com wrote: On Fri, Dec 10, 2010 at 5:34 PM, Cédric Villemain cedric.villemain.deb...@gmail.com wrote: 2010/12/8 Kineticode Billing da...@kineticode.com: On Dec

Re: [HACKERS] profiling connection overhead

for me to throw out. -- Rob Wultsch wult...@gmail.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] profiling connection overhead

On Sun, Dec 5, 2010 at 12:45 PM, Rob Wultsch wult...@gmail.com wrote: One thing I would suggest that the PG community keeps in mind while talking about built in connection process caching, is that it is very nice feature for memory leaks caused by a connection to not exist for and continue

Re: [HACKERS] Spread checkpoint sync

thing? -- Rob Wultsch wult...@gmail.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] profiling connection overhead

On Sun, Dec 5, 2010 at 6:59 PM, Robert Haas robertmh...@gmail.com wrote: On Sun, Dec 5, 2010 at 2:45 PM, Rob Wultsch wult...@gmail.com wrote: I think you have read a bit more into what I have said than is correct.  MySQL can deal with thousands of users and separate schemas on commodity

Re: [HACKERS] DELETE with LIMIT (or my first hack)

statements that probably need to examine more than 1,000,000 row combinations. I have actually suggested that a certain subset of my users only connect to the database if they are willing to use the --i-am-a-dummy flag. -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] crash-safe visibility map, take three

and if this feature should be optional. -- Rob Wultsch wult...@gmail.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 with LIMIT (or my first hack)

a lot of DELETE with LIMIT in my (mysql) environment for this reason. -- Rob Wultsch wult...@gmail.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] How can we tell how far behind the standby is?

-status.html http://dev.mysql.com/doc/refman/5.5/en/show-slave-status.html Also of interest http://dev.mysql.com/doc/refman/4.1/en/show-binary-logs.html -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] max_wal_senders must die

for wal_level.                        regards, tom lane If the variable is altered such that it is dynamic, could it not be updated by the postmaster when a connection attempts to begin replicating? -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Issues with Quorum Commit

TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers

Re: [HACKERS] configure gaps

of the things I really like about drizzle is if there a missing dependency it will explicitly tell you what you are missing and where to go find it for popular platforms. Not being able to easily build is a barrier to entry. Does pg want those? /trolling -- Rob Wultsch wult...@gmail.com -- Sent

Re: [HACKERS] update on global temporary and unlogged tables

reduce the table to a very small number (or zero) number of pages? Is there a case to be made for instead somehow marking all pages as available for reuse? Deallocating and reallocating space can be expensive. -- Rob Wultsch wult...@gmail.com

Re: [HACKERS] Return of the Solaris vacuum polling problem -- anyone remember this?

. -- Bruce Momjian br...@momjian.ushttp://momjian.us EnterpriseDB http://enterprisedb.com + It's impossible for everything to be true. + -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] SHOW TABLES

all this? Andres Do you have an alternative suggestion for emulating SHOW SCHEMAS SHOW TABLES DESC object? Make a user friendly interface is not easy, but it sure as heck is important. -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] SHOW TABLES

objections that followed caused that idea to scrapped. -- Rob Wultsch wult...@gmail.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] SHOW TABLES

On Fri, Jul 16, 2010 at 10:52 AM, Heikki Linnakangas heikki.linnakan...@enterprisedb.com wrote: On 16/07/10 20:11, Rob Wultsch wrote: On Fri, Jul 16, 2010 at 9:56 AM, Robert Haasrobertmh...@gmail.com  wrote: For committers. Perhaps this discussions should be moved to the General list

Re: [HACKERS] Functional dependencies and GROUP BY

to have made Postgres compatible. That said, I imagine if this feature could make it into the Postgres tree it would be very useful. Would I be correct in assuming that while this feature would make query planning more expensive, it would also often decrease the cost of execution? Best, Rob

Re: [HACKERS] List traffic

Linux has *as many if not more* ... MySQL, if memory servers, has a half dozen or more ... etc ... MySQL has a bunch of lists, none of which get much traffic. Honestly, they should probably be combined. -- Rob Wultsch -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Row-level Locks SERIALIZABLE transactions, postgres vs. Oracle

On Fri, May 14, 2010 at 7:32 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote: Oracle, and all other MVCC databases I've read about outside of PostgreSQL, use an update in place with a rollback log technique. Have you looked at PBXT (which is explicitly NOT SERIALIZABLE)? -- Rob Wultsch

Re: [HACKERS] Row-level Locks SERIALIZABLE transactions, postgres vs. Oracle

On Sat, May 15, 2010 at 4:09 AM, Kevin Grittner kevin.gritt...@wicourts.gov wrote:  Anything in particular you wanted me to notice about it besides that? Nope. It was just a counter point to your previous comment. -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list

Re: [HACKERS] List traffic

On Fri, May 14, 2010 at 11:50 PM, Rob Wultsch wult...@gmail.com wrote: Linux has *as many if not more* ... MySQL, if memory servers, has a half dozen or more ... etc ... MySQL has a bunch of lists, none of which get much traffic. Honestly, they should probably be combined. -- Rob Wultsch

Re: [HACKERS] max_standby_delay considered harmful

much a slave is lagging in clock time. /mysql dba troll -- Rob Wultsch wult...@gmail.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] Patch rev 2: MySQL-ism help patch for psql

capacity are a very good idea. -- Rob Wultsch wult...@gmail.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] MySQL-ism help patch for psql

); + } + else if (MYSQL_HELP_CHECK(desc)) + { + MYSQL_HELP_OUTPUT(\\d tablename); + } -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Disable and enable of table and column constraints

Herrera                                http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc. The mysql'ism foreign_key_checks would seem to do similar things...? (http://dev.mysql.com/doc/refman/5.1/en/server-session-variables.html#sysvar_foreign_key_checks ) -- Rob Wultsch wult

Re: [HACKERS] MySQL Compatibility WAS: 8.5 release timetable, again

, no that everything from MySQL is bad but i would be scary if we start supporting every single piece of code MySQL accepts And that behavior has changed to be sane in 5.0+, iirc. -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

[HACKERS] SET syntax in INSERT

,col7,col8,col9,col10,col11,col12,col13,col14,col15) VALUES ('val1','val2','val3','val4','val5','val6','val7','val8','val9','val10','val11','val12','val13','val14','val15') Probably a pipe dream... -- Rob Wultsch wult...@gmail.com -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] SET syntax in INSERT

On Tue, Aug 25, 2009 at 10:36 AM, Pavel Stehulepavel.steh...@gmail.com wrote: 2009/8/25 Rob Wultsch wult...@gmail.com: Given the recent discussion of DELETE syntax on JOINS  I thought it might be interesting to bring a bit MySQL syntax that is in somewhat widespread use, generally create