Mitch Vincent wrote:
>
> There is something else that many aren't considering. In every application
> I've ever written to use any database I use ID numbers of my own making,
> always they're integer. 4 billion is the limit on any integer field, not
> just the OID so there are limitations everyo
Thomas Lockhart wrote:
>
> > FWIW, I checked into MySQL, and as far as I can tell, they have nothing
> > like this implicit 4 billion transactional "limit". So maybe competitive
> > spirit will drive the postgres hackers to fix this problem sooner than
> > later. ;-)
>
> We have *never* had a
On Fri, Jul 28, 2000 at 11:48:10AM -0500, Keith G. Murphy wrote:
> Mitch Vincent wrote:
> >
> > There is something else that many aren't considering. In every application
> > I've ever written to use any database I use ID numbers of my own making,
> > always they're integer. 4 billion is the lim
How suitable is PG for doing larger databases? The need I am
considering would be a financial database that does maybe up to 100k
transactions/day. Obviously, it needs to be very reliable, and have
minimal scheduled, and no unscheduled downtime. Should this project
be on Oracle or Postgres?
t
Ernie <[EMAIL PROTECTED]> writes:
> This query is very fast.
>
> cw=# SELECT distinct n.news_id, headline, link, to_char(created,
> 'mm-dd-hh24:mi'),
> cw-# created FROM news_article_summary n, news_cat nc WHERE n.news_id =
> nc.news_id AND
> cw-# created > CURRENT_TIMESTAMP-30 AND nc.code_i
Looks like one of my tables got corrupted. Can someone explain how to
recover from this?? Trying to drop the table is not working...Postgres
hangs.
Any help is appreciated.
Arthur
> How suitable is PG for doing larger databases? The need I am
> considering would be a financial database that does maybe up to 100k
> transactions/day.
In a day? I think a lot of us do that much in an hour
> Obviously, it needs to be very reliable, and have
> minimal scheduled, and no
I'm new to postgres, but I've quickly become a big fan. Thank you for
such a great project and I hope in the future to be able to contribute
to the effort.
I'm a newbie to the list and as such, I haven't have much of a change
to lurk. I hope my explanation isn't too long and my q
George Robinson II <[EMAIL PROTECTED]> writes:
> What approach would be the most efficient way to accomplish this goal?
> With what language or tools would you recommend? If I were to leave the
> time as a int4, epoch time, what would the select look like to return
> other time formats?
P
I have a legacy database that I am porting to PostgreSQL. One of the
fields is an integer column that actually represents a date. It is
represented as the number of days since July 1, 1867.
What I am wondering is: Is there a function or other means of getting this
integer converted into a real
On Fri, Jul 28, 2000 at 06:53:41PM -0400, Tom Lane wrote:
> George Robinson II <[EMAIL PROTECTED]> writes:
> > What approach would be the most efficient way to accomplish this goal?
> > With what language or tools would you recommend? If I were to leave the
> > time as a int4, epoch time, wh
"Jason C. Pion" <[EMAIL PROTECTED]> writes:
> I have a legacy database that I am porting to PostgreSQL. One of the
> fields is an integer column that actually represents a date. It is
> represented as the number of days since July 1, 1867.
> What I am wondering is: Is there a function or other
> > That's an excellent point, especially considering that *sequences* use
> > an integer to hold their max_value, which is by default 2,147,483,647.
> > You cannot go larger than that, either. I guess it's constrained to be
> > positive. So OIDs give you more potential unique values than seque
I just noticed that path_distance() in geo_ops.c (the "<->" operator
for path datatype) claims to be computing the minimum distance between
any two line segments of the two paths, but actually it's computing the
maximum such distance.
Isn't this broken?
regards, tom lane
I have added the PostgreSQL manual pages to the appendix of my book. I
will be adding an index once the publisher is done proofreading it. All
reports I get are that it looks good.
Addison-Wesley will be printing this book directly from a
Latex-generated Postscript file that I provide. I have a
15 matches
Mail list logo
