On Tue, 5 Aug 2003, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Please test and let me know if there are any problems ...
The .gz tarball matches what I have here. Didn't check the .bz2 one.
All the .bz2 one is is 'gunzip *.gz;bzip2 *.tar', so should be good
'k, removed and trying build again ...
On Tue, 5 Aug 2003, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
GNUMakefile.in:
opt_files := \
src/tools src/corba src/data src/tutorial \
Ah.
I take it then, that src/data shoudl be removed from there too?
Yep. Sorry
Using the attached script, the build fails while trying ot tar up the
distributions ... when its trying to build the tools tar file, error being
that it can't find the src/data directory ... compared against the
snapshot build script, it doesn't look like I've missed anything, and i
haven't
I never know what to say in response to stuff like this ... its like
having to sign a card when a co-worker leaves ... then again, unlike most
co-workesr, I can definitely say its been a great pleasure to have known,
and worked, with you ... you brought, and gave, alot to the project, and
for
On Thu, 7 Aug 2003, Bruce Momjian wrote:
Man, I can't do anything right; should be:
one INSERT per transaction, fsync true 934
one INSERT per transaction, fsync false 1818
INSERTs all in one transaction, fsync true 4166
Brain thinking one thing,
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: [EMAIL PROTECTED]|postgresql}.org
---(end of broadcast)---
TIP 8: explain analyze is
On Thu, 7 Aug 2003, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I was just testing the threaded ecpg, and ran some performance tests.
Without using threads, I am seeing 100,000 inserts of a single word into
a simple table take 12 seconds:
CREATE
'K ... I just re-tag'd REL7_4_BETA1 for the changes that were made
(including Bruce's last minute copyright changes) ...
Also, I just modified the script so that it builds both a .gz and a .bz2
version of hte archives ...
Please test and let me know if there are any problems ...
Marc G.
2003, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Using the attached script, the build fails while trying ot tar up the
distributions ... when its trying to build the tools tar file, error being
that it can't find the src/data directory ...
Why is it looking for src/data? I
We (PostgreSQL, Inc) are just in the process of tying up some loose ends
on eRServer v1.2, to be released OSS on GBorg over the next week or so ...
since this is meant to replace rserv, I'd like to remove rserv from the
v7.4 source tree ...
As far as I know, the only patch made to rserv in the
already fixed
On Mon, 28 Jul 2003, Christopher Kings-Lynne wrote:
It's showing the apache page.
Chris
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL
On Fri, 25 Jul 2003, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
'K, fixed the TAG to point to the right revision and am rebuilding the
packages right now ...
Repackaged tarball looks good from here. Don't forget to adjust the
symlink at the top level of the FTP site
Please check it over before I announce it more generally ... but she looks
good from here ..
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED] secondary: [EMAIL PROTECTED]|postgresql}.org
'K, fixed the TAG to point to the right revision and am rebuilding the
packages right now ...
On Thu, 24 Jul 2003, Tom Lane wrote:
The Hermit Hacker [EMAIL PROTECTED] writes:
Please check it over before I announce it more generally ... but she looks
good from here ..
Almost there: src
try it now ... I think its a pathing problem with a cron entry ... just
fixed that, so should be okay now ...
On Wed, 23 Jul 2003, Patrick Welche wrote:
cvs server: Updating src/bin/scripts/po
cvs server: failed to create lock directory for
Did I miss part of a thread here? :)
On Tue, 22 Jul 2003, Josh Berkus wrote:
Andrew,
Arguments? None of those three address the obvious marketing benefit
of having replication shipping with the main tarball, I know.
Those are pretty strong arguments ... and we can't let PostgreSQL new
check it now, should be fine ...
On Mon, 21 Jul 2003, Kurt Roeckx wrote:
When doing cvs update I get:
cvs server: Updating contrib/tsearch2
cvs server: failed to create lock directory for
`/projects/cvsroot/pgsql-server/contrib/tsearch2'
Got stuck with:
A MIME header is too long (353 128)
going through postings now ...
On Wed, 16 Jul 2003, Larry Rosenman wrote:
Yes I am subscribed.
I also sent it to you directly seeing as if it was slow.
LER
--On Wednesday, July 16, 2003 17:16:55 -0400 Tom Lane [EMAIL PROTECTED]
On Wed, 16 Jul 2003, Alvaro Herrera wrote:
On Wed, Jul 16, 2003 at 01:57:41PM -0500, Thomas Swan wrote:
Does anyone have recent archives of the pgsql-hackers list in mbx or
flat file format?
I know that I can search through the website or through other
interfaces, but I would like to
posted and shouldn't be delay'd in the future ...
On Fri, 18 Jul 2003, Tom Lane wrote:
Oleg Bartunov [EMAIL PROTECTED] writes:
today we've commited bug fix in ltree code to current CVS, but I don't see
any notices in COMMITERS mailing list. Do we need to so something
special ?
Check
On Thu, 3 Jul 2003, Oleg Bartunov wrote:
Marc, we hope to get an access to be able submit patches.
I sent back a note to Teodor earlier this evening letting him know that I
think I got the password issue fixed with CVS, but asked him to test and
get back to me ...
On Sat, 28 Jun 2003, Jan Wieck wrote:
Bruce Momjian wrote:
See my recent commit of src/tools/pgtest. It might be a good start.
I was wondering if some existing framework, like from the Apache Xalan
package, would be a better point to start from? I hate to say it, Bruce,
but you try to
On Thu, 26 Jun 2003, Thomas Swan wrote:
Of course, these are just ideas and I'm not sure how practical it is to
do any of them. I just am really concerned about the uninstall/clean up
phase and how that can be done in an orderly fashion. Unless the
process can start from a clean state
On Thu, 26 Jun 2003, Rod Taylor wrote:
I think we should replace Bruce's pgtest script with this one -- with an
argument to accept the email address to report to for FAILING cases.
Success isn't very interesting if it runs regularly.
that was why I suggested getting it into the tree ... to at
On Thu, 26 Jun 2003, Kevin Brown wrote:
It doesn't sound like a bad idea ... but, it pretty much comes down to the
original thread: are you willing to step up and maintain such a project?
Yes, I am (how hard can it be?, he asks himself, knowing all the
while that it's a really bad idea to
On Wed, 25 Jun 2003, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Patch applied. Thanks.
Michael A Nachbaur wrote:
Attached is a patch that provides *VERY* limited support for multiple slave
servers. I haven't tested it very well, so use at your
On Wed, 25 Jun 2003, Tom Lane wrote:
I had originally planned to spend the next week editing all the elog()
calls in the backend to convert them to ereport() format where helpful,
add SQLSTATE values, and update wording to match the style guidelines
that were agreed to awhile back.
However,
On Wed, 25 Jun 2003, Shridhar Daithankar wrote:
On 25 Jun 2003 at 14:50, Andreas Pflug wrote:
Jan Wieck wrote:
Change that into * Remove bugs from source code and get a patent on
it. Should be a nobrainer (as in those guy's have no brains)
considering that NetFlix even got a patent on
On Wed, 25 Jun 2003, Kevin Brown wrote:
So...would it make sense to create a gborg project to which people who
have written their own test suites can contribute whatever code and data
they feel comfortable releasing? As a gborg project, it would be
separate from the main PG distribution and
On Wed, 25 Jun 2003, Alvaro Herrera wrote:
Are you saying that it doesn't matter that it is made more broken? Sorry
if I disagree... we should be trying to fix it, not the other way
around.
If it's so broken, why hasn't it received any improvement? Is there
some problem with the underlying
'K, and do you have any ETA on when you'll have this translated into some
useful tests that we can incorporate?
On Mon, 23 Jun 2003, Dann Corbit wrote:
Here is a list of a small sample of the citations available from the ACM
on software testing:
On Mon, 23 Jun 2003, Dann Corbit wrote:
-Original Message-
From: Jan Wieck [mailto:[EMAIL PROTECTED]
Sent: Monday, June 23, 2003 10:30 PM
To: Dann Corbit
Cc: scott.marlowe; Bruce Momjian; Tom Lane; Jason Earl;
PostgreSQL-development
Subject: Re: [HACKERS] Two weeks to
On Mon, 23 Jun 2003, Dann Corbit wrote:
Would it be nice if we had more tests? Yes. In fact, one of
the items on my
personal todo list is to devise a more versatile performance
test than
pgbench for testing postgresql parameters, builds, and
installations. But
it's not getting
On Tue, 24 Jun 2003, Robert Treat wrote:
On Mon, 2003-06-23 at 21:36, The Hermit Hacker wrote:
On Mon, 23 Jun 2003, Robert Treat wrote:
The target-date-based approach we've taken in the last couple of
releases seems much more productive.
productive on a small scale
On Tue, 24 Jun 2003, Dann Corbit wrote:
I did something about it. I raised the issue.
Is it really so that whoever it is that raises a question is also the
one who must fix the issue raised?
A strange model indeed.
Its worked for us ...
Wait, I know what should make you happy ... it won't
On Tue, 24 Jun 2003, Bruce Momjian wrote:
The Hermit Hacker wrote:
On Tue, 24 Jun 2003, Dann Corbit wrote:
I did something about it. I raised the issue.
Is it really so that whoever it is that raises a question is also the
one who must fix the issue raised?
A strange model
On Tue, 24 Jun 2003, Dann Corbit wrote:
Don't care and won't do are not the same thing.
Well, actually, they are ... if someone doesn't care, they
aren't going to do, are they?
You have had the time to do everything you ever cared about?
No no, that isn't what he is arguing (or I'm
Just a side bar to the whole thread about PHP/MySQL ... I realize that
libpq is intwined with the backend right now, but if anyone could think of
a way of at least adding a make target that would create a libpq.tar.gz
distribution, I believe it would go a long way towards making it easier
for ppl
I'm looking to move both of these over to GBorg, like we did with the C++
interfaces and ODBC ... the problem is, unlike those, I can't find anyone
that is actually working with it ...
Is anyone using these? Anyone willing to step up and act as maintainer
for it?
Marc G. Fournier
On Tue, 24 Jun 2003, Jan Wieck wrote:
The Hermit Hacker wrote:
On Tue, 24 Jun 2003, Bruce Momjian wrote:
The Hermit Hacker wrote:
On Tue, 24 Jun 2003, Dann Corbit wrote:
I did something about it. I raised the issue.
Is it really so that whoever it is that raises a question
On Mon, 23 Jun 2003, Srikanth M wrote:
Hi!
Can anyone give me the informatoin reagarding the last date of
submission of the code to be added in next version of pgsql.
June 30th ...
---(end of broadcast)---
TIP 3: if posting/reading
I second the agreement ... a 'reference implementation', of sorts, at
least gives someone to build on then starting right from scratch ...
On Mon, 23 Jun 2003, Bruce Momjian wrote:
Agreed.
---
Josh Berkus wrote:
Sorry about that, I had long ago fixed the build, but failed to add it to
cron ... new build created and cron entry added ... :(
On Mon, 23 Jun 2003, Tom Lane wrote:
[EMAIL PROTECTED] writes:
Is it me or is there a problem with ftp mirrors?
The latest shapshots I have here are from June
On Mon, 23 Jun 2003, Peter Eisentraut wrote:
Bruce Momjian writes:
Well, it is a nice test template for people who aren't shell script
experts, and I have been in the habit of pushing stuff I use into /tools
so it is available for others.
I know and I'm not happy about it. The
On Mon, 23 Jun 2003, Robert Treat wrote:
The target-date-based approach we've taken in the last couple of
releases seems much more productive.
productive on a small scale; for sure. productive for large scale
features... well, that's why it's being discussed.
'K, but if we extend the
On Mon, 23 Jun 2003, Dann Corbit wrote:
The resistance to testing is typical of programmers. The PostgreSQL
group is a group of programmers. I don't think I can change anyone's
mind, since the most significant people on the list don't think it is
worth the bother.
Therefore, I am going to
On Sun, 22 Jun 2003, Bruce Momjian wrote:
Mike Mascari wrote:
I was disappointed that Satoshi Nagayasu's two-phase commit
patches seemed to be implicitly rejected by lack of an
enthusiastic response by any of the core members. Distributed
query (not replication) would have been a very
On Sat, 21 Jun 2003, Bruce Momjian wrote:
That's a tough call. I do worry about readability. We have made Win32
changes, and they aren't ifdefs, and we still have a running system, and
I think we can do that for PITR too. I think the big issue, which may be
your point, is to get incremental
On Fri, 20 Jun 2003, Dann Corbit wrote:
Designing tests is busywork. Desiging tests is boring. Nobody wants to
design tests, let alone interpret the results and define correct
baselines. But testing is very, very important.
But we do do testing ... we even design testing (in the form of
On Sat, 21 Jun 2003, Dann Corbit wrote:
It seems pretty clear that there are warts on the Crashme test.
Perhaps 70% or so is truly useful. Maybe the useful subset could be
approximated or modified to be useful as a general tool set.
And we all wait with baited breath for you to develop and
On Sun, 22 Jun 2003, Jan Wieck wrote:
The Hermit Hacker wrote:
On Fri, 20 Jun 2003, Dann Corbit wrote:
Designing tests is busywork. Desiging tests is boring. Nobody wants to
design tests, let alone interpret the results and define correct
baselines. But testing is very, very
On Sun, 22 Jun 2003, Bruce Momjian wrote:
Peter Eisentraut wrote:
Bruce Momjian writes:
I have added a cleaned up version of this to CVS as src/tools/pgtest.
This seems to be a platform-specific reimplementation of 'make clean; make
check'. Why bother?
Marc requested it. Is
On Sun, 22 Jun 2003, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
I sure want two-phase commit. I don't remember it as being rejected,
and we certainly need it, independent of replication.
Is 2PC a real-world solution to any real-world problem? I
On Sun, 22 Jun 2003, Bruce Momjian wrote:
Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
Tom Lane wrote:
I think it's a cool-sounding phrase that does not actually work in
practice.
I think 2PC can be used to build more complex features,
Only if it works to begin
On Mon, 23 Jun 2003, Sailesh Krishnamurthy wrote:
I'm not sure if I understand Tom's beef - I think he is concerned about
what happens if a subordinate does not respond to a prepare message. I
would assume that the co-ordinator would not let the commit go through
until it has received
On Mon, 23 Jun 2003, Christopher Kings-Lynne wrote:
No. I want to know what the subordinate does when it's promised to
commit and the co-ordinator never responds. AFAICS the subordinate
is screwed --- it can't commit, and it can't abort, and it can't expect
to make progress indefinitely
On Fri, 20 Jun 2003, Josh Berkus wrote:
Ultimately, this is one of those technical vs. marketing questions
... whether to release now with a bunch of back-end features that the
current users want, or to release later and include the features that we
said were going to be in 7.4. And
On Fri, 20 Jun 2003, Tom Lane wrote:
Time was that we had a major release every 3 or 4 months. As the
project matures I think it's appropriate for the cycle to get slower: a
lot of low-hanging fruit is gone, so we have larger jobs to tackle, plus
users are using PG for larger databases and
On Fri, 20 Jun 2003, Jason Earl wrote:
Heck, there are probably more than 70 machines running
CVS versions of PostgreSQL right this minute (Marc, any download
numbers to back this up?).
Unfortunately, most ppl testing would be using CVS or CVSup, which don't
(or, at least, I haven't been able
On Fri, 20 Jun 2003, Dann Corbit wrote:
Hmm... I must have missed the huge corporation paying for in
house testing of PostgreSQL. In the Free Software world the
beta team is all of those people that need the new features
so badly that they are willing to risk their own data and
On Sat, 21 Jun 2003, Bruce Momjian wrote:
What does bother me is that we weren't getting any closer on those
_hard_ items. At least with this release, we will be _closer_ on Win32
and PITR.
Maybe our problem is such a ... hatred of #ifdef? Maybe its time to go
back a bit to our roots ...
And, actually, for some reason I hadn't thought of the tsearch as being
another 'INDEX' type ... I crawl back over and be quiet now :)
Oleg, as far as commits are concerned, I have no problems with extending
the privileges to one of your guys for this, just email me seperately who,
and I'll get
On Thu, 19 Jun 2003, Robert Treat wrote:
Well, I suppose that history has shown that waiting on specific features
causes trouble with postgresql development, but I don't see why a
release can't be based around waiting for feature x as long as feature x
is being actively worked on by trusted
On Thu, 19 Jun 2003, Andrew Dunstan wrote:
Maybe a better strategy would be to get a release out soon but not wait
6 months for another release which would contain the Win32 port and the
PITR stuff (assuming those aren't done in time for this release).
Just a thought.
And definitely in
On Thu, 19 Jun 2003, Oleg Bartunov wrote:
I'm not sure if contrib/tsearch is a killer feature, but we hope to
submit completely new version of tsearch V2 before July 1. Actually, we
have stable code already used in some projects but currently lacking
documentation. Several people are working
On Fri, 20 Jun 2003, Oleg Bartunov wrote:
Is there a strong reason why tsearch isn't in gborg?
How gborg could help us submitting changes to pgsql CVS ?
It wouldn't ... is there a reason why tsearch needs to be in the pgsql CVS
any more then, say, ODBC drivers, or the tcl interface, or the
On Fri, 20 Jun 2003, Tom Lane wrote:
On Fri, 20 Jun 2003, The Hermit Hacker wrote:
Is there a strong reason why tsearch isn't in gborg?
I think text search is a pretty important facility that should
eventually be part of the core distribution. It's more likely to get
there from contrib
for the web, yes ... the new site doesn't support mirroring, as its highly
database driven ... only thing still mirrorable, really, is the ftp
server ...
On Fri, 13 Jun 2003 [EMAIL PROTECTED] wrote:
Hi every one,
Is it normal that mirro site now all redirect to www.postgresql.org?
It also
On Fri, 13 Jun 2003 [EMAIL PROTECTED] wrote:
Hi vince, Hi Marc
Although I understand why, I think it's a bit f a pity that there's no
mirror of web anymore. For that it means that 1) every thing is now on
your shoulders and that if anything goes wrong you've got no mirror to
rely on.
BUT
shoujld be fixed now
On Wed, 11 Jun 2003, Tom Lane wrote:
... pgsql-committers is not propagating. Bruce evidently applied
a ton of patches last night, and I see no committers messages for
any of 'em.
regards, tom lane
---(end of
'k, someone please test ... should all be setup now and 'auto-updating'
hourly ...
On Tue, 10 Jun 2003, Bruce Momjian wrote:
[EMAIL PROTECTED] wrote:
[ There is text before PGP section. ]
[ PGP not available, raw data follows ]
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
We are
On Tue, 10 Jun 2003, Tom Lane wrote:
Bruce Momjian [EMAIL PROTECTED] writes:
We are 5 days away from the feature freeze date, but with the almost
week of downtime we have had, I don't think we can stick to that date.
Do we choose July 1 as feature freeze and July 15 as beta, or push beta
you have to give it a password ... any password, but a password non the
less ... someone else asked me this also, and if I enter no passwd, I can
get the same error message ...
On Wed, 11 Jun 2003 [EMAIL PROTECTED] wrote:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
'k, someone please
Just a quick note that we just brought neptune back up and are
re-configuring her (getting the OS updated, patch applied for memory leak,
etc)
Teodor, I have your list of modules and am in the process of getting
postgresql 7.3.3 installed ... will get the mailware DB back up and
configured iwth
http://archives.postgresql.org is slowly being re-generated from the base
majordomo archive files, and the search index is ... indexing.
Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
Systems Administrator @ hub.org
primary: [EMAIL PROTECTED]
?? cvs itself has been working for ages now ... anoncvs isn't ... or is
that what you are using?
On Thu, 5 Jun 2003, Dave Cramer wrote:
Is there any ETA for cvs?
Dave
--
Dave Cramer [EMAIL PROTECTED]
fastcrypt
---(end of broadcast)---
cvsweb.cgi is fixed ... working on the rest tonight ...
On Wed, 4 Jun 2003, Joe Conway wrote:
(moving to HACKERS)
Bruno Wolff III wrote:
The CVS server seems to be working again, but logging in with an empty
password doesn't work. The web interface to anonymous CVS doesn't
work either.
On Tue, 27 May 2003, Vince Vielhaber wrote:
On Tue, 27 May 2003, Marc G. Fournier wrote:
*Way* off topic ... but I'm tired of processing through 300 messages
nightly of which 10 are stuff that need to be approved for the lists, and
290 are trash ...
What are ppl using / trusting out
On Tue, 27 May 2003, scott.marlowe wrote:
Another vote for SpamAssassin. We use it at work here and it's quite
nice. It puts all the borderline spam in a holding area and sends you a
daily email with all the topics / names listed and you can request those
out of the spam bucket. It's
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
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
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
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
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,
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
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
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
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
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
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
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 ...
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
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
1 - 100 of 403 matches
Mail list logo