Okay, maybe this query isn't quite as simple as I think it is, but does
this raise any flags for anyone? How did I get into a COPY? It appears
re-creatable, as I've done it twice so far ...
eceb=# select e.idnumber,e.password from egi e, auth_info a where e.idnumber !=
a.idnumber;
Backend
On Mon, 30 Apr 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Okay, maybe this query isn't quite as simple as I think it is, but does
this raise any flags for anyone? How did I get into a COPY? It appears
re-creatable, as I've done it twice so far ...
eceb=# select
On Mon, 30 Apr 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Does anyone have any outstanding fixes for v7.1.x that they want to see in
*before* we do this release? Any points unresolved that anyone knows
about that we need to look at?
FWIW, I've finished committing
most odd ... its set to start on rebooted, but either it went down on its
own, or didn't ... restarted now, let me know if its not working ...
On Fri, 4 May 2001, Thomas Lockhart wrote:
cvsup -L 2 postgres.cvsup
Parsing supfile postgres.cvsup
Connecting to postgresql.org
Cannot
On Fri, 4 May 2001, Bruce Momjian wrote:
I see by the messages that 7.1.1 is in the final packaging. Anyone know
when it will be released?
Only Marc knows. :-)
Tomorrow aft ... sorry, got tied up with a client finishing his server
move to v7.1 this afternoon, and we hit problems with a
thnks :)
On Fri, 4 May 2001, Bruce Momjian wrote:
OK, I have updated the file dates for a release tomorrow.
On Fri, 4 May 2001, Bruce Momjian wrote:
I see by the messages that 7.1.1 is in the final packaging. Anyone know
when it will be released?
Only Marc knows. :-)
Sorry, worst Subject I've ever come up with, but this is one of those I
haven't got a clue how to describe emails ...
Simple query:
SELECT distinct s.gid, s.created, i.title
FROM status s LEFT JOIN images i ON (s.gid = i.gid AND i.active), personal_data
pd, relationship_wanted rw
On Sat, 12 May 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
So why is it counting 12 more images then are actually found/exist:
Hm. Could we see the EXPLAIN output for both of those?
without count:
NOTICE: QUERY PLAN:
Unique (cost=8.66..8.67 rows=1 width=37
On Sat, 12 May 2001, Tom Lane wrote:
Ah, I see it: your join against relationship_wanted isn't unique.
globalmatch=# select count(*) from personal_data pd
globalmatch-# where pd.gid = 17111 AND pd.gender = 0;
count
---
1
(1 row)
globalmatch=# select count(*) from
On Sat, 12 May 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
So that inflates the number of rows coming out of the join by 5.
Okay, then I'm lost ... why wouldn't that show up without the COUNT()? I
doubt doubt your analysis, I just want to understand why ...
You
ftp://ftp.postgresql.org/pub/source/v7.1.2 ...
Just want a second opinion before I announce more publicly ...
Thanks ...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary:
broken how? I just connected into it ...
On Tue, 22 May 2001, Karl DeBisschop wrote:
The Hermit Hacker wrote:
ftp://ftp.postgresql.org/pub/source/v7.1.2 ...
Just want a second opinion before I announce more publicly ...
I'd check. But the postgresql ftp site appears to be broken
On Tue, 29 May 2001, Tom Lane wrote:
Gavin Sherry [EMAIL PROTECTED] writes:
The column 'zip' is of type text. As such, indices will not be used except
in the case when the where clause is WHERE zip ~ '^text' for btree
indices.
Uh ... nonsense.
Oh good, I was worried there for a sec ...
Tom, with all the work you've been doing inside planner and optimizer, has
there been anything done for 7.1.2 to make how a query is written cause
the backend to be more intelligent?
I'm playing with a query that I just don't like, since its taking ~3min to
run ...
It started as:
EXPLAIN
Morning all ...
Build a file with 100k INSERT statements in it, and run psql -f on
that file ... no BEGIN/END in the file, just straight INSERTs ... what is
the max throughput ppl can see?
I'm seeing reports of it maxing out on an AIX around 450, and on
an HP around 380 ...
On Wed, 6 Jun 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
The 4m:30s is running one process for 100K inserts ... with two
CPUs/processes, it increases the time to process by almost 40% ... ?
Do you mean two processes inserting into the same table?
Yup ...
I
Okay, based on 5k records and a couple of wallclock minutes being equal
to ~120sec, you are getting 41 inserts/sec?
On Wed, 6 Jun 2001, KuroiNeko wrote:
Build a file with 100k INSERT statements in it, and run psql -f on that
file ... no BEGIN/END in the file, just straight INSERTs ...
Great, thanks :)
On Wed, 6 Jun 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
So, this is one of those known problem, improved in v7.2 sort of issues?
Yup.
regards, tom lane
Marc G. Fournier ICQ#7615664 IRC Nick
which I believe is what the rserv implementation in contrib currently does
... no?
its funny ... what is in contrib right now was developed in a weekend by
Vadim, put in contrib, yet nobody has either used it *or* seen fit to
submit patches to improve it ... ?
On Tue, 12 Jun 2001, Zeugswetter
On Wed, 13 Jun 2001, Zeugswetter Andreas SB wrote:
Is there a relative consensus for how often to run vacuum? I have a
table of about 8 columns that I fill with 100,000 items simply via a \i
alarms.sql. After 1,000 items or so it gets extremely slow to fill with
data, and will take
This is just a quick announcement that we have now branched off v7.1.x
from the main development tree, and are starting to dive into development
of v7.2 ...
There have been several changes since v7.1 was released, including:
Fix for numeric MODULO operator (Tom)
pg_dump fixes (Philip)
pg_dump
takes Vince a day or two to catch up ... yes, we are officially released,
and Tom just dump'd some major stats changes into HEAD ...
On Mon, 7 May 2001, Tatsuo Ishii wrote:
Does this mean that we have officially released 7.1.1? I could not
find any statements regarding 7.1.1 on the web
On Wed, 9 May 2001, Peter Eisentraut wrote:
We did not bump the shared library versions before the 7.1 release.
Maybe we should do this before 7.1.2 goes out.
Ummm ... unless there are any changes that would require someone to
recompile their apps between v7.1.1 and v7.1.2, I don't think so
On Wed, 9 May 2001, Bruce Momjian wrote:
We did not bump the shared library versions before the 7.1 release.
Maybe we should do this before 7.1.2 goes out.
I thought I did that long ago for 7.1, or I should have anyway. I don't
see the commits either. Seems we can't do it in a minor
On Wed, 9 May 2001, Peter Eisentraut wrote:
I'm talking about the minor number. The only thing that effects is
that executables would pick up the new version if they have the old
one in the path as well, no potential problems.
Okay, but, what does that buy you? One overwrites the old
On Thu, 10 May 2001, Bruce Momjian wrote:
Are we releasing tomorrow. I will stamp the CVS STABLE branch tonight
as 7.1.2.
Not that I'm aware of ... I heard mention something about a couple of
fixes, but we *just* put out 7.1.1 ...
If ppl are affected by the bugs, use cvsup and set yoru tag
On Thu, 10 May 2001, Tom Lane wrote:
Hiroshi Inoue [EMAIL PROTECTED] writes:
I agree with you because the bug is very critical.
Yes, I'd like to get that plpgsql bug fix out as soon as possible.
Isn't this only critical for those that are using it? Does it affect
those that don't use
it is a branch ... for lack of a better way to work it:
symbolic names:
REL7_1_STABLE: 1.106.0.2
REL7_1_BETA: 1.79
REL7_1_BETA3: 1.86
REL7_1_BETA2: 1.86
REL7_1: 1.102
REL7_0_PATCHES: 1.70.0.2
REL7_0: 1.70
REL6_5_PATCHES: 1.52.0.2
On Thu, 10 May 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Isn't this only critical for those that are using it? Does it affect
those that don't use plpgsql?
No, but I think it's pretty critical for those that do ...
So, why not create a quick patch for those
On Mon, 14 May 2001, Bruce Momjian wrote:
Bruce Momjian wrote:
Can someone tell me what we use indislossy for?
IIRC it means that if you get something by this index you must check
again in the actual data
I think that at least the GIST intarray (actually intset) methods use
On Wed, 16 May 2001, Lamar Owen wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
I am loathe to even bring this up, but with two messages today about it, I am
going to be short and sweet:
We don't have a reasonable upgrade path. ASCII dump-install
new-initdb-restore is not a
On Thu, 17 May 2001, Lamar Owen wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
On Wednesday 16 May 2001 19:05, The Hermit Hacker wrote:
On Wed, 16 May 2001, Lamar Owen wrote:
I am loathe to even bring this up, but with two messages today about it,
I am going to be short
On Sun, 20 May 2001, Vadim Mikheev wrote:
1. Space reclamation via UNDO doesn't excite me a whole lot, if we can
make lightweight VACUUM work well.
Sorry, but I'm going to consider background vacuum as temporary solution
only. As I've already pointed, original PG authors finally
which ones should I pull in? the ones in ~/ftp/pub/doc/7.1? or is there
newer along that tree that we need to generate?
On Tue, 22 May 2001, Peter Eisentraut wrote:
The Hermit Hacker writes:
ftp://ftp.postgresql.org/pub/source/v7.1.2 ...
Just want a second opinion before I announce
all mirrors use rsync to update their code, and all of those that are
listed at www.postgresql.org, both ftp and www, are no more then 2 days
old (Vince, it is two days we set it at, right?) ...
On Wed, 23 May 2001, bpalmer wrote:
On Wed, 23 May 2001, Tom Lane wrote:
every time I've tried
this evening
after some of the mirrors have had a chance to download ...
On Wed, 23 May 2001, Peter Eisentraut wrote:
The Hermit Hacker writes:
which ones should I pull in? the ones in ~/ftp/pub/doc/7.1? or is there
newer along that tree that we need to generate?
You can take
~petere
okay, just removed the .hidden directory from the ftp server, which should
correct that ... I had setup that .hidden directory to be excluded though,
not sure why it was bothering things :(
On Mon, 4 Jun 2001, bpalmer wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
However, it seems
trust me ... girls are soo much fun ... *roll eyes* *watches for
lightening*
On Mon, 11 Jun 2001, Mikheev, Vadim wrote:
I had a baby girl on Tuesday. I am working through my
backlogged emails
today.
Congratulations -:)
Vadim
---(end of
already fixed ...
On Fri, 15 Jun 2001, Oleg Bartunov wrote:
Marc,
when I try to reach http://fts.postgresql.org/ I see
http://www.hub.org/
what's happens ?
Regards,
Oleg
_
Oleg Bartunov, sci.researcher,
Tatsuo ... setting up a seperate CVS module for this does sound like a
great idea ... you already have access to the CVS repository, right? Can
you send me a tar file containing what you have so far, and I'll get it
into CVS and then you'll be able to update that at will?
If we set it up as:
On Mon, 18 Jun 2001, Peter Eisentraut wrote:
Tatsuo Ishii writes:
Hi, some PostgreSQL users in Japan have been translating 7.1 docs into
Japanese. I hope the work would finish within 1-2 months. My question
is how the translated docs could be merged into the doc source tree
once it is
Morning ...
I'm trying to wrack my brain over something here, and no matter
how I try and look at it, I'm drawing a blank ...
I have two tables that are dependent on each other:
notes (86736 tuples) and note_links (173473 tuples)
The relationship is that one
On Mon, 18 Jun 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
FROM note_links nl, notes n LEFT JOIN calendar c ON (n.nid = c.nid)
WHERE (n.type = 'A' OR n.type = 'N' OR n.type = 'H' OR n.type = 'C')
AND (nl.id = 15748 AND contact_lvl = 'company
something like this, web based, would be most cool ... have to be able to
monitor multiple port/backends too ...
On Tue, 19 Jun 2001, [iso-8859-1] Pedro Abelleira Seco wrote:
Hi all!
I'm thinking about starting a (serius) project to
bring a good graphical interface to the administration
Perfect, thank you ... i knew I was overlooking something obvious ... the
query just flies now ...
On Mon, 18 Jun 2001, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Try adding ... AND n.nid = 15748 ... to the WHERE.
n.nid is the note id ... nl.id is the contact id
On Thu, 21 Jun 2001, Tom Lane wrote:
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
How far off is 7.2? Ages?
Hopefully not. I'd like to see us get back on a reasonably short
release cycle, like every six months or less --- the last couple
major release cycles have been painfully
On Fri, 15 Sep 2000, Jan Wieck wrote:
The Hermit Hacker wrote:
*rofl* now that wasn't rigged or nothing ... I could see us second to
MySQL, or third to Oracle/Informix, depending on how it was evaluated, but
fourth to all three?
Hey, look at the headline:
Linux
On Mon, 18 Sep 2000, Tom Lane wrote:
Karel Zak [EMAIL PROTECTED] writes:
Not documented (from oracle_compat.c) in PG documentation:
btrim()
ascii()
ichar()
repeat()
and about ichar() is nothing in Oracle documentation, it's knows chr()
only...
Sounds to me
tom is looking into a bug right now that he wants to try and fix before we
release it ... hopefully this week we'll release it ...
On Tue, 26 Sep 2000, G. Anthony Reina wrote:
I remember a post about 2 weeks back concerning a new patch that was to
be introduced as 7.0.3. I haven't seen any
Can someone add something to the docs that gives an example of what should
be used from the command line to reindex a database's system tables?
All the man page says is use th e-O an d-P options :(
I'm getting:
psql -h pgsql horde
ERROR: cannot read block 6 of pg_attribute_relid_attnam_index
Wow, has this been just one of those days ...
Trying to clean up a few of the database, I'm wondering how to fix some of
these things, if its even possible, without having to rebuild the whole
database:
%~/bin/postgres -O -P -D/pgsql/special/sales.org swissre
DEBUG: Data Base System is
figuring I'd try out getting into the backend using postgres, to see if I
can 'bypass' some of the errors on those corrupted database, I'm wondering
if there is any way of taking what a 'select * from table' outputs:
1: userid = "cibc001154" (typeid = 1043, len = -1, typmod = 36,
Well all, I just spent a bit of time trying to figure out how to recover a
database where the tables appear to be intact with postgres in 'single
user mode', and came up with a quick and dirty that might not be totally
complete, but might help someone else in a similar situation ...
Pointers to what this is? Do we have it documented anywhere? Search
engine, of course, is done, so can't search there ...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary:
Sep 2000, Jules Bean wrote:
On Thu, Sep 14, 2000 at 09:01:50AM -0300, The Hermit Hacker wrote:
okay, this is most odd ... according to the list software, you are still
only subscribed to the general list:
Marc
I can also confirm that I had no message on pgsql-general for about
two
okay, this is most odd ... according to the list software, you are still
only subscribed to the general list:
Address: [EMAIL PROTECTED]
Address is valid.
Address is registered as:
[EMAIL PROTECTED]
Registered at Fri Sep 1 15:33:13 2000 GMT.
Registration data last
On Fri, 29 Sep 2000, Bruce Momjian wrote:
The core group has decided to delay 7.1 beta until November 1. We have
done this to enable the write-ahead log code (WAL) to be shipped with
7.1.
Of course, it also gives me time to catch up on my e-mail, which I am
doing now. :-)
tell me about
On Thu, 5 Oct 2000, D'Arcy J.M. Cain wrote:
Thus spake Bruce Momjian
I have installed this in the current source tree, ready for 7.1.
I have installed
Announce: Release of PyGreSQL version 3.0
When is 7.1 being locked down? I may be releasing 3.1 with a few small
fixes and
On Mon, 9 Oct 2000, Bruce Momjian wrote:
On Mon, 9 Oct 2000, Bruce Momjian wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
hrmm .. mvcc uses a timestamp, no? is there no way of using that
timestamp to determine which columns have/haven't been cleaned up
following
On Tue, 10 Oct 2000, Bruce Momjian wrote:
I am tempted to apply this. This is the second person who asked for
binding to a single port. The patch looks quite complete, with doc
changes. It appears to be a thorough job.
Any objections?
From a quick read of his "description of problem",
On Thu, 12 Oct 2000, Tom Lane wrote:
Zeugswetter Andreas SB [EMAIL PROTECTED] writes:
My conclusion would be that we need both:
1. a fast system table only solution with physical/logical column id
2. a tool that does the cleanup (e.g. vacuum)
But the peak space usage during cleanup
On Fri, 13 Oct 2000, Bruce Momjian wrote:
[ Charset ISO-8859-1 unsupported, converting... ]
we bite the bullet to the extent of supporting a distinction between
physical and logical column numbers, then ISTM there's no strong need
to do any of this other stuff at all. I'd expect that
On Fri, 13 Oct 2000, Zeugswetter Andreas SB wrote:
Hiroshi's patch would make for a good starting point by bringing in the
ability to do the DROP COLUMN feature, as I understand, without the
rollback capability,
No Hiroshi's patch is rollback enabled, simply because all it does is
On Fri, 13 Oct 2000, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
okay, but, again based on my impression of what Tom has stated, and
previous conversations on this topic, the key problem is what happens if I
drop a column and a later date decide add a new column
On Sat, 14 Oct 2000, Bruce Momjian wrote:
On Mon, 21 Aug 2000, Tom Lane wrote:
One thing it might be interesting (please tell me if you think
otherwise) would be to improve pg with better statistical information, by
using, for example, histograms.
Yes, that's been on
Morning all ...
I'm trying to get the committers mailing list to work, and the
"break" is in sendmail, as far as I can tell. Basically, its taking
'locally posted messages' and not adding a domain to the back of it, so
that majordomo sees them as:
--== Error when connecting: Invalid
On Mon, 16 Oct 2000, Bruce Momjian wrote:
What was the matter with the name pg_restore?
I didn't wanna be the one to ask, but I was kinda confused on that point
too ...
Since we may have a workable backup/restore based on WAL available in 7.1,
I am now wondering at the wisdom of creating
On Tue, 17 Oct 2000, Peter Eisentraut wrote:
Philip Warner writes:
I like the pg_{import,export} names myself ... *nod*
Sounds fine also; but we have compatibility issues in that we still need
pg_dump. Maybe just a symbolic link to pg_export.
I'm not so fond of changing a
Something to force a v7.0.3 ... ?
On Mon, 16 Oct 2000, Tom Lane wrote:
... with a blinding flash ...
The VACUUM funnies I was complaining about before may or may not be real
bugs, but they are not what's biting Alfred. None of them can lead to
the observed crashes AFAICT.
What's
On Mon, 16 Oct 2000, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Something to force a v7.0.3 ... ?
Yes. We had plenty to force a 7.0.3 already, actually, but I was
holding off recommending a release in hopes of finding Alfred's
problem.
I thought so, about having plenty
On Thu, 19 Oct 2000, Bruce Momjian wrote:
Bruce Momjian writes:
No. I will turn it into an FAQ, and the item will be "How do I install
PostgreSQL on MS Windows". How's that?
I don't see how that would be better. Why this artificiality?
Installation instructions belong into
http://www.postgresql.org/mhonarc has them all listed .. not sure how to
get there from the Web site ... Vince?
On Mon, 23 Oct 2000, Krzysztof Kowalczyk wrote:
Are mailing list archives of various postgresql mailing list available
anywhere?
I know they were some time ago but I couldn't
makes sense to me
On Thu, 26 Oct 2000, Tom Lane wrote:
After reviewing a number of past threads about the INET/CIDR mess,
I have concluded that we should adopt the following behavior:
1. A data value like '10.1.2.3/16' is a legal INET value (it implies
the host 10.1.2.3 in the network
On Sat, 28 Oct 2000, Larry Rosenman wrote:
Err, with Tom's objections, why was this applied?
was going to ask this too ... someone going patch-happy again? :)
* Bruce Momjian [EMAIL PROTECTED] [001028 11:34]:
Applied. Thanks.
Okay, here's my attempt at fixing the problems with
one list at a time, I move and test .. -hackers is the second ...
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: scrappy@{freebsd|postgresql}.org
I believe that its just resting on Vadim again to give us the go ahead
... which I believe its always been on his shoulders, no? :)
Vadim?
On Mon, 30 Oct 2000, Peter Eisentraut wrote:
Vadim Mikheev writes:
WAL todo list looks like:
So what's the latest on going beta?
--
Peter
Morning all ...
Today, we are moving the mailing lists over to the new mail
server. There *might* be a brief period where any mail sent to the lists
will be returned with a 'user unknown' error, as there will be a brief
period where the aliases will be disabled on the old server and
On Wed, 1 Nov 2000, Bruce Momjian wrote:
Yes, sorry about the delay. Also, I will send a report to core about
the summit.
is there a reason why -hackers wouldn't be interested as well? *raised
eyebrow*
sounds great, then hopefully we get v7.0.3 out early next week :) thanks
...
okay, to date I've just been manually fixing stuff like this, but its time
to debug what the problem is here ...
so, what have you tried to do to set it as digest, and what error did you
get?
On Thu, 2 Nov 2000 [EMAIL PROTECTED] wrote:
I too got somehow on the list without subscribing.
sorry, the migration this past weekend was to remove all traces of hub.org
from the list addresses ... we built a 'virtual server' that now houses
the postgresql.org mailing lists, so you need to send to
[EMAIL PROTECTED], and it should work ...
please try that and let me know if it works or
In order that we can get a few days of testing on these, make sure the
packaging is right and whatnot, we are holding off on a formal release
until early-mid next week ...
I've just put pre-release tar balls into:
ftp://ftp.postgresql.org/pub/source/v7.0.3
Please take a minute to
On Thu, 2 Nov 2000, Tom Lane wrote:
Ned Lilly [EMAIL PROTECTED] writes:
Well, here in relatively minor form is the First Example of a Great
Bridge Priority (which Tom, Bruce, and Jan have all predicted would
come... ;-)
Hmm. I wasn't aware that Jan had done it at Great Bridge's
On Thu, 2 Nov 2000, Bruce Momjian wrote:
Ned Lilly [EMAIL PROTECTED] writes:
Well, here in relatively minor form is the First Example of a Great
Bridge Priority (which Tom, Bruce, and Jan have all predicted would
come... ;-)
Hmm. I wasn't aware that Jan had done it at Great
On Thu, 2 Nov 2000, Tom Lane wrote:
Lamar Owen [EMAIL PROTECTED] writes:
I do have a question -- just how much configuration (and other) changes
occurred to REL7_0_PATCHES (since the logs seem to not be telling the
whole story)?
I say this because I found at least one such change --
On Thu, 2 Nov 2000, Ned Lilly wrote:
We recognize this is a temporary hack - and fully expect it to go away
in 7.1 We actually think that the final solution might be more
appropriate in pg_dump itself than pg_dumpall, but that's obviously a
much more breakable proposition (hence the separate
I'm tryin to figure out how to speed up udmsearch when run under
postgresql, and am being hit by atrocious performance when using a LIKE
query ... the query looks like:
SELECT ndict.url_id,ndict.intag
FROM ndict,url
WHERE ndict.word_id=1971739852
AND url.rec_id=ndict.url_id
AND
yowch ... removing that one index makes my 'test' search (mvcc) come back
as:
[97366] SQL 0.05s: SELECT ndict.url_id,ndict.intag FROM ndict,url WHERE
ndict.word_id=572517542 AND url.rec_id=ndict.url_id AND (url.url LIKE
'http://www.postgresql.org/%')
vs what we were doing before ... now,
On Mon, 6 Nov 2000, Philip Warner wrote:
At 21:59 5/11/00 -0500, Tom Lane wrote:
Looks like a great kluge to me ;-)
Hmph. I prefer to think of it as a 'user-defined optimizer hint'. ;-}
Except, if we are telling it to get rid of using the index, may as well
get rid of it altogether, as
On Sun, 5 Nov 2000, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
On Mon, 6 Nov 2000, Philip Warner wrote:
At 21:59 5/11/00 -0500, Tom Lane wrote:
Looks like a great kluge to me ;-)
Hmph. I prefer to think of it as a 'user-defined optimizer hint'. ;-}
Except, if we
On Mon, 6 Nov 2000, Philip Warner wrote:
At 23:12 5/11/00 -0400, The Hermit Hacker wrote:
Except, if we are telling it to get rid of using the index, may as well
get rid of it altogether, as updates/inserts would be slowed down by
having to update that too ...
So long as you don't
On Sun, 5 Nov 2000, Bruce Momjian wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I am adding a new TODO item:
* Add SET PERFORMANCE_TIPS option to suggest INDEX, VACUUM, VACUUM
ANALYZE, and CLUSTER
Seems we should be able to emit NOTICE messages suggesting performance
what version of CVS are you running? when was the last time you did
anything with it?
cvs on hub hasn't been upgraded since Sept 13th, so it isn't an upgrade
issue ... and just tested from work, and I can checkout no probs ...
On Mon, 6 Nov 2000, Michael Meskes wrote:
Here's what I get
ya know, I always love seeing email's like this ... what time do you
consider to be the end of the day? and going directly to the top means
talking to ... wow, me. and its the end of my day here, and I don't have
you off yet, so now you are in a pickle, no? :)
On Wed, 1 Nov 2000, Jones,
On Thu, 9 Nov 2000, Alfred Perlstein wrote:
* Bruce Momjian [EMAIL PROTECTED] [001109 18:55] wrote:
I guess the immediate question is do we want to hold up 7.0.3 release
for a fix? This bug is clearly ancient, so I'm not sure it's
appropriate to go through a fire drill to fix it for
On Thu, 9 Nov 2000, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Tom, if you can plug this one in the next, say, 48hrs (Saturday night),
Done. Want to generate some new 7.0.3 release-candidate tarballs?
Done, and just forced a sync to ftp.postgresql.org of the new tarballs
If its that easy to fix the regress test so that it passes, can we get it
committed and build a new tarball so that ppl doing regression on v7.0.3
see a clean regress?
On Tue, 7 Nov 2000, Tom Lane wrote:
Pete Forman [EMAIL PROTECTED] writes:
The only remaining failure is geometry. The
fixed, let mek now if there are any others I've missed ...
On Mon, 13 Nov 2000, Larry Rosenman wrote:
Are the @postgresql.org addresses supposed to work?
-Original Message-
From: Mail Delivery Subsystem [mailto:[EMAIL PROTECTED]]
Sent: Monday, November 13, 2000 4:13 PM
To:
On Tue, 14 Nov 2000, Hannu Krosing wrote:
when trying to do
get -R RedHat-6.x RedHat-7.0 Mandrake-7.x
I got
get RedHat-7.0: server said: Permission denied on server. (Transfer
limits exceeded)
aftre all of RedHat-6.x was retrieved
is there any reason for this ?
Yes, we don't
I'm at Comdex right now, but when I'm around, I'm on channel ...
On Tue, 14 Nov 2000, Alfred Perlstein wrote:
I remeber a few developers used to gather on efnet irc,
there was a lot of instability recently that seems to have
cleared up even more recently.
Are you guys planning on coming
On Fri, 3 Nov 2000, Bruce Momjian wrote:
I have talked to GB and they understand their error.
Until the next time? This isn't the first time you've "talked to
them" ...
101 - 200 of 403 matches
Mail list logo