On Tue, 4 Nov 2003, Tom Lane wrote:
Jan Wieck [EMAIL PROTECTED] writes:
What still needs to be addressed is the IO storm cause by checkpoints. I
see it much relaxed when stretching out the BufferSync() over most of
the time until the next one should occur. But the kernel sync at it's
Is this a bug we should fix for 7.3.5 when it eventually comes out?
On Tue, 4 Nov 2003, Andrew Rawnsley wrote:
Just build RC1 today on Panther, no problems.
On Nov 4, 2003, at 5:06 PM, Jeff Hoffmann wrote:
Tom Lane wrote:
[EMAIL PROTECTED] writes:
After spending a few hours of
On Tue, 4 Nov 2003, Gaetano Mendola wrote:
I agree in general with you for these general arguments, but here we
are talking about to introduce a sleep ( removable by guc ) or not! What
about the hash refactoring introduced with 7.4? Are you going to
discourage people to use the hash?
On Wed, 5 Nov 2003, Rod Taylor wrote:
Since this is a large query, attachments for the explains / query.
Configuration:
dev_iqdb=# select version();
version
On Wed, 5 Nov 2003, Tom Lane wrote:
Rod Taylor [EMAIL PROTECTED] writes:
I'm not sure if that will actually change the default_statistics_target
Hmm.. I was under the impression that it would work for any tables that
haven't otherwise been overridden.
It will. I think Scott is
On Fri, 7 Nov 2003, Matthew T. O'Connor wrote:
- Original Message -
From: Jan Wieck [EMAIL PROTECTED]
Tom Lane wrote:
Gaetano and a couple of other people did experiments that seemed to show
it was useful. I think we'd want to change the shape of the knob per
later
On Sun, 9 Nov 2003, Jan Wieck wrote:
scott.marlowe wrote:
On Fri, 7 Nov 2003, Matthew T. O'Connor wrote:
- Original Message -
From: Jan Wieck [EMAIL PROTECTED]
Tom Lane wrote:
Gaetano and a couple of other people did experiments that seemed to show
it was useful
On Tue, 16 Dec 2003, Jon Jensen wrote:
On Tue, 16 Dec 2003, Jan Wieck wrote:
If you want to prevent accidential access, start postmaster on a
non-standard port.
That seems like an unfriendly thing to do. You'd have to check to see what
port is standard for this particular
On Fri, 19 Dec 2003, Bruce Momjian wrote:
Robert Treat wrote:
Wasn't there a patch posted many months ago for PITR. IIRC it wasn't
complete, but would be a good starting point for those interested in
helping out. If it's in the archives it would be nice to add a link to
it on the project
On Mon, 12 Jan 2004, Martin Marques wrote:
Mensaje citado por Marc G. Fournier [EMAIL PROTECTED]:
Native Win32 is planned for it (whether it makes it or not is another
question, but it is the goal) ...
Replication wasn't another BIG one?
Actually, I think it was PITR (Point in Time
On Fri, 16 Jan 2004, Michael Brusser wrote:
Is there a way to force database to load
a frequently-accessed table into cache and keep it there?
Nope. But there is a new cache buffer handler that may make it into 7.5
that would make that happen automagically.
---(end
On Wed, 21 Jan 2004, Tom Lane wrote:
The GEQO planner module contains six different recombination algorithms,
only one of which is actually used --- the others are ifdef'd out, and
have been ever since we got the code. Does anyone see a reason not to
prune the deadwood?
considering the
On Thu, 22 Jan 2004, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
On Wed, 21 Jan 2004, Tom Lane wrote:
The GEQO planner module contains six different recombination algorithms,
considering the recent discussion about REALLY slow query planning by the
GEQO module, it might
On Wed, 28 Jan 2004 [EMAIL PROTECTED] wrote:
I agree I MAY have an hardware problem. What happens is more a system
freeze than a system crash (there's no panic, no nothing, just freezes, no
disk activity, not network)
I would suspect either bad hardware,a flakey SCSI driver, or a possible
On Wed, 4 Feb 2004, Michael Brusser wrote:
We have customers who prefer to use their backup facilities
instead of what we provide in the app (we use pg_dump)
I hear speed is at least one consideration.
The questions I need to answer are these:
1) Is this absolutely safe to do file copy
I'm using substring. Since I'm a coder more than a database guy, I
expected this:
select substring('abcdefgh',0,4);
would give me
abcd
but it gives me a left aligned 'abc'
select substring('abcdefgh',1,4);
works fine.
select substring('abcdefgh',-4,4);
gives me nothing. Shouldn't a
On Fri, 6 Feb 2004, Joe Conway wrote:
scott.marlowe wrote:
gives me nothing. Shouldn't a negative offset, or even 0 offset result in
an error or something here? Or is there a special meaning to a negative
offset I'm not getting?
In varlena.c there is this comment:
* text_substr
On Tue, 10 Feb 2004, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
No it doesn't. EOF will do fine. The source program doesn't
necessarily have to know anything about COPY, as long as its output is
in a format COPY can cope with (eg, tab-delimited).
The
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote:
Hi, all
What should I do if I want to have 2 completely seperated databases in
PostgreSQL? I want each database to have its own data, log and
everything needed to access that database. I don't want them to share
anything. Has anyone done this
On Wed, 11 Feb 2004 [EMAIL PROTECTED] wrote:
Thank you very much for your reply.
Yes, that's true. But it seems not a good idea if I have many databases
and I want them totally seperated with each other.
What's your opinion? Thanks.
OK, here's the issue. Postgresql uses certain
On Thu, 12 Feb 2004, Rod Taylor wrote:
But for seperating out applications from each other, there's really
nothing to be gained by putting each seperate database application into
it's own cluster.
I believe the initial email requested individual logs, and presumably
the ability to
On Thu, 12 Feb 2004, Stef wrote:
U. Postgresql doesn't natively support cross database queries...
I know, but it does schema's, and currently, the same
notation is used to specify schema's as 'cross database'.
So the planner often reports 'cross-database not allowed'
in areas
On Thu, 12 Feb 2004, Stef wrote:
case in point, the example trigger. i would have expected
deliberate schemaname.table during an insert to work, but
instead the parser complains about cross-database.
I would think just changing the error message to no schema by the name of
On Tue, 10 Feb 2004, Rodrigo wrote:
Shridhar Daithankar wrote:
Just stumbled upon this. just an FYI,
http://www.microsoft.com/sql/yukon/productinfo/top30features.asp
Shridhar
From the page:
A new Snapshot Isolation (SI) level will be provided at the
database level. With
On Tue, 24 Feb 2004, Shridhar Daithankar wrote:
http://www.osnews.com/printer.php?news_id=6136
That page gets a please don't link to printer ready pages error and
redirects to here:
http://www.osnews.com/story.php?news_id=6136
---(end of
On Fri, 27 Feb 2004, Zeugswetter Andreas SB SD wrote:
Ahh. I forgot to detail my ideas on this. It seems to me that we cannot
drop a table space until the directory is empty.
Agreed.
How would it get to be empty? Are you thinking of some sort of connect
database to tablespace
On Fri, 27 Feb 2004, Gavin Sherry wrote:
On Thu, 26 Feb 2004, Alex J. Avriette wrote:
On Thu, Feb 26, 2004 at 11:22:28PM +1100, Gavin Sherry wrote:
Certainly, table spaces are used in many ways in oracle, db2, etc. You can
mirror data across them, have different buffer sizes for
On Fri, 27 Feb 2004, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
Is possible / reasonable / smart and or dumb to look at implementing the
tablespaces as riding atop the initlocation handled stuff.
In my mind, one of the main benefits of this work will be that we'll be
able
On 27 Feb 2004, Chad wrote:
Is it possible for Postgres Btrees to support access by logical row number ?
If not available is ti a huge job to support for sombebody willing to have a go ?
Are talking about logical row operators as maintained by your own code
outside the database, or having
On Fri, 5 Mar 2004, Thomas Swan wrote:
[EMAIL PROTECTED] wrote:
[EMAIL PROTECTED] writes:
[EMAIL PROTECTED] wrote:
Zeugswetter Andreas SB SD [EMAIL PROTECTED] writes:
My feeling is that we need not support tablespaces on OS's without
symlinks.
On Sun, 7 Mar 2004, Tom Lane wrote:
Neil Conway [EMAIL PROTECTED] writes:
Tom Lane wrote:
This is something we need to consider, but we'll need more evidence
before making a choice. One thing that we have very little data about
is how much difference it makes in the quality of planner
On Wed, 10 Mar 2004, Li Yuexin wrote:
Who can tell me how to complete oracle's hierarchical_query through
postgresql?
Look in the contrib/tablefunc directory for the connect_by function.
---(end of broadcast)---
TIP 3: if posting/reading
On Thu, 11 Mar 2004, Josh Berkus wrote:
Scott,
I like it. Would a multiplier be acceptable?
default_stats_index_multiplier = 10
Yeah, I thought about that, but a multiplier would be harder to manage for
most people.I mean, what if your default_stats are at 25 and you want
On Wed, 24 Mar 2004, Andrew Dunstan wrote:
. Peter Eisentraut's program
pro: portable, better featured, no license issues
con: code state uncertain, less well tested
Where is Peter's code available, I'd like to try it out.
---(end of
On Mon, 29 Mar 2004, Marc G. Fournier wrote:
On Mon, 29 Mar 2004, Dave Page wrote:
It's rumoured that Euler Taveira de Oliveira once said:
Hi Christopher,
The \l command should only list databases that the current user is
authorized for, the \du command should only list users
On Wed, 31 Mar 2004, Philip Warner wrote:
At 12:13 AM 31/03/2004, Bruce Momjian wrote:
Yes, they have to check for a proper exit from pg_dump, but there is
still a file sitting around after the dump, with no way to tell if it is
accurate.
Why don't we write a hash into the header or
On 31 Mar 2004, elrik wrote:
[EMAIL PROTECTED] (elrik) wrote in message news:[EMAIL PROTECTED]...
In information i have:
1. when creating view : PostgreSQL parse the query and stock the tree query.
2. when using : PostgreSQL use this tree like a subselect.
my question : Do
On Wed, 7 Apr 2004, Dennis Bjorklund wrote:
On Wed, 7 Apr 2004, Dennis Bjorklund wrote:
Replying to myself here :-)
wants to import it into a 7.3 database. Use the 7.3 dump you might say,
but since BY does not do anything why not remove it from the dump output?
I just realized there
On Thu, 8 Apr 2004, Bruce Momjian wrote:
Fabien COELHO wrote:
This would help me, at least, write correct and portable SQL. :)
Added to TODO:
* Add a session mode to warn about non-standard SQL usage
So it seems that having C-like operators would hurt a lot;-)
So
On Fri, 16 Apr 2004, Christopher Kings-Lynne wrote:
I always ran one of the 2 scripts (can't remember which one) and after that
started checking the dump file, because there were things that didn't get
changed correctly[1].
[1]: I always remember the first conversion I did. I found
On Tue, 20 Apr 2004, Bruce Momjian wrote:
Andrew Dunstan wrote:
past. I think createuser is much worse. :-)
Agreed. Actually, the big problem with the name initdb is that the
name is misleading, and newbies often get confused by it. You are
preparing a data store for many
I almost agree, but I think things that are being actively developed to
eventually move into the backend, like autovacuum or slony-I should be in
contrib. Things that aren't destined for backend integration should be
removed though, like pgbench or dblink or whatnot.
On Wed, 21 Apr 2004,
On Fri, 23 Apr 2004, Bruce Momjian wrote:
Here is a blog about a recent MySQL conference with title, Why MySQL
Grew So Fast:
http://www.oreillynet.com/pub/wlg/4715
and a a Slashdot discussion about it:
On Thu, 5 Feb 2004, Rod Taylor wrote:
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
On Thu, 6 May 2004, Richard Huxton wrote:
Bruce Momjian wrote:
Tom Lane wrote:
Richard Huxton [EMAIL PROTECTED] writes:
Does that mean I'll want to disable triggers while I do this?
Hrm. Right now the code does not fire triggers at all, but that seems
wrong. However, I doubt that
On Thu, 6 May 2004, Tom Lane wrote:
sdv mailer [EMAIL PROTECTED] writes:
The point is pre-forking can *potentially* speed up
connections by 5x as shown in this simplistic
non-conclusive benchmark.
I think this benchmark proves no such thing.
The thing that pgpool is doing is not
For me, the only features I'm likely to use in the upcoming releases are
nested transactions. While PITR is a great selling point, and the Windows
Port is something I do look forward to, having to do half my job
programming windows boxes, nested transactions are a feature I can
genuinely use
On Tue, 4 May 2004, David Garamond wrote:
scott.marlowe wrote:
For me, the only features I'm likely to use in the upcoming releases are
nested transactions. While PITR is a great selling point, and the Windows
Port is something I do look forward to, having to do half my job
On Mon, 26 Apr 2004, Josh Berkus wrote:
Shachar,
I think the concensus was that the runtime part was aprox. four lines
where the case folding currently takes place. Obviously, you would have
to get a var, and propogate that var to that place, but not actually
change program flow.
On Mon, 26 Apr 2004, Josh Berkus wrote:
I think that a talented manager could make the case for certain features.
So? So could any community member with a good grasp of database engineering
and an ability to write persuasive e-mails.
I'd like to inject here that I was the one who
On Tue, 27 Apr 2004, Jochem van Dieten wrote:
[EMAIL PROTECTED] wrote:
(5) Programming languages. We need to make a programming language standard
in PostgreSQL. plpgsql is good, but isn't someone working on a Java
language. That would be pretty slick.
IMHO SQL/PSM would be the obvious
On Mon, 26 Apr 2004, Andrew Payne wrote:
Bruce asked an excellent question:
My question is, What can we learn from MySQL? I don't know there is
anything, but I think it makes sense to ask the question.
After watching the traffic on this, the biggest MySQL lesson has gone
largely
On Wed, 21 Apr 2004 [EMAIL PROTECTED] wrote:
Hi
I am working on a project in postgres..in which i designed customized data type
and operations on it.it requires a look up table..
I have three options regarding this table...
1. Every time a query is executed it creates table assigns values
On Mon, 26 Apr 2004, Andrew Payne wrote:
For those that look to Apache: Apache never had a well-established
incumbent (Oracle), an a well-funded upstart competitor (MySQL). Rob
McCool's NCSA httpd (and later, Apache) were good enough and developed
rapidly enough that they prevented any
On Tue, 27 Apr 2004, Richard Huxton wrote:
On Tuesday 27 April 2004 14:27, Bruce Momjian wrote:
Here are features that are being worked on, hopefully for 7.5:
o tablespaces (Gavin)
o nested transactions (Alvaro)
o two-phase commit (Heikki Linnakangas)
o integrated
On Tue, 27 Apr 2004, Andrew Payne wrote:
Scott Marlowe wrote:
While Apache is and has been wildly popular for bulk hosing and domain
parking, for serious commercial use, Netscape's enterprise server, now Sun
One, has long been a leader in commercial web sites.
Netscrape/SunONE may
On Wed, 5 May 2004, sdv mailer wrote:
Forking is quite fast on Linux but creating a new
process is still 10x more expensive than creating a
thread and is even worse on Win32 platform. CPU load
goes up because the OS needs to allocate/deallocate
memory making it difficult to get a steady
On Wed, 5 May 2004, Rod Taylor wrote:
And, of course, most development environments (perl, php, java etc)
have their own language specific connection pooling solutions.
Yes, the one for php is what I was thinking of when I made my statement.
They work on a per backend basis as Apache does
On Wed, 21 Apr 2004, Shalu Gupta wrote:
Hello,
We are trying to import the TPC-H data into postgresql using the COPY
command and for the larger files we get an error due to insufficient
memory space.
We are using a linux system with Postgresql-7.3.4
Is it that Postgresql cannot handle
I have to say that during beta testing I ALWAYS do an initdb and a reload
just to make sure the pg_dumpall and pg_restore stuff works right. Plus
to make sure problems that might only pop up with a new initdb are found
as well. I probably burn it to the ground several times on a single
beta
On 19 Sep 2002, Greg Copeland wrote:
I think Marc made a pretty good case about the use of command line
arguments but I think I have to vote with Tom. Many of the command line
arguments you seem to be using do sorta make sense to have for easy
reference or to help validate your runtime
On Wed, 25 Sep 2002, Curt Sampson wrote:
On Tue, 24 Sep 2002, Jan Wieck wrote:
And AFAICS it is scary only because screwing that up will simply corrupt
your database. Thus, a simple random number (okay, and a timestamp of
initdb) in two files, one in $PGDATA and one in $PGXLOG would be
called pg_xlog vs. using GUC.
---
scott.marlowe wrote:
On Wed, 25 Sep 2002, Curt Sampson wrote:
On Tue, 24 Sep 2002, Jan Wieck wrote:
And AFAICS it is scary only because screwing that up will simply corrupt
On Wed, 25 Sep 2002, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I don't see the gain of having a file called pg_xlog vs. using GUC.
Well, the point is to have a safety interlock --- but I like Jan's
idea of using matching identification files in both directories.
With that,
On Wed, 25 Sep 2002, Jan Wieck wrote:
scott.marlowe wrote:
Having a FILE called pg_xlog isn't the fix here, it's the result of the
fix, which is to take all the steps of moving the pg_xlog directory and
put them into one script file the user doesn't need to understand to do it
right
If you are seeing very slow performance on a drive set, check dmesg to see
if you're getting SCSI bus errors or something similar. If your drives
aren't properly terminated then the performance will suffer a great deal.
---(end of broadcast)---
On Tue, 1 Oct 2002, John Liu wrote:
what's the default lock in pgsql?
if I issued insert(copy)/or update processed
on the same table but on different records
the same time, how those processes will
affect each other?
postgresql does not do locking in the sense of how most database do
Have you looked at transform_null_equals in the postgresql.conf file to
see if turning that on makes this work like oracle?
On Wed, 2 Oct 2002, Mario Weilguni wrote:
Ok, I checked this again. Up until 7.2, it was possible to compare an empty string
to a number, and it worked::
e.g.: select
On Wed, 2 Oct 2002, Manfred Koizar wrote:
As nobody knows how each of these proposals performs in real life
under different conditions, I suggest to leave the current
implementation in, add all three algorithms, and supply a GUC variable
to select a cost function.
I'd certainly be willing
On Thu, 3 Oct 2002, Manfred Koizar wrote:
On Wed, 2 Oct 2002 14:07:19 -0600 (MDT), scott.marlowe
[EMAIL PROTECTED] wrote:
I'd certainly be willing to do some testing on my own data with them.
Great!
Gotta patch?
Not yet.
I've found that when the planner misses, sometimes
On Thu, 3 Oct 2002, Manfred Koizar wrote:
On Wed, 2 Oct 2002 14:07:19 -0600 (MDT), scott.marlowe
[EMAIL PROTECTED] wrote:
I've found that when the planner misses, sometimes it misses
by HUGE amounts on large tables,
Scott,
yet another question: are multicolunm indices involved in your
On Fri, 4 Oct 2002, Bruce Momjian wrote:
Hans-Jürgen Schönig wrote:
Did anybody think about threaded sorting so far?
Assume an SMP machine. In the case of building an index or in the case
of sorting a lot of data there is just one backend working. Therefore
just one CPU is used.
Hi Sandeep. What you were calling Hot Backup is really called Point in
Time Recovery (PITR). Hot Backup means making a complete backup of the
database while it is running, something Postgresql has supported for a
very long time.
On Mon, 7 Oct 2002, Sandeep Chadha wrote:
Hello to all the
It's on Slashdot, but there's only one post there that mentions the use of
Postgresql.
On 14 Oct 2002, Robert Treat wrote:
Yep, that's them. This is a big win from a PostgreSQL advocacy position,
especially since oracle pr made an official statement against the use of
PostgreSQL. Has this
Oct 2002, Karl DeBisschop wrote:
On Mon, 2002-10-14 at 16:14, scott.marlowe wrote:
It's on Slashdot, but there's only one post there that mentions the use of
Postgresql.
On 14 Oct 2002, Robert Treat wrote:
Yep, that's them. This is a big win from a PostgreSQL advocacy position
On Fri, 11 Oct 2002, Jeff Davis wrote:
They also state that they have more sophisticated ALTER TABLE...
Only usable feature in their ALTER TABLE that doesn't (yet) exist in
PostgreSQL was changing column order (ok, the order by in table creation
could be nice), and that's still almost
On Thu, 31 Oct 2002, Tom Lane wrote:
Neil Conway [EMAIL PROTECTED] writes:
Ok, fair enough -- I agree that we should treat the two cases
differently. But one thing I think we should do in any case is improve
the wording of the error message.
Got a suggestion?
Change:
On Tue, 22 Oct 2002, Igor Georgiev wrote:
edit *pg_hba.conf *
# Allow any user on the local system to connect to any
# database under any username, but only via an IP connection:
host all 127.0.0.1 255.255.255.255trust
I would recommend checking your memory (look for memtest86 online
somewhere. Good tool.) Anytime a machine seems to act flakely there's a
better than even chance it has a bad bit of memory in it.
On Wed, 6 Nov 2002, Nicolas VERGER wrote:
Hi,
I have strange stability problems.
I can't
On Tue, 5 Nov 2002, Florian Litot wrote:
what is the command to launch a sql script not in psql
thanks
without actually being IN psql, you can use it to run one line scripts
like this:
psql dbname -c -- 'single query goes here'
or you can run a large file full of sql queries like this:
On Tue, 12 Nov 2002, Nicolas VERGER wrote:
Scott you're right, it was a hardware problem.
Thanks for your help.
Glad to be of help. What was the problem? Bad memory or bad hard drive?
Just curious.
---(end of broadcast)---
TIP 6: Have you
Curtis, have you considered comparing raw writes versus file system writes
on a raw multi-disk partition?
I always set up my machines to store data on a mirror set (RAID1) or RAID5
set, and it seems your method should be tested there too.
P.s., Tom, the postgresql user would NOT need to run
On 12 Nov 2002, Robert Treat wrote:
On Tue, 2002-11-12 at 16:27, Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
Bruce Momjian writes:
Are we ready for RC1 yet?
Questionable. We don't even have 50% confirmation coverage for the
supported platforms yet.
We can't
On 12 Nov 2002, Robert Treat wrote:
On Tue, 2002-11-12 at 16:27, Tom Lane wrote:
Peter Eisentraut [EMAIL PROTECTED] writes:
Bruce Momjian writes:
Are we ready for RC1 yet?
Questionable. We don't even have 50% confirmation coverage for the
supported platforms yet.
We can't
On Tue, 12 Nov 2002, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
And then it stops. Anyone know why it doesn't run the rest of the
regresssion tests?
Somebody else just reported the same thing on Solaris. Must be
something about the pg_regress script that doesn't play
On Tue, 12 Nov 2002, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
And then it stops. Anyone know why it doesn't run the rest of the
regresssion tests?
Somebody else just reported the same thing on Solaris. Must be
something about the pg_regress script that doesn't play
On Tue, 12 Nov 2002, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
OK, make -x check fails, is there some other way to use -x I'm not
thinking of here?
I was thinking of running the script by hand, not via make:
/bin/sh -x ./pg_regress --temp-install --top-builddir
On Tue, 12 Nov 2002, Tom Lane wrote:
scott.marlowe [EMAIL PROTECTED] writes:
Ok, now that I've run it that way, the last couple of pages of output
look like this:
Hm. So the while read line loop is iterating only once.
I was thinking to myself that something within the while loop
On Thu, 21 Nov 2002, Christopher Kings-Lynne wrote:
I think his point is that they _should_ be equivalent. Surely there's
something in the optimiser that discards '=true' stuff, like 'a=a'
should be
discarded?
I figure that's what he meant, but it isn't what was said. ;)
col
On Thu, 21 Nov 2002, Christopher Kings-Lynne wrote:
I think his point is that they _should_ be equivalent. Surely there's
something in the optimiser that discards '=true' stuff, like 'a=a'
should be
discarded?
I figure that's what he meant, but it isn't what was said. ;)
col
On Thu, 21 Nov 2002, Stephan Szabo wrote:
On Thu, 21 Nov 2002, Christopher Kings-Lynne wrote:
col isn't of the general form indexkey op constant or constant op
indexkey which I presume it's looking for given the comments in
indxpath.c. I'm not sure what the best way to make
On 21 Nov 2002, Rod Taylor wrote:
On Thu, 2002-11-21 at 15:09, scott.marlowe wrote:
On 21 Nov 2002, Rod Taylor wrote:
On Thu, 2002-11-21 at 14:11, Bruce Momjian wrote:
Of course, those would be SQL purists who _don't_ understand
concurrency issues. ;-)
Or they're the kind
On 21 Nov 2002, Rod Taylor wrote:
On Thu, 2002-11-21 at 14:11, Bruce Momjian wrote:
Of course, those would be SQL purists who _don't_ understand
concurrency issues. ;-)
Or they're the kind that locks the entire table for any given insert.
Isn't that what Bruce just said? ;^)
Now, Solaris seems to be running all the tests but failing something like
29 out of 85 of them.
With a vanilla ./configure;make, I get this on a make check:
== running regression test queries==
parallel group (13 tests): char int8 oid int2 int4 varchar name
On Mon, 25 Nov 2002, Christopher Kings-Lynne wrote:
Can you send in the regression.diffs file?
Chris
- Original Message -
From: scott.marlowe [EMAIL PROTECTED]
To: Tom Lane [EMAIL PROTECTED]
Cc: PostgreSQL-development [EMAIL PROTECTED]
Sent: Monday, November 25, 2002 1:41 PM
On Mon, 25 Nov 2002, Christopher Kings-Lynne wrote:
Can you send in the regression.diffs file?
OK, after a bit of hair pulling, and figuring out I was running out of
space because of quotas, I've gotten it to run with only one failure,
which was because of having too many files open, and
On Mon, 25 Nov 2002, Bruce Momjian wrote:
Please try RC2; this is fixed there.
U. That was with rc2
---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
On Tue, 26 Nov 2002, Justin Clift wrote:
Dear Clift,
As a side thought, would you please be able to correct the spelling of
PostgreSQL on the same page. Presently it's spelt PostGreSQL, which
is
incorrect.
Better way, i'v remove postgresql name in the site, as i think you want.
On Tue, 26 Nov 2002, Al Sutton wrote:
D'Arcy,
In production the database servers are seperate multi-processor machines
with mirrored disks linked via Gigabit ethernet to the app server.
In development I have people extremely familiar with MS, but not very hot
with Unix in any flavour,
On 27 Nov 2002, Hannu Krosing wrote:
Al Sutton kirjutas T, 26.11.2002 kell 20:37:
D'Arcy,
In production the database servers are seperate multi-processor machines
with mirrored disks linked via Gigabit ethernet to the app server.
In development I have people extremely familiar with
1 - 100 of 238 matches
Mail list logo