Jim C. Nasby wrote:
A better solution is to use a combination of a timestamp and a sequence.
Why both? Because it's possible for the clock to be set back (though
this is something best avoided), and a sequence will eventually roll
over.
With the default MAXVALUE of a postgresql sequence (9 qu
Dann Corbit wrote:
If I have a 4 million row table, with long rows and big varchar columns
and I run a query on a column like this:
SELECT * FROM inventory WHERE product LIKE '%Table%'
It isn't going to be fast on any system with any database.
Hypothetically it seems one could theore
Various people wrote:
...PostgreSQL...crontab support...pl/pgsql
I've found that with if you can get 5 companies/users to share a
dedicated server you can be much better off than a hosting plan,
and have full control over the services you run.
I'm sharing with 5 other small businesses a dedi
[EMAIL PROTECTED] wrote:
I'm sharing with 5 other small businesses a dedicated server with 60GB
hard drive, 700GB monthly bandwidth on a 10Mbps link for $49/month.
Where is this available?
server4you.net offers such a system today (they claim to be the largest
dedicated server host with 6500
Martijn van Oosterhout wrote:
On Tue, Sep 13, 2005 at 12:15:21PM -0700, Ben wrote:
Oracle has a very handy function called first_value, which can be used
to turn a set like this:
Look at DISTINCT ON ()
Does postgres have something equivalent, or, even better, is there a
reasonable way to
I tried making an aggregate function that concatenates
any non-null strings it encounters, as shown below.
The function works fine on small tables; but when I run
it on one of my larger tables it seems to me that it
crashes the backend - though I don't see anything obvious
in the log.
Acc
I'm looking for a way search for substrings strings within
documents in a way very similar to tsearch2, but my strings
are not alphabetical codes so I'm having a tough time
trying to use the current tsearch2 configurations with them.
For example, using tsearch to search for codes like
'31.03
Tom Lane wrote:
Ron Mayer <[EMAIL PROTECTED]> writes:
...aggregate function that concatenates
any non-null strings it encounters...crashes...
I tried this example in CVS tip and didn't see any particular misbehavior.
One thing is that my table is quite large (20 GB or so of d
Tom Lane wrote:
Hmm. Now that I look at it again, that message implies that something
sent SIGTERM to the backend. You need to figure out where that signal
is coming from and why. ...
is it possible that you've started your postmaster with finite limits
on process runtime? What is the platfo
In the tsearch2 documentation I see a lot of examples where you
add a column of type tsvector to your table and then indexing
that column.
Instead of adding the extra column, would it be possible to
just make a functional index something like this:
create index foo__tsearch on foo using gist
Michael Fuhr wrote:
On Mon, Oct 10, 2005 at 09:51:48AM -0500, Scott Marlowe wrote:
I'll take one Tom Lane or Jan Wieck or (all the other postgresql
hackers go here) over 1,000 MySQL hackers.
... I hope their employers appreciate what they've got.
Is there a good way of telling their employe
Marc G. Fournier wrote:
On Wed, 12 Oct 2005, Joshua D. Drake wrote:
PostgreSQL doesn't suffer from that. Our only real, substantiated
concern that I can see is the potential for the Software Patent crap.
Stupid question here ... if Oracle came at us with "the Software Patent
crap",
Perso
Joshua D. Drake wrote:
[Ron Mayer wrote]
...Oracle...recognized...solid database engineers with
a product with a growing customer base...
...made sense from both a recruiting and a
business growth opportunity to acquire them.
Oracle isn't interested in the 395.00 market.
I think it&
Andrew Sullivan wrote:
On Fri, Oct 14, 2005 at 01:02:00PM -0700, Ron Mayer wrote:
I'd suspect that any single postgresql-support company that had a
similar customer list would get offers from Oracle as well
PostgreSQL support companies don't have the leverage that Oracle and
MySQL
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
(http://www.sap.com/company/sapventures/contacts/i
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
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
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
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);
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
[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(
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
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;
>
>
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
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
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
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
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
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.
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
>
> 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
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
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
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
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
RC3 on Microsoft VirtualPC with Debian Testing passes all tests.
Marc G. Fournier wrote:
We're always looking to improve that list, so we encourage anyone that
is running a platform not listed to please report on any success or
failures with Release Candidate 3.
Running a fresh install of Debian/
Subject says it all. I have a couple 8.0.0rc3 databases (about
1/2TB of GIS data and am upgrading to 8.0.0. Note that I'll
dump&restore when PostGIS gets out of the release-candidate
cycle. If I don't need an initdb I'll probably go to 8.0.0
now. If I do need one I'd try keep running 8.0.0rc3
When I had customers faced with this decision, we made the
recommendation based on which distro employs major contributors
of the software project in question.
For Postgresql's case, RedHat's employment of Tom made
our recommendation to use Red Hat.
Some of our clients are running .NET front ends,
Short summary:
I want something like xpath_list() that returns an array
(instead of a delimited, concatenated string) when multiple
nodes exist in an XML file. It feels to me like that'd
be a better (cleaner) API.
Before I write one, does anyone already have such a
patch? If not, woul
Jan Szumiec wrote:
>
> Does PG allow you to store XML documents as DOM documents?
> Is there such data type? If not, is it very hard to extend
> the type system to include a binary representation of an
> XML document?
There are a few ways. I like the stuff in "contrib/xml2".
There is also the "pgs
Peter Eisentraut wrote:
Am Freitag, 11. Februar 2005 13:37 schrieb Marques Johansson:
A recent Slashdot thread on MySQL performance
(http://developers.slashdot.org/article.pl?sid=05/02/11/038232&from=rss)
contains a comment mentioning the following Fermilab report from May 2003:
They were apparent
Tom Lane wrote:
> Scott Marlowe <[EMAIL PROTECTED]> writes:
>>On Wed, 2005-02-16 at 11:13, Ron Mayer wrote:
>>
>>>Fermilab did have contact information ("mail comments to:") at the
>...
> Right. The question is whether we can get them to update it.
I
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
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
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
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
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
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
> 1. What is your favorite GUI tool for PostgreSQL?
Just psql in an emacs window.
Emacs lets me see large result sets, and keep a history of my commands.
> 2. In your organization, do you have someone who works as full time
> PostgreSQL DBA?
Our Oracle DBA is also the DBA for our production Pos
101 - 149 of 149 matches
Mail list logo
