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 certification
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 an
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
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 M
Pavel Stehule wrote:
> 2010/10/8 Carlos Mennens :
>> 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 bigger strengths
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 fr
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
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?!?
MyS
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
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 "FLUSH_C
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 need
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 g
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 easie
Tom Lane wrote:
> Ron Mayer 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.
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
>
Tom Lane wrote:
> Ron Mayer 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
>
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.
regre
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:
::=
[ ] { | }
...
::=
|
::=
[ [
[ ] ] ]
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 ar
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');
>
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%
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
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.
ID
Tom Lane wrote:
> Adrian Klaver 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 strong requirem
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 ha
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
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
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?
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
>> wrote:
>> * Greg Smith [090201 00:00]:
>> > Shouldn't someone have ranted about RAID-5 by this point in
>> the thread?
>> You m
Ivan Sergio Borgonovo wrote:
> On Fri, 20 Feb 2009 06:50:22 -0800
> David Fetter 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 ot
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 speed
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
da
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 combin
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 ..
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 tha
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 databas
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, co
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
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
http://archives.postgresql.org/pgsql-patches/2003-09/msg00121.php
[3] http://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
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 Stable,
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 cour
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 m
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
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
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 communit
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 choice
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 lo
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
databa
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 have
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
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 .
>> ...E
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
>
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 MyS
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
undo
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 pa
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 me
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 wi
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 plann
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
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 skil
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
>> c
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
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 ca
Tom Lane wrote:
> Oleg Bartunov <[EMAIL PROTECTED]> writes:
>> On Wed, 8 Aug 2007, cluster wrote:
>>> Does anyone know where I can request an OR-version of plainto_tsquery()?
>
>> plainto_tsquery expects plain text, use to_tsquery for boolean operators.
>
> Are either of these definitions really
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
>
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 in
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 fundamenta
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 us
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 wh
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? :)
Mos
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 Server
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 contri
>
> Benjamin
>
> 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 for.
>&g
the same as priorities.
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 arg
x27;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.
any workload on any RDBMS 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 Enterpri
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 w
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;
>
>
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 sta
[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(
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
f
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);
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
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 fantasie
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 forc
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 e
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 sa
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 gr
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 articl
1 - 100 of 149 matches
Mail list logo
