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
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.
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
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 command
(send unregister YourEmailAddressHere to [EMAIL
[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
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't
bounce them around too much.
Later
Rob
---(end
://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 answer from an Oracle 9
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
OK, new wording
/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/resources
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
Rob
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has
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
instance,
if the view is a join, you can't
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
--- Bruce
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:
We also use PostgreSQL as our primary db so it
would be more than likely
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
connection
, etc.
Later
Rob
__
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose
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 from this
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
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 comment! I'd like to know what you guys
with it (I'm a bit rusty at C!), do I post the patch here?
Thanks
Rob
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 very new to hacking postgresql but am using
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 PROTECTED]
Rob Kirkbride [EMAIL PROTECTED
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 constraints?
Rob
2008
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 should be
the fastest method if possible
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 pgsql-hackers mailing list (pgsql-hackers
);
+ }
+ 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
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
.
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 subscription:
http
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
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're
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
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
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
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
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
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
,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
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
, 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
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
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
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
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
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
.
--
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
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
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
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
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
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
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
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 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
=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
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
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
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
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
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
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
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
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
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
-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
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
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
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
-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, is one of the things at
the heart of allowing MySQL to support 100,000 low frequency users per cheap
hosting
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
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 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
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
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
ave 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.
ress 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 <r...@robmccoll.com> 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
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 reproduce this bu
problems ?
Please tell if you want me to do any other tests !
greetings,
Rob van Nieuwkerk
ings going wrong with a "en_US"
locale which is the widely-used (single-byte) ISO-8859-1 Latin 1 charset.
Please excuse me if this has nothing to do with what you are talking
about. I'm just very eager to get rid of this (for our application)
extremely nasty bug !
friendly greeti
greetings,
Rob van Nieuwkerk
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/users-lounge/docs/faq.html
79 matches
Mail list logo