On 10/14/03 8:26 PM, "Greg Stark" <[EMAIL PROTECTED]> wrote:
>
> All the more reason Postgres's view of the world should maybe be represented
> there. As it turns out Linus seems unsympathetic to the O_DIRECT approach and
> seems more interested in building a better kernel interface to control cac
Tom Lane writes:
> It'd be better if we could get it right the first time, with the
> understanding that the output format is not very negotiable at this
> late hour. But as best I can tell, most of the unhappiness is with the
> design of the switch set, which is not something I want to defend in
Bruce Momjian writes:
> The problem is how that affects Red Hat. What do they do with their
> tool?
They could use the prototype version of this feature that implemented a
separate program (pg_guc) that provided this information. That way they
can generate any output they want for as long as th
Manuel Sugawara <[EMAIL PROTECTED]> writes:
> I did the es translation of pg_dump and while looking at the code I
> found that in several places the char * representation of Oid's is
> used instead of the oid itself. Any one knows why is done this
> way?
AFAIR pg_dump invariably stores OIDs as str
Bruce Momjian <[EMAIL PROTECTED]> writes:
> ... Will Red Hat be upset if we
> leave it unchanged for 7.4.X and rip this out and redo it in 7.5?
It'd be better if we could get it right the first time, with the
understanding that the output format is not very negotiable at this
late hour. But as be
James Rogers <[EMAIL PROTECTED]> writes:
> >
> > Someone from Oracle is on there explaining what Oracle's needs are. Perhaps
> > someone more knowledgable than myself could explain what would most help
> > postgres in this area.
>
>
> There is an important difference between Oracle and Postgres
There is no backward link from a heap tuple to it's index entries. So if
you have 3 indexes on a table and do an update, you need at least 2 more
index lookups just to set that bit, if you somehow manage to remember by
what index you found this heap tuple in the first place.
On update-heavy tab
Tom Lane wrote:
> Bruce Momjian <[EMAIL PROTECTED]> writes:
> > Peter Eisentraut wrote:
> >> I'm beginning to think that we should scrap it and start with a real
> >> design for 7.5. I know that's radical, but I don't think we're going to
> >> arrive at anything that anyone's going to like by the
I did the es translation of pg_dump and while looking at the code I
found that in several places the char * representation of Oid's is
used instead of the oid itself. Any one knows why is done this
way?
Regards,
Manuel.
---(end of broadcast)---
TIP
Bruce Momjian <[EMAIL PROTECTED]> writes:
> Peter Eisentraut wrote:
>> I'm beginning to think that we should scrap it and start with a real
>> design for 7.5. I know that's radical, but I don't think we're going to
>> arrive at anything that anyone's going to like by the time we want to
>> release
Peter Eisentraut wrote:
> Bruce Momjian writes:
>
> > Let me be clear on this --- your tools is not part of the PostgreSQL
> > community. We are not required to allow any of this functionality
> > unless the community decides they want it. The major argument for
> > keeping it, in my mind, is to
Bruce Momjian writes:
> Let me be clear on this --- your tools is not part of the PostgreSQL
> community. We are not required to allow any of this functionality
> unless the community decides they want it. The major argument for
> keeping it, in my mind, is to be helpful to Red Hat.
>
> My curre
On Tue, 14 Oct 2003, Rod Taylor wrote:
> > > I wouldn't want the whole diff on the mail, but a link to the relevant
> > > diffs in cvsweb would be most useful (one for each changed file -- not ideal,
> > > but much better than nothing). You're not the first one to suggest it ...
> >
> > I agree,
Marko Karppinen writes:
> I'm not aware of any Darwin-specific "workarounds" in the tree
> right now; the only thing close to that is the support for Apple's
> two-level namespaces feature. And while you can argue the relative
> merits of Apple's approach, the reason for its existence isn't
> slop
> > I wouldn't want the whole diff on the mail, but a link to the relevant
> > diffs in cvsweb would be most useful (one for each changed file -- not ideal,
> > but much better than nothing). You're not the first one to suggest it ...
>
> I agree, it would be very useful. Marc, would it be possib
On Tue, 2003-10-14 at 15:57, Alvaro Herrera Munoz wrote:
> On Tue, Oct 14, 2003 at 07:52:55PM +, Jon Jensen wrote:
> > Other projects I've worked on have such a list, and each commit message is
> > followed by a complete diff (usually with -u for readability) so even
> > non-committers can do a
wscott.marlowe wrote:
> > If you use "intr" then this type of thing can happen. Lots of programs assume
> > the unix semantics for disk accesses. You can get all kinds of bugs when
> > they're violated.
> >
> > If you use "soft" then the consequences can be much much worse. If your
> > fileserver
On Sun, 2003-10-12 at 15:13, Greg Stark wrote:
> There's an interesting thread on linux-kernel right now about O_DIRECT and the
> kernel i/o APIs databases need. I noticed a connection between what they were
> discussing and the earlier discussions here and the pining for an interface to
> avoid ha
> -Original Message-
> From: Jon Jensen [mailto:[EMAIL PROTECTED]
> Sent: 14 October 2003 20:53
> To: [EMAIL PROTECTED]
> Subject: Re: [HACKERS] postgres --help-config
>
> Is there a mailing list somewhere that all the CVS commits
> get sent to?
> Other projects I've worked on have
On Tue, Oct 14, 2003 at 07:52:55PM +, Jon Jensen wrote:
> Is there a mailing list somewhere that all the CVS commits get sent to?
Yes, pgsql-committers.
> Other projects I've worked on have such a list, and each commit message is
> followed by a complete diff (usually with -u for readabili
On Tue, 14 Oct 2003, Bruce Momjian wrote:
> I knew you were adding --help-config, but I didn't realize the extent of
> the "features". The commit message is:
>
> revision 1.1
> date: 2003/07/04 16:41:21; author: tgl; state: Exp;
> Add --help-config facility to dump informatio
On 14 Oct 2003, Greg Stark wrote:
>
> Michael Brusser <[EMAIL PROTECTED]> writes:
>
> > > Michael Brusser <[EMAIL PROTECTED]> writes:
> > > > 2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks:
> > > > Interrupted system call
> > >
> > > Hmm. I found this hard to believe at f
Larry Rosenman wrote:
-- Start of PGP signed section.
>
>
> --On Tuesday, October 14, 2003 15:31:42 -0400 Bruce Momjian
> <[EMAIL PROTECTED]> wrote:
>
> > Tom Lane wrote:
> >> Michael Brusser <[EMAIL PROTECTED]> writes:
> >> > Yes, we use NFS. Many of our customers use it as well.
> >>
> >> You
--On Tuesday, October 14, 2003 15:31:42 -0400 Bruce Momjian
<[EMAIL PROTECTED]> wrote:
Tom Lane wrote:
Michael Brusser <[EMAIL PROTECTED]> writes:
> Yes, we use NFS. Many of our customers use it as well.
You are of course aware that this is not real safe...
Maybe we should throw a "stop using N
Tom Lane wrote:
> Michael Brusser <[EMAIL PROTECTED]> writes:
> > Yes, we use NFS. Many of our customers use it as well.
>
> You are of course aware that this is not real safe...
Maybe we should throw a "stop using NFS" if we get an EINTR from
read()/write(), or explain what NFS options they shou
Fernando Nasser wrote:
> Bruce,
>
> Before I comment on your suggestions, I would like to mention that many of the
> things below were added on request by the few people who cared to comment on it.
> Aizaz spent most of his time changing here and there to accommodate these
> requests. Anyway
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> On Tue, Oct 14, 2003 at 11:34:14AM -0400, Fernando Nasser wrote:
>> And we developed a very nice tool that depends on this feature
>> confident that we could count on it.
> Is this tool going to be released somehow?
Certainly. Keep an eye on http://so
On Tue, Oct 14, 2003 at 11:34:14AM -0400, Fernando Nasser wrote:
Unrelated question,
> And we developed a very nice tool that depends on this feature
> confident that we could count on it.
Is this tool going to be released somehow?
--
Alvaro Herrera ()
"I dream about dreams about dreams", sang
Alvaro Herrera wrote:
So, how did you know the database already existed? The objects you are
seeing may be well part of template1 ...
You are right, I'm an idiot...sorry :)
Merlin
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ
On Tue, Oct 14, 2003 at 01:58:24PM -0400, Merlin Moncure wrote:
> Here is a verbatim readout of my typing commands into the database
> shell. I issued a 'create database' to pg 7.4b2 and it did not fail
> despite an already existing database with the same name. Just thought
> I'd pass it along, I
Michael Brusser <[EMAIL PROTECTED]> writes:
> > Michael Brusser <[EMAIL PROTECTED]> writes:
> > > 2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks:
> > > Interrupted system call
> >
> > Hmm. I found this hard to believe at first, but indeed my local man
> > pages for read()
James Wilson <[EMAIL PROTECTED]> writes:
> make -C ecpglib all
> gcc -no-cpp-precomp -g -O2 -Wall -Wmissing-prototypes
> -Wmissing-declarations -bundle execute.o typename.o descriptor.o
> data.o error.o prepare.o memory.o connect.o misc.o
> -L../../../../src/port -L/opt/local/lib -L../pgtypesli
On 14.10.2003, at 19:52, Tom Lane wrote:
This means that relaxing the check would require (a) finding out which
of the sub-flags break our code and which don't; (b) finding out how
the
answer to (a) has varied with gcc release; and (c) finding out how we
can test whether a given sub-flag is set --
Here is a verbatim readout of my typing commands into the database
shell. I issued a 'create database' to pg 7.4b2 and it did not fail
despite an already existing database with the same name. Just thought
I'd pass it along, I haven't been able to reproduce it. Just thought
I'd pass it along...
Hi,
probably it's just a stupid idea, but what do you think of this:currently,
most if not all queries with aggregates (count(), sum()) make seq scans
when there are no conditions at all. especially count() is a classic question
on any postgres list.
the reason is - at least that's what I
Hans-Jürgen Schönig wrote:
> Bruce Momjian wrote:
> > Martin Rusoff wrote:
> >
> >>I was just contemplating how to make postgres parallel (for DSS
> >>applications)... Has anyone done work on this? It looks to me like there
> >>are a couple of obvious places to add parallel operation:
> >>
> >>S
Srikanth,
HACKERS and DOCS are not the appropriate mailing lists for your request. If
you need follow-up help, please join NOVICE or GENERAL.
>I am an Oracle DBA having 4 +years of experience and want to
> migrate to postgreSQL .
> Please kindly Assist me for Documents to convert Oracle
Michael Brusser <[EMAIL PROTECTED]> writes:
> Yes, we use NFS. Many of our customers use it as well.
You are of course aware that this is not real safe...
regards, tom lane
---(end of broadcast)---
TIP 1: subscribe and unsub
Marko Karppinen <[EMAIL PROTECTED]> writes:
> At least the --fast-math part causes problems, seeing that PostgreSQL
> actually checks for the __FAST_MATH__ macro to make sure that it isn't
> turned on. There might be other problems with Apple's flags, but I
> think that the __FAST_MATH__ check s
While I definitely agree that the mathematics of the data persistence
mechanism is not as important to me as whether it works or not, as a
former mathematician, I have done a little study related to the
mathematics of non-relational approaches, such as PICK (the one both
Wol and I have been know to
"Dawn M. Wolthuis" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Thank you, Seun, for asking your question with a bit of logic and not
> gut-reaction emotional baggage (and for also asking a question of me
> off-list so I could ramble). I'll try to make this more suscinct.
With al
Bob Badour" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> "Dawn M. Wolthuis" <[EMAIL PROTECTED]> wrote in message
> news:[EMAIL PROTECTED]
> > Thank you, Seun, for asking your question with a bit of logic and not
> > gut-reaction emotional baggage (and for also asking a questio
Why would you spent time on implementing a mechanism whose ultimate
benefit is supposed to be increasing reliability and performance, when you
already realize that it will have to lock up at the slightest sight of
trouble? There are better mechanisms out there that you can use instead.
If you wa
Thank you, Seun, for asking your question with a bit of logic and not
gut-reaction emotional baggage (and for also asking a question of me
off-list so I could ramble). I'll try to make this more suscinct.
First of all, I have read Codd's 1970 & 1974 ACM papers, as well as
his "The Relational Mode
There's an interesting thread on linux-kernel right now about O_DIRECT and the
kernel i/o APIs databases need. I noticed a connection between what they were
discussing and the earlier discussions here and the pining for an interface to
avoid having vacuum preempt other disk i/o.
Someone from Ora
Hi Marko,
I've done a checkout from CVS and performed a build under OS X Panther
7B85 with the non-hacked header files. The problem with the param.h
header file seems to be fixed, however the build is failing with
undefined symbols in libs:
make -C ecpglib all
gcc -no-cpp-precomp -g -O2 -Wall
[EMAIL PROTECTED] (Dawn M. Wolthuis) wrote in message news:<[EMAIL PROTECTED]>...
> Bob Badour" <[EMAIL PROTECTED]> wrote in message news:<[EMAIL PROTECTED]>...
> > "Dawn M. Wolthuis" <[EMAIL PROTECTED]> wrote in message
> > news:[EMAIL PROTECTED]
> > > Thank you, Seun, for asking your question wit
"Mike Preece" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> [EMAIL PROTECTED] (Dawn M. Wolthuis) wrote in message
news:<[EMAIL PROTECTED]>...
> > Bob Badour" <[EMAIL PROTECTED]> wrote in message
news:<[EMAIL PROTECTED]>...
> > > "Dawn M. Wolthuis" <[EMAIL PROTECTED]> wrote in messag
On Thu, 9 Oct 2003, Bruce Momjian wrote:
> Agreed. Let's get it into 7.5 and see it in action. If we need to
> adjust it, we can, but right now, we need something for distributed
> transactions, and this seems like the logical direction.
I've started working on two-phase commits last week, and
I'm tired of this kind of "2PC is too slow" arguments. I think
Satoshi, the only guy who made a trial implementation of 2PC for
PostgreSQL, has already showed that 2PC is not that slow.
Where does Satoshi's implementation sit right now? Will it patch to v7.4?
Can it provide us with a base to wor
Nicola,
No, the driver does not use libpq it uses it's own socket code.
Dave
On Thu, 2003-10-09 at 07:30, Nicola Pero wrote:
> Hi,
>
> I have to work on some software which is using JDBC and libpq (via JNI) in
> the same process to connect to the same Postgres database. The software
> is heavil
[EMAIL PROTECTED] (Dawn M. Wolthuis) wrote in message news:<[EMAIL PROTECTED]>...
> I would suggest ditching the entire relational model (as both overly
> simplistic in its theory and overly complex in its implementation) and
> start with English (that is one of the other names for the GIRLS
> lang
Good question. Although I would want to move away from relational
databases too, if there is an RDBMS and one wants to query it, what
would I aim for? If you look at XQuery, you will see an example of
what I would definitely NOT aim for. Although the user of such a
language might very well be a
With all due respect, Dawn, you are an idiot.
"Dawn M. Wolthuis" <[EMAIL PROTECTED]> wrote in message
news:[EMAIL PROTECTED]
> Good question. Although I would want to move away from relational
> databases too, if there is an RDBMS and one wants to query it, what
> would I aim for? If you look at
[EMAIL PROTECTED] (Seun Osewa) wrote in message news:<[EMAIL PROTECTED]>...
> I have tried, twice, to download the evaluation version of the alphora
> product for testing and it doesn't work. Guess there would be a lot
> to learn from playing with it; the product is more than a RDBMS
Aw, that's u
Hi,
I have to work on some software which is using JDBC and libpq (via JNI) in
the same process to connect to the same Postgres database. The software
is heavily multithreaded.
When running under heavy loads and accessing the database under JDBC and
libpq at the same time, we get obscure JVM cra
>> The mathematics of language is more complex than the mathematics of
relations, particularly simple relations (such as 1NF tables). <<
Are you sure, you know what you are talking about?
>> I would suggest ditching the entire relational model (as both overly
simplistic in its theory and overly c
At 10:45 AM -0400 10/9/03, Bruce Momjian wrote:
Neil Conway wrote:
On Thu, 2003-10-09 at 09:35, Bruce Momjian wrote:
> I only put back what was already there --- not sure why others don't use
> it. You want it enabled on Linux?
Well, why do we have it enabled at all? If it's to speed compilati
Bruce Momjian wrote:
Martin Rusoff wrote:
I was just contemplating how to make postgres parallel (for DSS
applications)... Has anyone done work on this? It looks to me like there
are a couple of obvious places to add parallel operation:
Stage 1) I/O , perhaps through MPIO - would improve tables
This would be a good idea I think. DB2 has a page-cleaner background process that
periodically writes out dirty pages to disk. Reduces checkpoint I/O.
I don't see much point in serializing all bufferpool I/O through a separate dedicated
backend. Informix uses something like this.
--
Pip-pip
Sa
[EMAIL PROTECTED] ("Dann Corbit") wrote in message news:<[EMAIL PROTECTED]>...
> > -Original Message-
> > From: Seun Osewa [mailto:[EMAIL PROTECTED]
> > Sent: Friday, October 03, 2003 11:52 AM
> > To: [EMAIL PROTECTED]
> > Subject: [HACKERS] Dreaming About Redesigning SQL
> >
> >
> > Hi,
Hi,
I am an
Oracle DBA having 4 +years of experience and want to migrate to postgreSQL .
Please kindly Assist me for Documents to convert Oracle
Application to PostgreSQL .
And also send me the links to open source code
for postgreSQL.
Thanks& Regards,
Srikanth Pentako
Yes, we use NFS. Many of our customers use it as well.
Mike.
> -Original Message-
> From: Tom Lane [mailto:[EMAIL PROTECTED]
... ...
> Michael Brusser <[EMAIL PROTECTED]> writes:
> > 2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks:
> > Interrupted system call
>
> Hm
I wonder if this is feasible to enhance create trigger
so I could say 'create or replace'
Thanks,
Mike.
---(end of broadcast)---
TIP 5: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faqs/FAQ.html
Michael Brusser <[EMAIL PROTECTED]> writes:
> 2003-10-10 22:37:05 ERROR: cannot read block 0 of s_noteimportlinks:
> Interrupted system call
Hmm. I found this hard to believe at first, but indeed my local man
pages for read() and write() say they can return EINTR if interrupted
by a signal. Thi
Bruce,
Before I comment on your suggestions, I would like to mention that many of the
things below were added on request by the few people who cared to comment on it.
Aizaz spent most of his time changing here and there to accommodate these
requests. Anyway, we know we can't satisfy all, but
Christopher Kings-Lynne writes:
> Also, with the pg_largeobject table, there seems to be no 'owner'
> concept on lobs at all. So is there no problem with any random gumby
> commenting on anyone else's large object?
Not any worse that any random gumby reading or writing anyone else's large
object
Bruce Momjian writes:
> What to do about exposing the list of possible SQLSTATE error codes
I say we put the list in the documentatio and that's it. Exposing the
list in C header files wouldn't really be an ultimate solution, because
not everyone uses C.
> Freeze message strings
That is old ne
Marko Karppinen writes:
> GCC sets __FAST_MATH__ even if you counter a -ffast-math with the
> negating flags above. This means that it is not currently possible to
> use the -fast flag when compiling PostgreSQL at all. Instead, you have
> to go through all the flags Apple is setting and only pass
Neil Conway <[EMAIL PROTECTED]> writes:
> On Mon, 2003-10-06 at 16:21, Joshua D. Drake wrote:
>> postgres=# create user with encrypted password '98wq7912a';
>> CREATE USER
>> postgres=# create user with encrypted password '98wq7912a';
>> ERROR: CREATE USER: user name "with" already exists
> So, w
On Mon, Oct 13, 2003 at 11:51:52PM -0400, Jan Wieck wrote:
> You can build more secure systems as long as you want, evolution will
> develop the better idiot. As long as you create safer cars with more
Sure, but I think all Rod is asking for is something like the ability
to add the -w switch to
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes:
> Also, with the pg_largeobject table, there seems to be no 'owner'
> concept on lobs at all. So is there no problem with any random gumby
> commenting on anyone else's large object?
We don't have a lot of choice. I suppose ideally LOs should
> >> Some dumb-user/fat-finger/ooops protection is surely welcome, but there
> >> is a limit. A system console has to be behind a locked door instead of
> >> the single-user boot being root-password protected. As soon as people
> >
> > Unfortunately, as more and more companies start to outsourc
Jan Wieck wrote:
> 2PC is not too slow in normal operations when everything is purring
> like little kittens and you're just wasting your excess bandwidth on
> it. The point is that it behaves horrible and like a dirty backstreet
> cat at the time when things go wrong ... basically it's a neat thin
74 matches
Mail list logo
