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
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. :-)
>
> Tomorrow aft ... sorry, got tied up with a cli
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 wit
Did we get anywhere with this?
> PostgreSQL typically uses port 5432 for client-server communications.
> It would be a good idea to register this with IANA. This will help to
> avoid a clash with other services that might try to use the port.
> DB2, Interbase, MS SQL, MySQL, Oracle, Sybase, etc
Roberto Mello <[EMAIL PROTECTED]> writes:
> My postmaster is refusing to start. I don't know what's wrong. If
> anyone has pointers/tips/whatever, please tell me.
Perhaps a gdb backtrace from one of the core files would yield clues.
regards, tom lane
-
> I see by the messages that 7.1.1 is in the final packaging. Anyone know
> when it will be released?
Only Marc knows. :-)
--
Bruce Momjian| http://candle.pha.pa.us
[EMAIL PROTECTED] | (610) 853-3000
+ If your life is a hard drive, | 830 Blyt
> I think the XFS and Reiserfs folks will be happy to look at the
performance
> problem, but it would be very helpful for them to have a prepackaged
> benchmark (or two or three) to use. We should set up an FTP area to
share
> them. Joe, can you contribute yours? Does anybody else have anythi
My postmaster is refusing to start. I don't know what's wrong. If
anyone has pointers/tips/whatever, please tell me.
One of my backup scripts was wrong so I don't have current backups
(that's what you get for trusting other people to do your backups). Any
way to recover my databas
"Antonio Jose Acuña Jimenez" <[EMAIL PROTECTED]> writes:
> I need help in the following one for the following error
> "PQGETVALUE: ERROR! tuple number 0 is out of range 0.. -1
> Segment violation"
Pre-7.1 versions of pg_dump are not very robust about situations like
functions whose owner doesn
> ... Think of a query like this:
>
> select a,b,c from table where ( a>min_a and amin_b and b
> In a conventional implementation you have two indexes on attributes a and b.
> But to run this query the database engine profits only from one index. It has
> to run through all the values of the oth
Joe Conway <[EMAIL PROTECTED]> wrote:
>
> I've done some testing to see how Reiserfs performs
> vs ext2, and also various for various values of wal_sync_method while on a
> reiserfs partition. The attached graph shows the results. The y axis is
> transactions per second and the x axis is the trans
I see by the messages that 7.1.1 is in the final packaging. Anyone know
when it will be released?
-Tony
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [
> > There have been multiple reports of poor PostgreSQL performance on
> > Reiser and xfs. I don't have numbers, though. Frankly, I think we need
> > xfs and reiser experts involved to figure out our options here.
>
> I've done some testing to see how Reiserfs performs
> vs ext2, and also vario
[ Charset ISO-8859-1 unsupported, converting... ]
> I got some information from Stephen Tweedie on this - please keep him
> "Cc:" as he's not on this list
>
>
> Bruce Momjian <[EMAIL PROTECTED]> writes:
>
> > I was talking
Michael Samuel wrote:
>
> > Remember, general purpose file systems must do for files what Postgres is
> > already doing for records. You will always have extra work. I am seriously
> > thinking of trying a FAT32 as pg_xlog. I wonder if it will improve performance,
> > or if there is just somethin
> Hi,
>
> On Fri, May 04, 2001 at 01:49:54PM -0400, Bruce Momjian wrote:
> > >
> > > Performance doing what? XFS has known performance problems doing
> > > unlinks and truncates, but not synchronous IO. The user should be
> > > using fdatasync() for databases, btw, not fsync().
> >
> > This i
"Ken Hirsch" <[EMAIL PROTECTED]> writes:
> I don't have a machine with XFS installed and it will be at least a week
> before I could get around to a build. Any volunteers?
I think I could do that... any useful benchmarks to run?
--
Trond Eivind Glomsrød
Red Hat, Inc.
> Yeah, but things do seem to languish there for quite a while. (soundex(),
> for instance, was in contrib when I first looked at PG).
>
> Also, some things are in contrib/ that seem a bit out of date (I think
> there was still some early RI stuff in there last time I went through it)
>
> I unde
Peter Eisentraut wrote:
> What would be worthwhile is setting up another cvs module so packages can
> be developed and released at their own pace.
This is an _excellent_ point, and one I had thought of before but had
forgotten.
FWIW, I have a project set up at greatbridge.org -- I just have to g
Karl DeBisschop wrote:
>
> Trond Eivind Glomsrød wrote:
> >
> > Rachit Siamwalla <[EMAIL PROTECTED]> writes:
> >
> > > Also i never got a response on who actually packages those linux init
> > > scripts that appear in the RPM but not on the pgsql cvs tree. (i am also
> > > curious on why it is di
On Fri, 4 May 2001, Peter Eisentraut wrote:
> Joel Burton writes:
>
> > I think, as little things in contrib/, it's easy for people to miss
> > these. With a project page, some discussion, etc. (& a place in contrib/),
> > more people would be able to use these.
>
> Most of the extension functi
On Tue, 1 May 2001, Rosie Sedghi wrote:
> hello
> Would you tell me how many characters we can have as a string field?
> Thanks a lot.
Questions like this should be sent to pgsql-general or pgsql-novice.
There is no string field. There are CHAR, VARCHAR, TEXT, and a few other
unusual text-type
On Wed, 2 May 2001, Jeff Vainio wrote:
> Hello! I am a Technical Recruiter with MIS Consultants in Toronto Canada and I
>desperately need to find 2 POSTGRES DBA's for our Toronto client on a 3-4 month
>renewable contract, open $$$ based on experience.
>
> How do I go about finding these guys?
Bruce Momjian schrieb:
>
> > Hi guys,
> >
> > I've used the open source SAPDB and the performance is pretty damned
> > impressive. However, 'open source' in application to it is somewhat
> > deceptive, since you have to make it with SAP's proprietary build
> > tools/environment.
> >
> > In my o
Karl DeBisschop writes:
> PostgreSQL builds are great for the portability. The next logical step
> might in fact be to extend some of that consistency to the package
> creation arena.
This would have been cool in 1996. We would have evolved a large number
of different packages along with the bu
Joel Burton writes:
> I think, as little things in contrib/, it's easy for people to miss
> these. With a project page, some discussion, etc. (& a place in contrib/),
> more people would be able to use these.
Most of the extension functions and types in contrib should, in my mind,
eventually be
Hi all,
Not sure if this is useful, but it might be good to file and reference
somewhere.
Regards and best wishes,
Justin Clift
Original Message
Subject: Re: [GENERAL] Unisersal B-Tree
Date: Mon, 30 Apr 2001 17:59:49 +0200
From: Jörg Schulz <[EMAIL PROTECTED]>
Organization: G
Bruce Momjian wrote:
> Here is a general call for people to review other open-source database
> software and report back on things PostgreSQL can learn from them.
i don't know how much there is to learn since it doesn't seem as though
development has been active in a few years, but there's also
hello
Would you tell me how many characters we can have as a string field?
Thanks a lot.
---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
On Sun, 29 Apr 2001, Tatsuo Ishii wrote:
> From: Tatsuo Ishii <[EMAIL PROTECTED]>
> Subject: Re: [PATCHES] Cyrillic to UNICODE conversion
> X-Mailer: Mew version 1.94.2 on Emacs 20.7 / Mule 4.1
> [iso-2022-jp] (^[$B0*^[(B)
>
> Thanks for the fixes. I have committed your patches and they should
>
G'day mate,
Sure, it's fine to mail me...Actually I haven't found the time to get
involved in the JDBC driver (it now does what I need it to do, and I'm
behind schedule with a project of mine ;-) so your involvement is very
welcome!
Probably the best thing is to access the CVS but on the postgr
hi...
i'm configuring a web based e-commerce site called pg_market that uses PHP
and postgresql and i keep coming up with this error:
Warning: PostgreSQL query failed: ERROR: Relation 'order_cntry' does not exist
in /home/users/h/haresh/public_html/pgmarket-1.2.0/lib/dblib.inc.php on line 84
Ca
Hello to all
I need help in the following one for the following error
"PQGETVALUE: ERROR! tuple number 0 is out of range 0.. -1
Segment violation"
This happens when I make a pg_dump namebd > namebd.dump
I work posgresql 7.0.3 with mandrake 7.2
A thousand thank you
Antonio Acuña
Lamar Owen wrote:
>
> Tom Lane wrote:
> > Seems like that stuff should be in CVS somewhere ... if only so someone
> > else can pick up the ball if you get run over by a truck :-(.
>
> My wife appreciates the sentiment :-). As it stands now, better
> documentation distributed in the source RPM w
mlw wrote:
[EMAIL PROTECTED]">Bruce Momjian wrote:
Just put a note in the installation docs that the place where the databaseis initialised to should be on a non-Reiser, non-XFS mount...Sure, we can do that now. What do we do when these are the default filesystems for Linux? We can tell them to
Bruce Momjian <[EMAIL PROTECTED]> writes:
>> Perhaps src/rpm-tools/ or some such name.
> It is platform-specific, which would seem to vote for /contrib.
Huh? By that logic, all of src/makefiles/, src/template/, and
src/backend/port/, not to mention large chunks of the configure
mechanism, belon
Trond Eivind Glomsrød wrote:
>
> Rachit Siamwalla <[EMAIL PROTECTED]> writes:
>
> > Also i never got a response on who actually packages those linux init
> > scripts that appear in the RPM but not on the pgsql cvs tree. (i am also
> > curious on why it is different, and how the RPM is built).
>
Hello! I am a Technical Recruiter with MIS Consultants in Toronto Canada and I
desperately need to find 2 POSTGRES DBA's for our Toronto client on a 3-4 month
renewable contract, open $$$ based on experience.
How do I go about finding these guys?
Any help is much appreciated, thanks!
Jeff Va
> Lamar Owen <[EMAIL PROTECTED]> writes:
> > contrib/rpm-dist?
>
> Contrib was my first thought also --- but on second thought, the RPM
> packaging support is hardly contrib-grade material. For a large
> proportion of our users it's a critical part of the distribution.
> So, if we are going to h
> On Fri, May 04, 2001 at 08:02:17AM -0400, mlw wrote:
> > The way I understand it is that ReiserFS does not attempt to separate files at
> > the block level. Multiple files can live in the same disk block. This is cool
> > if you have many small files, but the extra overhead for large files such
[ Charset ISO-8859-1 unsupported, converting... ]
> > Sure, we can do that now. What do we do when these are the default file
> > systems for Linux? We can tell them to create other types of file
>
> What is a 'default file system' ? I know that untill now, everybody is using
> ext2. But that'
[ Charset ISO-8859-1 unsupported, converting... ]
> Before we get too involved in speculating, shouldn't we actually measure the
> performance of 7.1 on XFS and Reiserfs? Since it's easy to disable fsync,
> we can test whether that's the problem. I don't think that logging file
> systems must in
> Sure, we can do that now. What do we do when these are the default file
> systems for Linux? We can tell them to create other types of file
What is a 'default file system' ? I know that untill now, everybody is using
ext2. But that's only because there hasn't been anything comparable. Now we
Lamar Owen writes:
> contrib/rpm-dist?
A separate CVS module sounds like a better idea to me.
--
Peter Eisentraut [EMAIL PROTECTED] http://funkturm.homeip.net/~peter
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please
Tom Lane wrote:
> Contrib was my first thought also --- but on second thought, the RPM
> packaging support is hardly contrib-grade material. For a large
> proportion of our users it's a critical part of the distribution.
> So, if we are going to have it in the CVS tree at all, I'd vote for
> putt
Lamar Owen <[EMAIL PROTECTED]> writes:
> contrib/rpm-dist?
Contrib was my first thought also --- but on second thought, the RPM
packaging support is hardly contrib-grade material. For a large
proportion of our users it's a critical part of the distribution.
So, if we are going to have it in the
I got some information from Stephen Tweedie on this - please keep him
"Cc:" as he's not on this list
Bruce Momjian <[EMAIL PROTECTED]> writes:
> I was talking to a Linux user yesterday, and he said that performance
> using
Lamar Owen <[EMAIL PROTECTED]> writes:
> As to why all these files aren't part of the source tree, well, unless
> there was a large cry for it to happen, I don't believe it should.
> PostgreSQL is very platform-agnostic -- and I like that. Including the
> RPM stuff as part of the Official Tarbal
On Thu, 3 May 2001, Rachit Siamwalla wrote:
> 1. `pidof` should be `pidof -s` (2 instances)
> 2. restart) should be stop; sleep x; start
> ideally, stop should actually wait till postgres fully stops. The sleep is
> just a temporary fix.
>
Perhaps a naive question, but why not use the pg_ctl for
Tom Lane wrote:
> Seems like that stuff should be in CVS somewhere ... if only so someone
> else can pick up the ball if you get run over by a truck :-(.
My wife appreciates the sentiment :-). As it stands now, better
documentation distributed in the source RPM would help greatly.
Everything ne
> "Bruce" == Bruce Momjian <[EMAIL PROTECTED]> writes:
>> Well, arguably if you're setting up a database server then a
>> reasonable DBA should think about such things...
Bruce> Yes, but people have trouble installing PostgreSQL. I
Bruce> can't imagine walking them through a
"V. M." wrote:
>
> Where i can find a wonderful installer for postgres 7.1 on our windows2000
> advanced servers ?
>
www.cygwin.com
--
"Tout penseur avare de ses pensees est un penseur de Radin." --
Pierre Dac
---(end of broadcast)---
TIP
On Fri, May 04, 2001 at 08:02:17AM -0400, mlw wrote:
> The way I understand it is that ReiserFS does not attempt to separate files at
> the block level. Multiple files can live in the same disk block. This is cool
> if you have many small files, but the extra overhead for large files such as
> tho
Where i can find a wonderful installer for postgres 7.1 on our windows2000
advanced servers ?
We use postgres on linux systems, But...
I'm not able to find on the net a binary for Postgres 7.1.
I don't want to compile, i want a simple installer. windows machines are 200
Million, if you'll make
mlw <[EMAIL PROTECTED]> writes:
> I have looked at Reiser, and I don't think it is a file system suited for very
> large files, or applications such as postgres.
What's the problem with big files? ReiserFS v2 doesn't seem to support
it, while v3 seems just fine (of the ondisk format)
That said,
Before we get too involved in speculating, shouldn't we actually measure the
performance of 7.1 on XFS and Reiserfs? Since it's easy to disable fsync,
we can test whether that's the problem. I don't think that logging file
systems must intrinsically give bad performance on fsync since they only
Thus spake Ryan Mahoney
> !! I haven't ran VACUUM ANALYZE since last night. Just ran it -
> performance has improved significantly. I think I am going to have to run
> it hourly during this high traffic time. Postmasters are still utilizing
> about 100% of the CPU. Is this normal? I am con
Michael Samuel wrote:
>
> ReiserFS only supports metadata logging. The performance slowdown must be
> due to logging things like mtime or atime, because otherwise ReiserFS is a
> very high performance FS. (Although, I admittedly haven't used it since it
> was early in it's development)
The way
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
> > Cann
On Thu, May 03, 2001 at 11:41:24AM -0400, Bruce Momjian wrote:
> ext2 has serious problems with corrupt file systems after a crash, so I
> understand the need to move to another file system type. I have been
> waitin for Linux to get a more modern file system. Unfortunately, the
> new ones seem t
Here is a radical idea...
What is it that is causing Postgres trouble? It is the file system's attempts
to maintain some integrity. So I proposed a simple "dbfs" sort of thing which
was the most basic sort of file system possible.
I'm not sure, but I think we can test this hypothesis on the FAT3
61 matches
Mail list logo