Robert Treat [EMAIL PROTECTED] writes:
Don't know if I would agree for sure, but i the second vacuum could see
that it is being blocked by the current vacuum, exiting out would be a
bonus, since in most scenarios you don't need to run that second vacuum
so it just ends up wasting resources (or
Wade Klaver [EMAIL PROTECTED] writes:
Not sure how critical this is, but I ran in to a problem building a fresh
checkout of HEAD with 'make -j 6 all'.
Missing dependency, looks like. That could cause worse problems than
this, so it's good to catch. Fix committed --- thanks for the report!
I wrote:
But that someplace else
could easily be a process forked by the backend in question whose sole
purpose is to go through the list of files generated by its parent backend
and fsync() them. The backend can then go about its business and upon
receipt of the SIGCHLD notify anyone that
Kevin Brown wrote:
I have no idea whether or not this approach would work in Windows.
The win32 API has ReadFileScatter/WriteFileScatter, which was developed
to handle these types of problems. These two functions were added for
the sole purpose of making SQL server run faster. They are always
Hello!
The following SQL works:
ALTER TABLE a.foo RENAME TO bar;
But the following doesn't:
ALTER TABLE a.foo RENAME TO b.bar;
The capability to move objects to other schemas
would be quite useful.
Apparently, everything works OK if you change
pg_class.relnamespace with UPDATE, but this is
I sent this a while ago to general and then
hackers and got no response.
The question is whether to qualify the return value
of a function when it returns a domain with
a check clause.
I believe it should--otherwise the domain is
only useful on insert and is not acting
like a full fledged type.
I and some other developers are also interested in.
Do you think we can work together?
Tatsuo Ishii [EMAIL PROTECTED] wrote:
Has this been beaten to death now? Just curious if PITR was in Dev tree
yet. Been out of the loop. TIA.
I and my co workers are very interested in implementing PITR.
Hi
I have a situation that I need flexible number
columns to model the business requirements. It could go up to 1000 columns and
will be a sparse matrix. One option I was considering was to have a table with
col1..col1000
Other option I can consider is store all of them
as name
Don't know. But apparently different users will have
different demands From a database.
Of course, but I would argue that my claim that PostgreSQL is reliable
is backed up by the lack of people posting messages like 'we had a
powercut and now my DB is hosed'.
One thing we could use (and
Hi. I think postgresql is an incredible piece of software, I am
learning how to use it all the time. I ran into a nasty situation
where 1 out of my 3 postgresql machines could not get any stats
logged at all. I did some research and found out why, but it also
led me to believe maybe a new
I've been very slowly continuing my work on two-phase commits for a couple
months now, and I now have my original patch updated so that it applies to
the current CVS tip, with some improvements.
The patch introduces three new commands, PREPCOMMIT, COMMITPREPARED and
ABORTPREPARED.
To start a 2PC
Recently I was tasked with creating a distribution system for
postgres nodes here at work. This would allow us to simply bring up a
new box, push postgres to it, and have a new database.
At the same time, we have started to approach the limits of what we can
do with postgres on one machine. Our
Andrew Dunstan wrote:
Tom Lane wrote:
I kinda thought you had volunteered to work on the psql part...
I don't recall being that specific, but you could be right. In any
case, I didn't want to trip over anyone else, which is why I asked.
I will try to coordinate with Jon.
After
Hello everyone,
I've been going through the PostgreSQL code, and I've reached a point
where I need help.
First of all, when is the PostgresMain() function for the backend executed?
I've inserted some debugging prints, but they never get executed. What
most puzzels me, is that when I execute the
Andrew Dunstan [EMAIL PROTECTED] writes:
After staring at the code for a long time, I think I see how to do this.
It's complicated a bit by the fact that $ is a valid identifier
character. So my current thinking is to say that if we see $ not in a
quote and not preceded by a valid
Tom Lane wrote:
Andrew Dunstan [EMAIL PROTECTED] writes:
After staring at the code for a long time, I think I see how to do this.
It's complicated a bit by the fact that $ is a valid identifier
character. So my current thinking is to say that if we see $ not in a
quote and not preceded by
Austin Gonyou wrote:
On Thu, 2004-02-05 at 14:00, Nicolai Tufar wrote:
-Original Message-
From: Dave Page [mailto:[EMAIL PROTECTED]
My SQL2K servers give me far more sleepless nights than PostgreSQL
ever
did!
You bet! I totally agree with you.
Technicians like you, me
Marc G. Fournier wrote:
[EMAIL PROTECTED]
I set myself as owner, since I didn't figure it was something you really
needed added to your plate? :) Just means you don't have to go through
and do the Approvals for postings when they need it, I'll just do it as my
normal stuff ...
OK, I
Heikki Linnakangas wrote:
I've been very slowly continuing my work on two-phase commits for a couple
months now, and I now have my original patch updated so that it applies to
the current CVS tip, with some improvements.
The patch introduces three new commands, PREPCOMMIT, COMMITPREPARED and
Peter Eisentraut wrote:
Am Freitag, 6. Februar 2004 10:27 schrieb Thomas Hallgren:
I would like some configuration parameters to Pl/Java and I would like some
advice. Where should they go?
1. Something similar to postgresql.conf (it's not extendable though, is
it?)
No, it is not.
A long time ago, in a galaxy far, far away, [EMAIL PROTECTED] (Bruce Momjian) wrote:
Austin Gonyou wrote:
As previously stated by Bruce I believe, the mindshare department needs
some work. For this, the PITR is a necessity, but also when comparing
features with other DBs that people and
21 matches
Mail list logo