dress this.
Compiled and tested on Ubuntu 17.04 Linux 4.10.0-33-generic x86_64.
Regression test added under the update test to cover the parenthesized
single-column case.
I see no reason this would affect performance.
Thanks,
-rob
--
Rob McColl
@robmccoll
r...@robmccoll.com
205.422.0909 <(205)%20422-0909>
Attaching patch... :-/
On Tue, Oct 31, 2017 at 4:27 PM, Rob McColl wrote:
> Between 9.6.5 and 10, the handling of parenthesized single-column UPDATE
> statements changed. In 9.6.5, they were treated identically to
> unparenthesized single-column UPDATES. In 10, they are treated as
&
varchar to text
I have seen that there are people motivated enough to update pg_attribute
directly (update pg_attribute a set a.atttypmod = 20 + 4 ...).
What are the thoughts on support these 3 specific cases?
Thanks, Rob.
rt, too, where additional, unindexed columns
> are stored alongside 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 mai
use it was 1kb behind in reading logs
from the master. If the new 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
On Mon, Feb 27, 2012 at 11:54 PM, Andrea Suisani wrote:
> On 02/28/2012 04:52 AM, Rob Wultsch wrote:
>>
>> On Wed, Feb 22, 2012 at 2:31 PM, james
>> wrote:
>>>
>>> Has anyone considered managing a system like the DragonFLY swapcache for
>>
On Wed, Feb 22, 2012 at 2:31 PM, james 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 mailing list (pgsq
comparison. I have seen this sort of
things cause significant production issues several times.*
I have seen 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
ber 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
ect statement for all the fields in a given table,
> with an optional alias prefix.
>
> For the purposes of pg_dump, perhaps we'd want to move all the getFoo()
> functions in pg_dump.c into the library, along with a couple of bits from
> common.c like getSchemaData().
&g
On Fri, May 6, 2011 at 2:47 PM, Robert Haas 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
On Wed, Jan 5, 2011 at 7:48 AM, David Fetter 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 wrote:
>> > 1. Could the making a table logged be a non-exclusive lock if the
>> > ALTER is allowe
it on the master), skip step #6, and do step #7
> backwards.
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
A couple thoughts:
1. Could the making a table logged be a non-exclusive lock if the
ALTER is allowed to take a full ch
On Wed, Dec 22, 2010 at 12:15 AM, Heikki Linnakangas
wrote:
> On 22.12.2010 03:45, Rob Wultsch wrote:
>>
>> On Tue, Dec 21, 2010 at 4:49 AM, Robert Haas
>> wrote:
>>>
>>> On Sun, Dec 19, 2010 at 1:10 PM, Jim Nasby wrote:
>>>>
>
://forge.mysql.com/worklog/task.php?id=4925
http://www.facebook.com/note.php?note_id=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_fil
On Sun, Dec 12, 2010 at 7:33 PM, Robert Haas wrote:
> On Sun, Dec 12, 2010 at 9:31 PM, Rob Wultsch wrote:
>> On Fri, Dec 10, 2010 at 5:34 PM, Cédric Villemain
>> wrote:
>>> 2010/12/8 Kineticode Billing :
>>>> On Dec 8, 2010, at 10:37 AM, Chris Browne w
fact that fk checks 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
On Fri, Dec 10, 2010 at 5:34 PM, Cédric Villemain
wrote:
> 2010/12/8 Kineticode Billing :
>> On Dec 8, 2010, at 10:37 AM, Chris Browne wrote:
>>
>>> Other possibilities include TRANSIENT, EPHEMERAL, TRANSIENT, TENUOUS.
>>
>> EVANESCENT.
>
> UNSAFE ?
>
own to hold, there's a real chance the
> DBA will be backed into a corner where he simply has no choice but to
> not use foreign keys, even though he might really want to validate the
> foreign-key relationships on a going-forward basis.
>
> --
> Robert Haas
> EnterpriseDB: http
On Sun, Dec 5, 2010 at 6:59 PM, Robert Haas wrote:
> On Sun, Dec 5, 2010 at 2:45 PM, Rob Wultsch 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 hardware.
--
> Greg Smith 2ndQuadrant US g...@2ndquadrant.com Baltimore, MD
> PostgreSQL Training, Services and Support www.2ndQuadrant.us
>
Forgive me, but is all of this a step on the slippery slope to
direction io? And is this a bad 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
On Sun, Dec 5, 2010 at 12:45 PM, Rob Wultsch 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 gro
y
>
> The last is a major issue, and not one I think we can easily resolve. MySQL
> has a pooling-friendly user system, because when you connect to MySQL you
> basically always connect as the superuser and on connection it switches you
> to your chosen login role. This, per Rob Wulsch,
able SELECT 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-hac
t; Regards,
> Marti
>
++
I have 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
s 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
ore, and all of it will happen again."
At this point pg has the equivalent of MySQL's "show slave status" in
4.0. The output of that change significantly over time:
http://dev.mysql.com/doc/refman/4.1/en/show-slave-status.html
http://dev.mysql.com/doc/refman/5.5/en/show-slave-s
fail to start
> at all if we just changed the default for max_wal_senders and not the
> default 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
replic
#x27;s not easy to address that problem.
> So I'm worried about that implementing that capability first means the miss
> of sync rep in 9.1.
>
> Regards,
>
> --
> Fujii Masao
> NIPPON TELEGRAPH AND TELEPHONE CORPORATION
> NTT Open Source Software Center
>
>
hings 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?
--
Rob Wultsch
wult...@gmail.com
--
Sent via pgsql-hacker
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
hich is the primary trigger for
> autovacuum vacuum freezing. I have added the attached documentation
> patch for autovacuum_freeze_max_age; back-patched to 9.0.
>
> --
> Bruce Momjian http://momjian.us
> EnterpriseDB http://enter
formation_schema. ones arent complete enough and have enough concept
> mismatch to be confusing. But why all this?
>
> Andres
>
Do you have an alternative suggestion for emulating
"SHOW SCHEMAS"
"SHOW TABLES"
"DESC object"?
Make a user friendly interface i
On Fri, Jul 16, 2010 at 10:52 AM, Heikki Linnakangas
wrote:
> On 16/07/10 20:11, Rob Wultsch wrote:
>>
>> On Fri, Jul 16, 2010 at 9:56 AM, Robert Haas
>> wrote:
>>>
>>> For committers.
>>
>> Perhaps this discussions should be moved to the Gene
hat 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
significant size that interact with MySQL have errors because of this
issue and it would be good to not claim 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
On Fri, May 14, 2010 at 11:50 PM, Rob Wultsch 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.
>
&
On Sat, May 15, 2010 at 4:09 AM, Kevin Grittner
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 (pgsql-hackers@postgresql.
On Fri, May 14, 2010 at 7:32 AM, Kevin Grittner
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 W
> 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@postgres
ity to
determine *easily* how much a slave is lagging in clock time.
--
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
Michael Meskes wrote:
On Tue, Feb 16, 2010 at 09:44:26AM +1000, Rob Newton wrote:
Is there some way of building with Pg v8.0 ECPG lib and running on a
system with Pg v8.4 ECPG lib? or vice versa? and is libecpg_compat
intended for that purpose?
You can link the static library in so you&#x
Boszormenyi Zoltan wrote:
Rob Newton írta:
Is there some way of building with Pg v8.0 ECPG lib and running on a
system with Pg v8.4 ECPG lib? or vice versa? and is libecpg_compat
intended for that purpose?
You can build the src/interfaces/libpq and src/interfaces
mpat.so.3.
Is there some way of building with Pg v8.0 ECPG lib and running on a
system with Pg v8.4 ECPG lib? or vice versa? and is libecpg_compat
intended for that purpose?
Thanks,
Rob
--
Sent via pgsql-general mailing list (pgsql-gene...@postgresql.org)
To make changes to your sub
he gets a call at
3AM that a server
(p3.any43.db69.I_have_no_clue_what_this_stupid_f'ing_server_is.wtf.pg
) is at max-connections. I think that some helpful hints for non-pg
dba's that are using pg in some 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
else if (MYSQL_HELP_CHECK("show processlist"))
+ {
+ MYSQL_HELP_OUTPUT("SELECT * from
pg_stat_activity");
+ }
+ else if (MYSQL_HELP_CHECK("desc"))
+ {
+
onstraints, and a MySQL
> blog hinted some time ago that it might be in SQL 201x.
>
> --
> Alvaro 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.co
gs nor the bad designs decisions from
> MySQL, 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-hac
On Tue, Aug 25, 2009 at 10:36 AM, Pavel Stehule wrote:
> 2009/8/25 Rob Wultsch :
>> 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 some
13='val13',
col14='val14',
col15='val15';
Which I think sometimes compares very favorably
INSERT INTO t
(col1,col2,col3,col4,col5,col6,col7,col8,col9,col10,col11,col12,col13,col14,col15)
VALUES
('val1','val2','val3','val4'
tc.
Thanks for that - it's very useful. As you say I believe the
documentation is pretty good, it's just that we're not dealing in simple
issues here.
I definitely think I should do a delete rather than a truncate (or drop)
in my case.
Regards
Rob
--
Sent via p
I must admit I've not read up on the various locks that are set so that's a
good point. Is there a good reference for me to read and understand these?
I'm guessing though that a delete from and then an insert never requires an
exclusive lock, what about adding/deleting constraint
ly be something we'll consider.
Rob
Richard Huxton wrote:
Rob Kirkbride wrote:
I've introduced a --delete-not-drop option which simply does a DELETE FROM %
rather than 'DROP and then CREATE'.
Beware foreign-keys slowing you - TRUNCATE all relevant tables shoul
n the table and therefore can continue.
I've introduced a --delete-not-drop option which simply does a DELETE FROM %
rather than 'DROP and then CREATE'.
I hope this sounds sensible and I haven't missed something - I'm still
learning!
Rob
2008/11/25 Gregory Stark <[EMAIL PROTE
Dave,
Ok thanks. Yes, we've got over 1/2 billion rows in one of our tables which
is interesting!
Will post back soon.
Rob
2008/11/25 Dave Page <[EMAIL PROTECTED]>
> On Tue, Nov 25, 2008 at 8:39 PM, Rob Kirkbride <[EMAIL PROTECTED]>
> wrote:
> > Hi,
> >
>
I'm happy with it (I'm a bit rusty at C!), do I post the patch here?
Thanks
Rob
Do you guys need something PG specific or built into PG?
ActiveMQ is very nice, speaks multiple languages, protocols and supports a ton
of features. Could you simply use that?
http://activemq.apache.org/
Rob
h is not necessarily easy and definetly not
quick/simple. SVN also has a number of nice features
like atomic commits, versioning directories, etc.
Later
Rob
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail
> One way to handle this is to have an option, set by
> the client, that
> causes the server to send some ignorable message
> after a given period
> of time idle while waiting for the client. If the
> idleness was due to
> network partitioning or similar failure, then this
> ensures that the
> co
nt,
more end user small $$ contributions that could be
pooled to go towards development, and less risk of
companies developing features without contacting PG
first.
Later
Rob
--- Kris Jurka <[EMAIL PROTECTED]> wrote:
>
>
> On Sat, 30 Apr 2005, Nicolai Petri (lists) wrote:
>
>
As a user, I would definetly prefer to see 8.1
released sooner with the feature set listed below,
than wait another 6+ months for a few other features.
Additionally, the beta may go smoother/faster if you
don't have too many huge features going in at once.
Just my opinion.
Later
Rob
---
that from happening?
later
Rob
--- David Wheeler <[EMAIL PROTECTED]> wrote:
> On Apr 26, 2005, at 8:55 AM, Tom Lane wrote:
>
> > Well, they handle simple situations OK, but we
> keep seeing people get
> > burnt as soon as they venture into interesting
> territory. For
Are rules even needed anymore? Can't you do this all
with triggers? If you want to "DO INSTEAD" just use a
row based trigger, and return null. Or is this less
efficient?
Later
Rob
--- David Wheeler <[EMAIL PROTECTED]> wrote:
> On Apr 26, 2005, at 8:55 AM, Tom Lane
have all the transactions within the
last XX minutes.
Of course feature #3 also needs to have some smarts to
it, so it doesn't create a bunch of completely empty
WAL's everytime the timer runs out. It should only
write and close the WAL if there is actually some new
data in it.
Later
Ro
s.com/registration.jsp
I am only signed up for the -hackers mailing list, so
please let people on the other lists know.
Later
Rob
__
Do you Yahoo!?
Yahoo! Small Business - Try our new resources site!
http://smallbusiness.yahoo.com/reso
That makes it sound as if you didn't do the same level
of testing on *this* release, like it didn't go
through all the tests or something.
How about "it does not have the extensive testing
history that other supported platforms in this release
have."
Later
Rob
flash card is not all that bad. $189
for 2.2GB is very reasonable when you consider the 512MB CF is going for
$149!
These are basically IDE drives in a compact flash form factor, as such they
should have lifetimes approaching a regular IDE drive, right? Just don'
Bruno Wolff III wrote:
On Fri, Apr 23, 2004 at 16:36:57 -0400,
[EMAIL PROTECTED] wrote:
Ease of use is VERY important, but few suggestions that address this are
ever really accepted. Yes, focusing on the functionality is the primary
concern, but "how" you set it up and deploy it is VERY important
Bruce Momjian wrote:
Peter Eisentraut wrote:
Rob wrote:
But I think there is room to go further, I don't see any reason why
that default install can't include example DBs,
One reason is that a useful example database would likely have a
download footprint of 10 MB or more. Having t
[Previously posted to General list]
I have an embedded system running FreeBSD (5.1) that does not have any local
(rotating) storage (i.e. disk drives).
PostgreSQL (7.3.2.1) also runs on this box and (at this point) has two
tables. It is an extremely simple PostgreSQL configuration with the table
ither implementation, but would also reduce the
amount of similar C code in Postgres. Something I think the PostgreSQL
hackers would much prefer.
Later
Rob
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister com
I hate software that does that. To me it immediately
screams "WE DON'T CARE ABOUT DOING THINGS RIGHT!".
my 2cents
Later
Rob
---(end of broadcast)---
TIP 8: explain analyze is your friend
some progress on 2PC with Postgres though.
Later
Rob
>
> The next step is going to be writing 2PC support to the JDBC driver using
> the new backend commands. XA interface would be very nice too, but I'm
> personally not that interested in that. Any volunteers?
>
> Please commen
http://download-east.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/queries2.htm#2054162http://download-east.oracle.com/otndoc/oracle9i/901_doc/server.901/a90125/queries2.htm#2054162
rob
'Oracle 9 tester' :P
On Mon, 30 Sep 2002, Bruce Momjian wrote:
>
> OK, I just received this an
Friendly greetings,
Rob van Nieuwkerk
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
ng
about. I'm just very eager to get rid of this (for our application)
extremely nasty bug !
friendly greetings,
Rob van Nieuwkerk
use full ISO-8859-1 in table
fields without problems ?
Please tell if you want me to do any other tests !
greetings,
Rob van Nieuwkerk
Hi Mark,
I just checked: the "demo.dump" file does not contain any characters
above 0x7F; it's just plain ASCII. So that can't be the reason.
greetings,
Rob van Nieuwkerk
> Rob van Nieuwkerk wrote:
Ehm .., *you* wrote this ! :-)
> I tried to repro
Tom Lane wrote:
>
> [EMAIL PROTECTED] (Rob van Nieuwkerk) writes:
> > The problem is that a SELECT with a certain LIKE condition in combination
> > with a GROUP BY does not find the proper records when there is an index on
> > the particular column present. When the ind
2.2.18
- Intel Pentium III
- postgresql-7.0.3-2 RPMs from the Postgresql site
(the problem also occurs with locally rebuilt Source RPM)
Any help is much appreciated !
Friendly greetings,
Hi all,
I'm one of the accidentally-subscribed readers to the Hackers list. I
mainly wanted to thank Tom for typing this up. I had a great time reading
it and learned a lot. I also wanted to try and help with some personal
experience since God knows I wouldn't be able to code in C or whatever
Me as well!!!
[EMAIL PROTECTED]
- r
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of Jade Rubick
> Sent: November 2, 2000 9:27 AM
> To: PostgreSQL-development
> Subject: [HACKERS] Another remove request
>
>
> I too have tried to remove myself fro
received
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
> Sent: October 29, 2000 2:25 PM
> To: [EMAIL PROTECTED]
> Subject: [HACKERS] its too quiet
>
>
>
> let see that this doesn't generate an error
>
>
I'm getting all of 'em, unfortunately =)
I dunno what's goin' on, but I ended up back on hackers and general, even
tho' I unsubbed from general, and was never on hackers!
Unwanted emails received : plenty
Unsolicited Postgres knowledge : pleasantly rising =)
- r
> -Original Message
84 matches
Mail list logo
