> I was considering adding this and the stuff Andreas requested to
> pg_settings (but not "SHOW ALL" or "SHOW x" unless people feel it's
> important to kept them consistent with pg_settings). Were the Red Hat
> guys going to do this?
pg_settings would be fine for phpPgAdmin.
Chris
--
> Well, correct solution is to implement tablespaces on which objects like
> databases, tables and indexes can be put.
I have started working on tablespaces (to the extent that I am capable!),
based not on the rejected patch, but on Jim's eventual syntax proposal that
was never developed.
eg.
CR
Christopher Kings-Lynne wrote:
See my followup. Which bits of info would you like to see added that
SHOW doesn't reveal?
Unlike andreas, I'm not interested in the types and ranges of values, what I
need to know is the GUC variables that the user is allowed to set, in
particular what they can ALTER
On 24 Jun 2003 at 14:48, Jonathan Bartlett wrote:
> I know the current method for specifying alternate drives for PG tables is
> by using symlinks. I had some ideas for simple ways to do this in PG
> code, but wanted to know if anyone was working on this right now. I'd
> hate to take the time to
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
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 is also the
> > one who must fix the issue raised
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
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 indeed.
Its worked for us ...
Sorry Marc, but that ain't entirely
Added to TODO:
* Allow creation of a libpq-only tarball
---
The Hermit Hacker wrote:
>
> Just a side bar to the whole thread about PHP/MySQL ... I realize that
> libpq is intwined with the backend right now, but if
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
Joe Conway wrote:
> Since we're getting close to a freeze, I thought I'd point out these
> warnings again:
>
> make[4]: Entering directory `/opt/src/pgsql/src/interfaces/ecpg/pgtypeslib'
> [...]
> i386-redhat-linux-gcc -O2 -g -Wall -Wmissing-prototypes
> -Wmissing-declarations -fpic -I../../../.
Since we're getting close to a freeze, I thought I'd point out these
warnings again:
make[4]: Entering directory `/opt/src/pgsql/src/interfaces/ecpg/pgtypeslib'
[...]
i386-redhat-linux-gcc -O2 -g -Wall -Wmissing-prototypes
-Wmissing-declarations -fpic -I../../../../src/interfaces/ecpg/include
-
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
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 str
I think it was a useful discussion. I find it interesting to compare
our clearly ad-hock testing methods to traditional commercial testing
strategies. I think our results are very good, but it does look awful
"ad-hock" and it is easy to see how someone would question its
effectiveness.
Of cours
> -Original Message-
> From: The Hermit Hacker [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 24, 2003 6:10 PM
> To: Dann Corbit
> Cc: The Hermit Hacker; Jan Wieck; scott.marlowe; Bruce
> Momjian; Tom Lane; Jason Earl; PostgreSQL-development
> Subject: RE: [HACKERS] Two weeks to feature
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 indeed.
>
> Its worked for us ...
>
> Wait,
Patch applied. Thanks.
---
Kurt Roeckx wrote:
> On Fri, Jun 20, 2003 at 07:48:02PM -0700, Joe Conway wrote:
> > This change (I'm sure this will wrap poorly -- sorry):
> > http://developer.postgresql.org/cvsweb.cgi/pgsql-se
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 own risk (and I
> recommend aga
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
> -Original Message-
> From: The Hermit Hacker [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, June 24, 2003 5:26 PM
> To: Dann Corbit
> Cc: Jan Wieck; scott.marlowe; Bruce Momjian; Tom Lane; Jason
> Earl; PostgreSQL-development
> Subject: Re: [HACKERS] Two weeks to feature freeze
>
>
> On M
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
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 n
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 we
'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:
>
> http://portal.acm.org/citation.cfm?id=5813
Bruce Momjian wrote:
I don't think an option to do such justification would be good unless we
can do it consistenly in the code, and there is enough demand.
It's no big additional effort to do this, and going back and forth is
not a big problem. I wouldn't invent an option for that, just do it.
--On Tuesday, June 24, 2003 14:07:23 -0700 Joe Conway <[EMAIL PROTECTED]>
wrote:
(moving to HACKERS)
Mike Mascari wrote:
Joe Conway wrote:
I think this shows how to do what you want:
http://archives.postgresql.org/pgsql-sql/2003-05/msg00301.php
Maybe debug_query_string should be mapped into a
Robert Treat wrote:
> the whole discussion is based on how do we get big projects done when no
> one is motivated to work on 'foo' until there faced with a deadline;
> this idea puts the pressure on 'foo' developers from the get go. i'm not
> saying this a guaranteed way to solve that problem but
--On Tuesday, June 24, 2003 14:43:24 -0400 Bruce Momjian
<[EMAIL PROTECTED]> wrote:
TODO updated:
* Have SELECT '13 minutes'::interval display zero seconds in ISO
datestyle
I just posted a patch to -patches for this. (it's a quickie, even).
--
Larry Rosenman
(moving to HACKERS)
Mike Mascari wrote:
Joe Conway wrote:
I think this shows how to do what you want:
http://archives.postgresql.org/pgsql-sql/2003-05/msg00301.php
Maybe debug_query_string should be mapped into a variable like
CURRENT_USER? Perhaps something like CURRENT_QUERY?
I was thinking some
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; for sure. productive for large scale
> > f
Bruce,
On Tue, Jun 24, 2003 at 03:04:05PM -0400, Bruce Momjian wrote:
> Kurt Roeckx wrote:
> > All that probably needed to change for cygwin was to no longer
> > use sa_family_t in the getaddrinfo.c.
>
> But Jason reported he needed that typedef for sa_family_t. Jason, is
> that accurate.
Yes.
> SELECT foo
> FROM bar b
> LEFT JOIN chair c USING (thekeycol)
> WHERE ...
> :-)
Sub-selects are much nicer:
SELECT foo
, bar
, (SELECT anotherfoo
FROM tab2
WHERE tab2.col = tab1.col)
FROM tab
JOIN yet_another_table AS yat
ON
Kurt Roeckx wrote:
> On Mon, Jun 23, 2003 at 07:49:11PM -0400, Bruce Momjian wrote:
> >
> > I have applied a patch to CVS to fix the problem. It is all your patch,
> > except for the part you got from me, which was wrong. :-(
> >
> > It took me a while to realize the subtlety of your patch. Fi
I don't think an option to do such justification would be good unless we
can do it consistenly in the code, and there is enough demand.
---
Andreas Pflug wrote:
> Rod Taylor wrote:
>
> >>Oh, one more thing --- right justify
Rod Taylor wrote:
Oh, one more thing --- right justify isn't as accepted as left-justify
But it looks so much better...
Ye!
Consider this:
SELECT foo
FROM bar b
LEFT JOIN chair c USING (thekeycol)
WHERE ...
:-)
versus
SELECT foo
FROM bar b
LEFT JOIN chair c USING (thekeycol)
WHE
TODO updated:
* Have SELECT '13 minutes'::interval display zero seconds in ISO
datestyle
---
Larry Rosenman wrote:
>
>
> --On Tuesday, June 24, 2003 10:44:25 -0400 Bruce Momjian
> <[EMAIL PROTECTED]> w
Yes it is TO_CHAR,
look like that OS ( SUN ) related issue, I assume PG uses some of the
lib functions.
Looks like nonsense for me, what is damn difficult in that ( formating
dates ).
going to try date_part, might help me.
Too bad EXPLAIN does not provide statistic of time that spent inside a
fun
On Mon, Jun 23, 2003 at 07:49:11PM -0400, Bruce Momjian wrote:
>
> I have applied a patch to CVS to fix the problem. It is all your patch,
> except for the part you got from me, which was wrong. :-(
>
> It took me a while to realize the subtlety of your patch. First, it
> removes the use of sa
On Wed, 25 Jun 2003 00:43:56 +0900
Yutaka tanida <[EMAIL PROTECTED]> wrote:
> > BTW, when you were running your test case, what shared_buffers did you
> > use?
>
> I use 16,64,256 and 4096.
I missed. My shown result(+4% cache hit rate) is shared_buffers=64.
--
On Tue, 24 Jun 2003 10:27:09 -0400
Tom Lane <[EMAIL PROTECTED]> wrote:
> I tried to implement LRU-2 awhile ago, and got discouraged when I
> couldn't see any performance improvement. But I was using pgbench as
> the test case, and failed to think about its lack of seqscans.
How about cache hit
Tom Lane wrote:
Weiping He <[EMAIL PROTECTED]> writes:
we found the problem:
We used IMMUTABLE modifier in our CREATE FUNCTION definition,
though it's correct for our function to return same value if input the
same *data*,
but our data are passed by reference, not by value, so, some times we c
> Oh, one more thing --- right justify isn't as accepted as left-justify
But it looks so much better...
--
Rod Taylor <[EMAIL PROTECTED]>
PGP Key: http://www.rbt.ca/rbtpub.asc
signature.asc
Description: This is a digitally signed message part
> Yutaka tanida <[EMAIL PROTECTED]> writes:
> > [EMAIL PROTECTED] wrote:
> >> does pgbench test with relatively large sequential scans?
>
> > Probably no.
>
> pgbench tries to avoid any seqscans at all, I believe, so it wouldn't be
> very useful for testing a method that's mainly intended to pre
Joe Conway <[EMAIL PROTECTED]> writes:
> Actually, adding a "pfree(oneres);" to the end of that for loop plugs
> the memory leak and allows me to see the error message:
On second look, you can't pfree oneres at the bottom of
gen_cross_product() because it's part of the returned data structure
---
--On Tuesday, June 24, 2003 10:44:25 -0400 Bruce Momjian
<[EMAIL PROTECTED]> wrote:
Larry Rosenman wrote:
>> > * Have SELECT '13 minutes'::interval display zero seconds
>> you might want to clarify the TODO to include in ISO DateStyle.
>>
>> (Per tom's comments).
>
> Can you supply an example
Larry Rosenman wrote:
> >> > * Have SELECT '13 minutes'::interval display zero seconds
> >> you might want to clarify the TODO to include in ISO DateStyle.
> >>
> >> (Per tom's comments).
> >
> > Can you supply an example/text?
> * Have SELECT '13 minutes'::interval display zero seconds when using
Yutaka tanida <[EMAIL PROTECTED]> writes:
> [EMAIL PROTECTED] wrote:
>> does pgbench test with relatively large sequential scans?
> Probably no.
pgbench tries to avoid any seqscans at all, I believe, so it wouldn't be
very useful for testing a method that's mainly intended to prevent
seqscans fr
--On Tuesday, June 24, 2003 09:46:33 -0400 Bruce Momjian
<[EMAIL PROTECTED]> wrote:
Larry Rosenman wrote:
>
> Add to TODO:
>
>* Have SELECT '13 minutes'::interval display zero seconds
you might want to clarify the TODO to include in ISO DateStyle.
(Per tom's comments).
Can you supply an exa
Joe Conway <[EMAIL PROTECTED]> writes:
> Actually, adding a "pfree(oneres);" to the end of that for loop plugs
> the memory leak and allows me to see the error message:
Good catch.
> Takes a while to check all 16777216 possibilities though, so I'm still
> not sure more isn't needed here.
I won
Weiping He <[EMAIL PROTECTED]> writes:
> we found the problem:
> We used IMMUTABLE modifier in our CREATE FUNCTION definition,
> though it's correct for our function to return same value if input the
> same *data*,
> but our data are passed by reference, not by value, so, some times we can't
> ret
Joe Conway <[EMAIL PROTECTED]> writes:
> Yeah. But we'd need to detect whether or not the Oracle client libs are
> available. I'm not sure how to do that with the contrib build system.
> And we'd need a fair amount of integration/reorganizing the existing
> code. Also, I've got the same issues w
Patch removed at author's request.
---
Yutaka tanida wrote:
> Hi.
>
> I implement 2Q algorithm to PostgreSQL for buffer management , instead
> of LRU.
> It's known as low overhead and high performance than LRU. If you have
OK, thanks. I will remove it from the queue, and someone suggested a
different algorithm today:
> I was researching on cache replacement strategy as well. 2Q has one
> disadvantage see this exellent paper:
> http://www.almaden.ibm.com/cs/people/dmodha/#ARC see the paper
> "ARC: A Self-Tuning, Low
Larry Rosenman wrote:
> >
> > Add to TODO:
> >
> > * Have SELECT '13 minutes'::interval display zero seconds
> you might want to clarify the TODO to include in ISO DateStyle.
>
> (Per tom's comments).
Can you supply an example/text?
--
Bruce Momjian| http://candle
It's rumoured that Vince Vielhaber once said:
> Whut? Please drop www.us as a postgresql mirror.
Just stop rsyncing and your mirror will be dropped automatically.
Regards, Dave.
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
Andreas Pflug wrote:
> I also could implement line break and indentation formatting. I
> implemented a keyword-based algorithm in pgAdmin3, and having the
> original tree the job is obviously easier. Do we need any flexibility
> about indent char (tab or space) and indentation size (2 chars)? Th
Great. I recommend using spaces rather than tabs for indenting in psql
and pg_dump.
---
Andreas Pflug wrote:
>
>
> Bruce Momjian wrote:
>
> >OK, added to TODO:
> >
> > Modify pg_get_triggerdef() to take a boolean to
Hi!
I want to use 'pset'command in my program
it's like this.
I want to do the execute the following in my program.
\pset null 'ALL'
how can this be done
bye
srikanth
---(end of broadcast)---
TIP 4: Don't 'kill -9' the postmaster
xoror,
On Tue, 24 Jun 2003 12:13:51 +0200 (MEST)
[EMAIL PROTECTED] wrote:
> I was researching on cache replacement strategy as well. 2Q has one
> disadvantage see this exellent paper:
> http://www.almaden.ibm.com/cs/people/dmodha/#ARC see the paper
> "ARC: A Self-Tuning, Low Overhead Replacement
Bruce,
On Mon, Jun 23, 2003 at 07:49:11PM -0400, Bruce Momjian wrote:
> This should fix most platforms. I am not sure how cygwin is going to
> handle this --- we might have to add a specific sa_family_t typedef
> for that platform --- MinGW does have sa_family_t, but probably
> doesn't need it an
On Mon, 23 Jun 2003 23:49:17 -0400 (EDT)
Bruce Momjian <[EMAIL PROTECTED]> wrote:
>
> Looks good to me --- we will include it in 7.4.
Thanks.But please note it is not completed yet. I must implement more ,
and move configurable parameter to postgresql.conf file.
--
Yutaka tanida <[EMAIL PROTE
Bruce,
On Mon, Jun 23, 2003 at 09:50:49PM -0400, Bruce Momjian wrote:
> OK, patch applied to typedef sa_family_t for cygwin. If other
> platforms need it, I will have to do something more generic.
I'm happy to report that the above patch solves one of Cygwin's current
build problems. However, C
Bruce Momjian wrote:
OK, added to TODO:
Modify pg_get_triggerdef() to take a boolean to pretty-print,
and use that as part of pg_dump along with psql
Andreas, can you work on this? I like the idea of removing extra
parens, and merging it into the existing code rather than into
> -Original Message-
> From: Christopher Kings-Lynne [mailto:[EMAIL PROTECTED]
> Sent: 24 June 2003 02:55
> To: [EMAIL PROTECTED]; pgsql-hackers list
> Subject: Re: [HACKERS] ftp mirror
>
>
> > Is it me or is there a problem with ftp mirrors?
> > The latest shapshots I have here are fr
On Mon, Jun 23, 2003 at 06:08:19PM -0700, Maksim Likharev wrote:
> Hi,
> I have some SQL function, just regular function selects data by using 4
> joins nothing fancy,
> but one thing pretty noticeable,
> I have to display 3 different columns with same date formatted
> differently,
> here are 3 dif
> > > I reported bug #943 (I found in 7.3.2) and you checked in some change against
> > > integer overflow.
> > > Now I upgraded to 7.3.3 and I'm not happy with this.
> > > The exact error as I described is fixed, but I found new errors in conversion
> > > UTF-8 <-> EUC_TW and BIG5:
> > >
> > > C
--On Monday, June 23, 2003 23:41:29 -0400 Bruce Momjian
<[EMAIL PROTECTED]> wrote:
Add to TODO:
* Have SELECT '13 minutes'::interval display zero seconds
you might want to clarify the TODO to include in ISO DateStyle.
(Per tom's comments).
LER
--
Larry Rosenman http:/
Joe Conway wrote:
I get nanswers = 16777216, so right off the bat 67MB or so is allocated.
Then there's this:
/* compute the cross product from right to left */
for (;;)
{
oneres = (Oid *) palloc0(FUNC_MAX_ARGS * sizeof(Oid));
I'm guessing this gets executed nanswers times.
69 matches
Mail list logo
