Eric McDonald wrote:
Greetings All:
Does anyone here have any insight on to what EAL level Postgres is at
for DOD/Military installations? I see that there's an SE-Linux
fortified version on the Wiki, but no certifications are listed in the
contents.
Any direction to certifications,
Josh Berkus wrote:
With the current patches, the data survives a restart just fine.
Per -hackers, that's not guarenteed.
Not guaranteed is fine. What people are asking for is often survives.
AFAIK we don't truncate the log file created by the log_filename GUC
on every unclean crash and every
Glen Parker wrote:
As was already mentioned, application logs. Unlogged tables would be
perfect for that, provided they don't go *poof* every now and then for
no good reason. Nobody's going to be too heart broken if a handful of
log records go missing, or get garbled, after a server crash or
Lincoln Yeoh wrote:
What's more important to such companies is the ability to scale over
multiple machines.
That question - how much work it is to administer thousands of database
servers - seems to have been largely missing from this conversation.
Apparently back in 2008, Facebook had 1800
Pavel Stehule wrote:
2010/10/8 Carlos Mennens carlos.menn...@gmail.com:
I know that MySQL uses MyISAM storage engine by default... what
storage engine does PostgreSQL use by default ...
PostgreSQL supports and uses just only one storage engine - PostgreSQL.
That said, ISTM one of Postgres's
On this first day of the month, I thought it might be interesting
to re-visit the conventional wisdom about postgres vs mysql.
Do these seem like fair observations?
Storage engines - Advantage Postgres for having far more available.
Postgre has such a wide range of storage engines to choose
Lincoln Yeoh wrote:
Ten or so years ago MySQL was better than Postgres95, and it would have
been easy to justify using MySQL over Postgres95 (which was really slow
and had a fair number of bugs). But Postgresql is much better than MySQL
now. That's just my opinion of course.
Really?!?
MySQL
Gauthier, Dave wrote:
The arguments against PG are not technical.
A few more points that I didn't see in this thread yet that might help
answer the non-technical questions:
* There seem to be more commercial vendors providing support
for Postgres than MySQL - because most mysql support came
Craig Ringer wrote:
On 16/12/2009 9:07 AM, Scott Marlowe wrote:
I'd also recommend moving off of OSX as you're using a minority OS as
far as databases are concerned, and you won't have a very large
community to help out when things do go wrong
It sounds like PostgreSQL is being used as a DB
Scott Marlowe wrote:
Actually, it's usually the drives that lie about fsync, especially
consumer grade (and some server grade) SATA / PATA drives are known
for this.
I'm still looking for any evidence of any drive that lies.
Is there actually a drive which claims to support the
IDE
On Mon, Nov 02, 2009 at 10:52:40AM +, Jasen Betts wrote:
what's the absolute value of '1month -30 days'::interval
Curious what a use case for taking the absolute value
of such mixed intervals might be.
I could imagine such intervals being used for stuff like
XXX is due in Y months but needs
Sam Mason wrote:
It all depends on the problem domain of course, but this seems to work
OK for us! I really want to hack Samba around so that the users can
view the files directly from inside the database, but I'm not sure how
good an idea this really.
hack Samba? Wouldn't it be easier to
Drifting off topic so I'm no longer ccing the lists.
Sam Mason wrote:
The perl Fuse::DBI module's example sounds pretty similar to the
system you described where he file seems to be a column in a table.
http://www.rot13.org/~dpavlin/fuse_dbi.html
FUSE looks pretty easy to get going and I
Tom Lane wrote:
I wrote:
I'm inclined to say that these two cases are out of line with what
the rest of the code does and we should change them.
...
Now, all three of these cases throw invalid input syntax in 8.3,
so this is not a regression from released behavior. The question
is does
Tom Lane wrote:
Ron Mayer rm...@cheapcomplexdevices.com writes:
regression=# select interval '1 1' hour;
Hmm, not sure about that one. We decided a week or two back that we
don't want the thing discarding higher-order field values, and this
seems pretty close to that. As the code
Tom Lane wrote:
Ron Mayer rm...@cheapcomplexdevices.com writes:
Looks like the original questions from the thread
got resolved, but I found this behaviour surprising:
regression=# select interval '1' day to second;
interval
--
@ 1 hour
(1 row)
Should this be 1 second
Finally got around to looking at this thread.
Looks like the original questions from the thread
got resolved, but I found this behaviour surprising:
regression=# select interval '1' day to second;
interval
--
@ 1 hour
(1 row)
Should this be 1 second?
If so I can send a patch.
Sam Mason wrote:
You get an error because 123 11 isn't a valid literal of an
(undecorated) INTERVAL type.
Hmm. should it be?
Skimming the spec makes me think it might be a valid day-time interval.
Quoting the spec:
unquoted interval string ::=
[ sign ] { year-month literal | day-time
Alban Hertroys wrote:
On May 2, 2009, at 9:33 AM, Mike Christensen wrote:
...
create table Threads ( ... Tags int2[], ...);
To me this seems cleaner, but I'm wondering about performance. If I
had millions of threads, is a JOIN going to be faster? ...
...I don't think array values
Rick Schumeyer wrote:
I want to be able to search a list of articles for title words as well
as author names I'm not sure the best strategy for the names. The
full text parser parses the names giving undesirable results.
For example,
select to_tsvector('claude Jones');
Sam Mason wrote:
On Wed, Apr 08, 2009 at 04:56:35PM +0100, Ian Mayo wrote:
One more thing: hey, did you hear? I just got some advice from Tom Lane!
Statistically speaking; he's the person most likely to answer you by
Even so, this might be the #1 advantage of Postgres over Oracle (cost
Robert Treat wrote:
You can be sure that discussion of this topic in this forum will soon be
visited by religious zealots, but the short answer is nulls are bad, mmkay.
A slightly longer answer would be that, as a general rule, attributes of your
relations that only apply to 1% of the
Tom Lane wrote:
Adrian Klaver akla...@comcast.net writes:
Nothing. I have created a Postgres instance on an EC2 virtual machine with
attached EBS(Elastic Block Storage)..[...]
... I wonder whether you have any guarantees about database consistency
in that situation? PG has some pretty
Marco Colombo wrote:
Yes, but we knew it already, didn't we? It's always been like
that, with IDE disks and write-back cache enabled, fsync just
waits for the disk reporting completion and disks lie about
I've looked hard, and I have yet to see a disk that lies.
ext3, OTOH seems to lie.
IDE
Marco Colombo wrote:
Ron Mayer wrote:
Greg Smith wrote:
There are some known limitations to Linux fsync that I remain somewhat
concerned about, independantly of LVM, like ext3 fsync() only does a
journal commit when the inode has changed (see
http://kerneltrap.org/mailarchive/linux-kernel
Greg Smith wrote:
There are some known limitations to Linux fsync that I remain somewhat
concerned about, independantly of LVM, like ext3 fsync() only does a
journal commit when the inode has changed (see
http://kerneltrap.org/mailarchive/linux-kernel/2008/2/26/990504 ). The
way files are
Joshua D. Drake wrote:
On Fri, 2009-02-27 at 10:19 +1300, Tim Uckun wrote:
[according to some page on the web site...]
8.4 was scheduled to be released march 1. Do we know what the
All schedules are subject to change within the community :)
tentative date of release is?
When
Joshua D. Drake wrote:
On Thu, 2009-02-26 at 15:27 -0800, Ron Mayer wrote:
Joshua D. Drake wrote:
On Fri, 2009-02-27 at 10:19 +1300, Tim Uckun wrote:
8.4 was scheduled to be released march 1. ...
I do notice that the Press FAQ with it's Q4 2008 guess
is even more optimistic ...
Wow
Joshua D. Drake wrote:
On Wed, 2009-02-25 at 09:21 +0900, Jordan Tomkinson wrote:
On Wed, Feb 25, 2009 at 12:05 AM, Aidan Van Dyk ai...@highrise.ca
wrote:
* Greg Smith gsm...@gregsmith.com [090201 00:00]:
Shouldn't someone have ranted about RAID-5 by this point in
Ivan Sergio Borgonovo wrote:
On Fri, 20 Feb 2009 06:50:22 -0800
David Fetter da...@fetter.org wrote:
... moving some of the checks
into the database and away from the application.
Since a useful database has *many* applications instead of the
application, I think this is an excellent move.
Gregory Stark wrote:
One thing which has *not* been mentioned which i find positively shocking is
VACUUM. This was once our single biggest source of user complaints. Between
Autovacuum improvements and HOT previously and the free space map in 8.4 the
situation will be much improved.
The other
Gregory Stark wrote:
I'm putting together a talk on PostgreSQL Pet Peeves for discussion at
FOSDEM 2009 this year. I have a pretty good idea what some them are of course,
* The capitalization that makes everyone (customers, execs, etc) I introduce
it to parse the name as Postgre-SQL.
*
Grzegorz Jaśkiewicz wrote:
true, if you don't want to search on values too much ,or at all - use
float[]. But otherwise, keep stuff in a tables as such.
It might be humongous in size, but at the end of the day - prime thing
when designing a db is speed of queries.
If he's worried about
Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I also was confused by its flatness. I am finding the email traffic
almost impossible to continue tracking, so something different is
happening, but it seems it is not volume-related.
Yes, my perception also is that
Joshua D. Drake wrote:
On Fri, 2008-11-21 at 08:18 -0800, Ron Mayer wrote:
Bruce Momjian wrote:
Tom Lane wrote:
... harder to keep
up with the list traffic; so something is happening that a simple
volume count doesn't capture.
If measured in bytes of the gzipped mbox it ...
Its because we
Tom Lane wrote:
Ron Mayer [EMAIL PROTECTED] writes:
Joshua D. Drake wrote:
Its because we eliminated the -patches mailing list.
That's part of it. I've added -patches to the graph at
http://0ape.com/postgres_mailinglist_size/ as well as
a graph of hackers+patches combined; and it still
Zagato wrote:
I have som SQL that in 8.0.3 do:
# SELECT '32 hours'::INTERVAL;
interval
-
@ 1 day 8 hours
And in 8.3.5 do:
seg_veh2=# SELECT '@ 32 hours'::INTERVAL;
interval
@ 32 hours
Why i unable to get my old style of interval, i really need to see the
Chris Browne wrote:
There's a way that compressed filesystems might *help* with a risk
factor, here...
By reducing the number of disk drives required to hold the data, you
may be reducing the risk of enough of them failing to invalidate the
RAID array.
And one more way.
If neither your
Grant Allen wrote:
...warehouse...DB2...IBM is seeing typical
storage savings in the 40-60% range
Sounds about the same as what compressing file systems claim:
http://opensolaris.org/os/community/zfs/whatis/
ZFS provides built-in compression. In addition to
reducing space usage by 2-3x,
You might want to try using a file system (ZFS, NTFS) that
does compression, depending on what you're trying to compress.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
://archives.postgresql.org/pgsql-patches/2003-12/msg00253.php
Ron Mayer
(formerly [EMAIL PROTECTED] who
posted those ISO-8601 interval patches)
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
Ron Mayer wrote:
Tom Lane wrote:
Or someone could try to make it work, but given that no one has taken
the slightest interest since Tom Lockhart left the project, I wouldn't
hold my breath waiting for that.
I have interest. For 5 years I've been maintaining a patch for a client
Doh. Now
Tom Lane wrote:
Maxim Boguk [EMAIL PROTECTED] writes:
[ ndistinct estimates way off ]
Estimating the number of distinct values in a distribution with a long
tail is just a really hard problem :-(
If I have a table where I know it has this property, is there
any way I can tell autovacuum's
Lincoln Yeoh wrote:
At 10:30 PM 6/24/2008, David Siebert wrote:
Which disto is best for running a Postgres server?
Just to add one more slightly different philosophy.
For servers I manage, I run the most conservative
and slow changing distros that only update security
releases (Debian
Magnus Hagander wrote:
Craig Ringer wrote:
with a version of PostgreSQL with the same minor version as the one
you were using on the server, eg if you were using 8.1.4 you should
get the latest PostgreSQL in the 8.1 series (NOT 8.2 or 8.3) to try
to read the data.
What you mean here is of
Ben wrote:
I'm working on a project which requires me to keep track of objects,
each of which can have an arbitrary number of attributes. Although there
will be many attributes that an object can have,...
Anyway, this seems like a common problem without a perfect solution, and
I'm sure people
Zdeněk Kotala wrote:
1) What type of names do you prefer?
I'd prefer a pg program that took as arguments
the command. So you'd have pg createdb instead
of pg_createdb.
There are many precedents. cvs update, git pull
apt-get install.
Anyone else like this approach?
Of the choices, though,
Clodoaldo wrote:
...IBM is investing...What does it mean for Postgresql?
One cool thing it means is that there are now *two*
companies (thanks again Fujitsu) bigger than
Oracle backing (to some extent) Postgres.
And now one company bigger than Microsoft.
Yeah, this doesn't affect the
Tom Lane wrote:
Leif B. Kristensen [EMAIL PROTECTED] writes:
On Wednesday 26. March 2008, Ron Mayer wrote:
I'd prefer a pg program that took as arguments
the command. So you'd have pg createdb instead
of pg_createdb.
I like this too. It'd be considerably more work than the currently
Tom Lane wrote:
Leif B. Kristensen [EMAIL PROTECTED] writes:
On Wednesday 26. March 2008, Ron Mayer wrote:
...a pg program that took as arguments
the command. So you'd have pg createdb instead
of pg_createdb.
I'll second that. ...
I like this too.
Though I guess we might need to find
Greg Smith wrote:
On Fri, 14 Mar 2008, Andrej Ricnik-Bay wrote:
A silly question in this context: If we know of a company that does
use PostgreSQL but doesn't list it anywhere ... can we take the
liberty to publicise this somewhere anyway?
I notice Oracle (and sleepycat before them) had a
If one wanted to dump some postgres databases for long term
archival storage (maybe decades), what's the recommended
dump format? Is the tar or plain text preferred, or is
there some other approach (xml? csv?) I should be looking
at instead?
Or should we just leave these in some postgres
Josh Berkus wrote:
Id really prefer my company be certified by the community rather than by
a company, despite the full respect I have in SRA's engagement in
PostgreSQL and that we all know their contributions.
What would it mean for a company to be certified?
I'd hope it'd mean that I can
Webb Sprague wrote:
On Feb 1, 2008 2:31 AM, Enrico Sirola [EMAIL PROTECTED] wrote:
I'd like to perform linear algebra operations on float4/8 arrays...
If there were a coherently designed, simple, and fast LAPACK/ MATLAB
style library and set of datatypes for matrices and vectors in
Webb Sprague wrote:
On Feb 1, 2008 12:19 PM, Ron Mayer [EMAIL PROTECTED] wrote:
Webb Sprague wrote:
On Feb 1, 2008 2:31 AM, Enrico Sirola [EMAIL PROTECTED] wrote:
...linear algebra ...
... matrices and vectors .
...Especially if some GIST or similar index could efficiently search
Ted Byers wrote:
--- Webb Sprague [EMAIL PROTECTED] wrote:
...linear algebra ...
... matrices and vectors .
...Especially if some GIST or similar index
could efficiently search
for vectors close to other vectors...
I see a potential problem here, in terms of how one
defines close or
Chris Browne wrote:
[EMAIL PROTECTED] (Zoltan Boszormenyi) writes:
SELECT COUNT(*)
[Waving hands for a moment]
Would what Chris describes below be a good candidate for
a pgfoundry project that has functions that'll create the
triggers for you? (yeah, I might be volunteering, but would
Scott Marlowe wrote:
In particular, MySQl seems to have richer string functions to parse
out sub strings and als trim a string for automatic table insertion
from long multifield strings.
Have you read the postgresql manual on string functions? Seriously,
it's easily a match for MySQL in
Cindy Parker wrote:
...choice of Oracle or PostgreSQL for the back-end...
Can you help me compare PostgreSQL to SQL Server and/or Oracle? Do
you know of any websites or blogs that discuss these issues? ...
I did look at http://sql-info.de/postgresql/postgres-gotchas.html, an
excellent page.
Gregory Stark wrote:
We're not goldfish, we can remember the topic of discussion for at least a few
hours.
So can Goldfish. Apparently they have a 3-month+ memory.
http://nootropics.com/intelligence/smartfish.html
http://en.wikipedia.org/wiki/MythBusters_(season_1)#Goldfish_Memory
With a
Joshua D. Drake wrote:
On Mon, 26 Nov 2007 10:28:03 -0800 (PST)
Richard Broersma Jr [EMAIL PROTECTED] wrote:
--- On Mon, 11/26/07, Joshua D. Drake [EMAIL PROTECTED] wrote:
In theory the item that would be a natural key
in this instance is the VIN.
And you then need to deal with cars that
Chris Browne wrote:
If I replicate your query, with extra columns, AND NAMES, I get the following:
[EMAIL PROTECTED]:5433=# select random() as r1, random() as r2, random() as
r3 from generate_series(1,10) order by random();
r1 | r2 |r3
Greg Sabino Mullane wrote:
...in favor of renaming the database Horizontica.
...should definitely be HorizonticaSQL
Surely that should be capitalized HorizonticASQL, no.
---(end of broadcast)---
TIP 9: In versions below 8.0, the planner will
Dann Corbit wrote:
All of the database systems
that I know of that use this column-oriented scheme are in-memory
database systems. I don't know if Mr. Stonebraker's is also.
KDB+ (http://kx.com/) is column-oriented and has both on-disk
and in-memory capabilities http://kx.com/faq/#6 . It's
Denis Gasparin wrote:
Yeah, you're wrong. The difference is that plain vacuum does not try
very hard to reduce the length of a table file --- it just frees up
space within the file for reuse. vacuum full will actually move things
from the end of the file to free space nearer the head of the
Scott Marlowe wrote:
On 8/14/07, john_sm [EMAIL PROTECTED] wrote:
Hey guys, for an enterprise wide deployment, what will you suggest and why
among - Red Hat Linux, Suse Linux and Ubuntu Linux, also, do you think, we
can negotiate the support pricing down?
It's more about your skill set and
Scott Marlowe wrote:
On 8/14/07, Harpreet Dhaliwal [EMAIL PROTECTED] wrote:
Hi,
I read a few lines about SP compilation in postgres
http://searchoracle.techtarget.com/originalContent/0,289142,sid41_gci1179016,00.html
1. stored procedure compilation is transactional.
You can recompile a
Decibel! wrote:
On Aug 15, 2007, at 2:11 PM, Gregory Stark wrote:
Decibel! [EMAIL PROTECTED] writes:
On Wed, Aug 15, 2007 at 01:26:02PM -0400, Steve Madsen wrote:
On Aug 15, 2007, at 11:52 AM, Decibel! wrote:
I can't really think of a case where a seqscan wouldn't return all the
rows in the
David Fetter wrote:
Dollar-quoting is a cute technical solution to that, but you can't
deny that it's simpler if you just restrict the function language to
be SQL-ish so that CREATE FUNCTION can parse it without any
interesting quoting rules. So sayeth Oracle and the SQL standards
committee,
Chris Browne wrote:
The server does not need the overhead of having *any* of the X
desktop things running; it doesn't even need an X server.
You don't need X running on the server in order use those enterprise
management tools; indeed, in a lights out environment, that server
hasn't even
Tom Lane wrote:
Dave Page [EMAIL PROTECTED] writes:
I can't imagine Flickr or Slashdot ...
I'm pretty sure I remember reading that Slashdot had to put enormous
amounts of cacheing in front of their DB to keep it from falling over
on a regular basis.
Yes, slashdot and flickr both use
Tom Lane wrote:
Exactly. VACUUM sucks (ahem) in all ways but one: it pushes the
maintenance costs associated with MVCC out of the foreground query code
paths and into an asynchronous cleanup task. AFAIK we are the only DBMS
that does it that way. Personally I believe it's a fundamentally
Alvaro Herrera wrote:
André Volpato wrote:
The ammount of space saved seems pretty clear to me.
Yeah, zero most of the time due to alignment.
So trading off more I/O for less CPU?
I wonder if for any I/O bound database servers
it might be worth packing tightly rather than
aligning indexes
Alvaro Herrera wrote:
Daniel Barlow wrote:
1 battery life from my laptop, I noticed that one source of periodic disk
writes was the postgres stats collector process, which appears to
write to pgstat.tmp every 500ms)
Hmm, I don't think we have an optimization to avoid writing it when the
Joshua D. Drake wrote:
Ron Mayer wrote:
How about if PostgreSQL periodically check for updates on the
internet and log WARNINGs as soon as it sees it's not running
the newest minor version for a branch. ...
uhmmm gah, errm no... e why? :)
Mostly because it seems like a near FAQ here
Carlos Moreno wrote:
Tom Lane wrote:
Well, if you can't update major versions that's understandable; that's
why we're still maintaining the old branches. But there is no excuse
for not running a reasonably recent sub-release within your branch.
Slammer..bug in Microsucks SQL
William Garrison wrote:
I've never worked with a database with arrays, so I'm curious...
+ Efficiency: To return the set_ids for an Item, I could return an array
back to my C# code instead of a bunch of rows with integers. That's
probably faster, right?
You should look in to the contrib
.
It seems to me that Bizgres and/or PostgreSQL would not
want to re-implement OS features like schedulers.
On Feb 20, 2007, at 5:19 PM, Ron Mayer wrote:
Bruce Momjian wrote:
Hard to argue with that.
Is it a strong enough argument to add a TODO?
I'm thinking some sort of TODO might be called
with OS's that support priority inheritance).
* Investigate if postgresql could develop an
additional priority mechanism instead of using
the OS's.
Ron Mayer wrote:
Magnus Hagander wrote: ...
quite likely to suffer from priority inversion
... CMU paper
priority inheritance).
* Investigate if postgresql could develop an
additional priority mechanism instead of using
the OS's.
Ron Mayer wrote:
Magnus Hagander wrote: ...
quite likely to suffer from priority inversion
... CMU paper... tested PostgreSQL (and DB2) on TPC-C
and TPC-W
where priority inversion
causes more harm than benefit?
Ron Mayer
---(end of broadcast)---
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
Ron Johnson wrote:
Who would they target anyways?
There's no one company
They could buy out CommandPrompt and EnterpriseDB...
The buyouts wouldn't *kill* pg, but they would wound it mightily.
I don't think so. High-profile and high priced buyouts
of CommandPrompt and EnterpriseDB
Bill Moran wrote:
Does the PostgreSQL project have any similar policy about EoLs?
Is it a question for community support, or for various
commercial vendor's support policies?
How long companies selling postgresql support support each
release could be one of the more important characteristics
pakt sardines wrote:
...the big issue for us is
that the data in the databases has significant intellectual property
value. It has taken literally years of work to collect the data. We do
not want the users of the commercial product to be able to fire up
postgres and type something like:
Joshua D. Drake wrote:
On Wed, 2006-12-13 at 13:20 -0500, John D. Burger wrote:
Surely there are also third-party companies that provide support
for MySqueal in some similar sense?
Yeah. HP for example [links below]. HP announced support
for Debian and MySQL (and the JBoss Stack as well).
Shouldn't the results of this query shown here been sorted by b rather than
by a?
I would have thought since order by b is in the outer sql statement it would
have
been the one the final result gets ordered by.
li=# select * from (select (random()*10)::int as a, (random()*10)::int as b
from
[EMAIL PROTECTED] wrote:
...Should I expect
any problems with this even on the old 2.4 kernel?
I'd advise you to be using a 2.6 kernel at this point, too.
... I assume 8 will still work on 2.4 though.
IIRC, you need a reasonably modern 2.6 kernel (early 2005)
if you want fsync() to flush
Jeff Davis wrote:
On Mon, 2006-11-27 at 12:44 -0800, Ron Mayer wrote:
Shouldn't the results of this query shown here been sorted by b rather
than by a?
I would have thought since order by b is in the outer sql statement it
would have
been the one the final result gets ordered by.
li
Tom Lane wrote:
Jeff Davis [EMAIL PROTECTED] writes:
On Mon, 2006-11-27 at 12:44 -0800, Ron Mayer wrote:
li=# select * from (select (random()*10)::int as a, (random()*10)::int as b
from generate_series(1,10) order by a) as x order by b;
It looks like a planner bug.
It looks to me like
Merlin Moncure wrote:
looks much better than OrgID. I suggest not prefixing tables with
'tbl', but idx_ for indexes and fk_ for foreign keys is ok.
I've recently gotten into the habit of naming my indexes after
exactly what they index. For example:
create index foo(x,y,z) on foo(x,y,z);
and
redhog wrote:
Is sorting in PostgreSQL stable over subqueries, that is, is
select * from (select * from A order by x) as B order by y;
equivalent with
select * from A order by y, x;
Seems as easy to try as to guess.
If I did this query right, it seems not.
select * from (select
Jim C. Nasby wrote:
On Thu, Sep 14, 2006 at 03:41:06AM -0700, Dhanaraj M wrote:
The utility must update the table whenever there is any change in the
text file.
Can it be automated?
There's nothing in the database that could do this directly.
I've seen examples where someone did this
David Fetter wrote:
On Tue, Jun 13, 2006 at 12:51:57PM -0400, Merlin Moncure wrote:
On 6/13/06, David Fetter [EMAIL PROTECTED] wrote:
SQL was a quick and dirty hack...
If there are better alternatives, they will need to show some
real-world attributes, not mathematically-inspired fantasies,
On May 9, 2006, at 11:26 AM, Joshua D. Drake wrote:
Of course not, but which drives lie about sync that are SATA? Or more
specifically SATA-II?
With older Linux drivers (before spring 2005, I think) - all of
them - since it seems the linux kernel didn't support the
write barriers needed to
Renato Cramer wrote:
Can someone where I can found DBMS Market Researches?
What institutes publish reliable researchs? Gartner, IDC?
Note it's hard for any company to provide reliable research
that spans both open-source and non-open-source products.
For example, one company I'm familiar with
Ian Harding wrote:
...
works fine, but you have to do it The Rails Way and expect no help
from the Community because they are a fanboi cheerleader squad, not
interested in silly stuff like referential integrity, functions,
triggers, etc. All that nonsense belongs in the application!
You
ANSI has declared that the official pronunciation for SQL is /ɛs kjuː ɛl/
Klint Gore wrote:
Who's they? The only datbase vendor I've heard call their own product
sequel is MS.
SEQUEL (pronounced sequel) was a predecessor to SQL in IBM's 1970's
System R database; but isn't really the same
Greg Stark wrote:
Well it's worse than that. If you have long-running transactions that would
cause rollback-segment-overflow in Oracle then the equivalent price in
Postgres would be table bloat *regardless* of how frequently you vacuum.
Isn't that a bit pessimistic? In tables which mostly
w_tom wrote:
Series mode protector will ignore or avoid THE one and essential
component of an effective protection system - single point earth
ground.
Indeed. And yes, a high end data center should survive
a lightning strike (as well as hospital's power systems, etc).
Here's a nice
Tom Lane wrote:
Chris Browne [EMAIL PROTECTED] writes:
Of course, if the ability to support R/3 ...
Ah-hah. *Now* it's all clear: an alternative to Oracle for SAP...
Speaking of SAP...
Jeff Nolan, a Venture Capitalists from SAP Ventures
1 - 100 of 146 matches
Mail list logo