Tom Lane wrote:
> Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
>> http://www.kaltenbrunner.cc/files/analyze_q9_beta1.txt
>
> The next problem seems to be the drastic misestimation of this join
> size:
>
> -> Nested Loop (cost=0.00..6872092.36 rows=135 width=28) (actual
> time=94.762..1
Peter Eisentraut <[EMAIL PROTECTED]> wrote:
> > #max_fsm_pages = 160# min max_fsm_relations*16, 6 bytes each
>
> max_fsm_pages doesn't have a discernible unit
Yes, max_fsm_*pages* doesn't have a unit, but can we treat the value as
"the amount of trackable database size by fsm" or "e
On Sep 25, 2006, at 1:03 AM, Peter Eisentraut wrote:
Am Montag, 25. September 2006 04:04 schrieb ITAGAKI Takahiro:
#shared_buffers = 32000kB # min 128kB or max_connections*16kB
#temp_buffers = 8000kB # min 800kB
#effective_cache_size = 8000kB
Are there any reasons to continue to
Jim C. Nasby wrote:
> > The reason with the shared_buffers is that the detection code in
> > initdb has 400kB as minimum value, and it would be pretty
> > complicated to code the detection code to handle both kB and MB
> > units. If someone wants to try it, though, please go ahead.
>
> What about
Michael Meskes <[EMAIL PROTECTED]> writes:
>This double stuff creates so many headaches that I wonder if we
>better not test it at all in the regression suite. Comments?
If you're not prepared to support alternative expected files (as the
main regression tests do), then I think you have li
Neil Conway <[EMAIL PROTECTED]> writes:
> I agree the link should be fixed, but I can't see another canonical
> location for the document online: linking to CiteSeer (which itself is
> generated from the mention in our online docs) is probably not wise.
citeseer's cache still has the paper, and in
Tom,
> Thursday? My, we're feeling optimistic about the length of the beta
> period, aren't we?
It takes me a minumum of 2 weeks (preferably 3) to deal with the
translations. If we stay on schedule, I'll be *just* ready for a 1-month
beta.
--
--Josh
Josh Berkus
PostgreSQL @ Sun
San Franci
Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
> http://www.kaltenbrunner.cc/files/analyze_q9_beta1.txt
The next problem seems to be the drastic misestimation of this join
size:
-> Nested Loop (cost=0.00..6872092.36 rows=135 width=28) (actual
time=94.762..14429291.129 rows=3554044 loops=
Josh Berkus writes:
> http://pgfoundry.org/docman/view.php/147/233/release82.zip
> is a zip file of a draft of the PostgreSQL 8.2 release and accompanying
> press kit. Please check if the technical details are correct, and get
> back to me with any corrections by Thursday.
Thursday? My, w
All,
Here:
http://pgfoundry.org/docman/view.php/147/233/release82.zip
is a zip file of a draft of the PostgreSQL 8.2 release and accompanying
press kit. Please check if the technical details are correct, and get
back to me with any corrections by Thursday.
Thanks!
--
--Josh
Josh Berkus
Tom Lane wrote:
Zdenek Kotala <[EMAIL PROTECTED]> writes:
I'm playing with catalog upgrade via BKI format. I enhanced the pg_dump
of BKI output (not patch ready yet). I'm using it for some test now, but
I think It should be useful for some one other, for example some
application with embedded
Mark,
On 9/25/06 11:32 AM, "Mark Wong" <[EMAIL PROTECTED]> wrote:
> Yeah, basically gather as many stats as I can to accurately profile the
> overall system performance. I thought it would be appropriate to use a
> TPC-H based workload as one measuring stick to use for bitmap indexes.
Note that
Zdenek Kotala wrote:
I'm playing with catalog upgrade via BKI format. I enhanced the
pg_dump of BKI output (not patch ready yet). I'm using it for some
test now, but I think It should be useful for some one other, for
example some application with embedded postgres should use own
prepared BKI
Zdenek Kotala <[EMAIL PROTECTED]> writes:
> I'm playing with catalog upgrade via BKI format. I enhanced the pg_dump
> of BKI output (not patch ready yet). I'm using it for some test now, but
> I think It should be useful for some one other, for example some
> application with embedded postgres s
I'm playing with catalog upgrade via BKI format. I enhanced the pg_dump
of BKI output (not patch ready yet). I'm using it for some test now, but
I think It should be useful for some one other, for example some
application with embedded postgres should use own prepared BKI for
database init (wit
On Mon, Sep 25, 2006 at 09:29:28AM +0200, Jean-Paul Argudo wrote:
> Hi all,
>
> I would like to submit two ideas:
>
> 1/
> In the daily tasks I have as (also) a standard DBA, I found usefull to
> view locks in a human point of view. I think the "~ '^pg_'" part of the
> queries may be not so clean
On Mon, 2006-09-25 at 16:44 +0530, Gurjeet Singh wrote:
> At the end of the following page:
>
> http://www.postgresql.org/docs/8.0/static/indexes-partial.html
>
> there is a link [Generalized Partial Indexes] which is pointing to a
> missing link.
I agree the link should be fixed, but I can't s
On Mon, Sep 25, 2006 at 10:03:50AM +0200, Peter Eisentraut wrote:
> Am Montag, 25. September 2006 04:04 schrieb ITAGAKI Takahiro:
> > #shared_buffers = 32000kB # min 128kB or max_connections*16kB
> > #temp_buffers = 8000kB # min 800kB
> > #effective_cache_size = 8000kB
> >
> > Are th
Hi Jie,
Yeah, basically gather as many stats as I can to accurately profile the
overall system performance. I thought it would be appropriate to use a
TPC-H based workload as one measuring stick to use for bitmap indexes.
Mark
Jie Zhang wrote:
Hi Mark,
Thanks for doing the test. I checked
Hi Mark,
Thanks for doing the test. I checked out the link you provided below. I am a
little confused about the goal of these tests. Do you plan to test the
overall performance of postgreSQL on handling TPC-H queries?
Thanks,
Jie
On 9/22/06 3:45 PM, "Mark Wong" <[EMAIL PROTECTED]> wrote:
> Jie
On Fri, Sep 22, 2006 at 12:59:36PM -0700, Joe Conway wrote:
>
> In that case, what about things on gborg too?
Yes, same idea. I don't care where the project _lives_; the
important thing is its integration with PostgreSQL (and its quality).
A
--
Andrew Sullivan | [EMAIL PROTECTED]
When my inf
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Initdb does not currently make any attempt to discover the extent of
> physical or virtual memory, it simply tries to start postgres with
> certain shared_buffer settings, starting at 4000, and going down until
> we get a success.
> max_fsm_pages is
[RESENT in a modified version since the original reply seems to have ben
lost by the listserver which seems to happen sometimes lately]
Tom Lane wrote:
> Matteo Beccati <[EMAIL PROTECTED]> writes:
>> Tom Lane ha scritto:
>>> Matteo Beccati <[EMAIL PROTECTED]> writes:
I cannot see anything bad
Folks,
On Thu, Sep 21, 2006 at 03:05:36PM -0500, Jim C. Nasby wrote:
Regardless, I think we should include a section of major new
projects/developments from pgFoundry, because they ultimately make
PostgreSQL a more useful database. Maybe this list should only be in the
I like that. "New enha
> -Original Message-
> From: David Fetter [mailto:[EMAIL PROTECTED]
> Sent: 25 September 2006 16:57
> To: Dave Page
> Cc: Jim C. Nasby; Joe Conway; Andrew Sullivan;
> pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Release Notes: Major Changes in 8.2
>
> On Mon, Sep 25, 2006 at
On Mon, Sep 25, 2006 at 03:10:39PM +0100, Dave Page wrote:
> > From: [EMAIL PROTECTED]
> > [mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby
> >
> > For example, didn't pgAdmin just add support for Slony? That's
> > something worth mentioning.
>
> That was our last major release. You can see w
Markus Schaber <[EMAIL PROTECTED]> writes:
> http://developer.postgresql.org/pgdocs/postgres/release-8-2.html tells:
>> Add pg_dump -X no-data-for-failed-tables option to suppress loading
>> data if table creation failed (the table already exists) (Martin
>> Pitt)
> However, http://developer.post
Tom Lane wrote:
Andrew Dunstan <[EMAIL PROTECTED]> writes:
Yes, this appears to be a bug, not related to encoding etc. Maybe we
should be calling func_signature_string in generating this error.
Can't, because you don't have an Oid array for the types.
TypeNameToString is the correct th
Found a problem:
ereport(NOTICE,
(errmsg("function %s(%s) does not exist ... skipping",
NameListToString(functionName),
NameListToString(argTypes;
NameListToString() suppose as an argument List of Value nodes, but
argTypes is a l
On Sun, Sep 24, 2006 at 12:26:55AM -0400, Alvaro Herrera wrote:
> Joshua D. Drake wrote:
> > Tom Lane wrote:
>
> > >I asked around inside Red Hat but haven't gotten any responses yet ...
> > >seeing that it's a rather old Suse kernel, I can understand that RH's
> > >kernel hackers might not be too
Andrew Dunstan <[EMAIL PROTECTED]> writes:
> Yes, this appears to be a bug, not related to encoding etc. Maybe we
> should be calling func_signature_string in generating this error.
Can't, because you don't have an Oid array for the types.
TypeNameToString is the correct thing --- I'm considering
> -Original Message-
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED] On Behalf Of Jim C. Nasby
> Sent: 25 September 2006 15:03
> To: Joe Conway
> Cc: Andrew Sullivan; pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Release Notes: Major Changes in 8.2
>
> For
> example, didn
Teodor Sigaev wrote:
postgres=# drop type if exists foo;
NOTICE: type "foo" does not exist, skipping
DROP TYPE
postgres=# drop table if exists foo;
NOTICE: table "foo" does not exist, skipping
DROP TABLE
postgres=# drop function if exists foo();
NOTICE: function foo() does not exist ... skippi
On Fri, Sep 22, 2006 at 12:59:36PM -0700, Joe Conway wrote:
> Andrew Sullivan wrote:
> >On Thu, Sep 21, 2006 at 03:05:36PM -0500, Jim C. Nasby wrote:
> >
> >>Regardless, I think we should include a section of major new
> >>projects/developments from pgFoundry, because they ultimately make
> >>Postg
Jeremy Drake <[EMAIL PROTECTED]> writes:
> I just tried using the \lo_import command in a regression test, and I
> think I figured out why this will not work:
> ...
> Yes, that's the large object OID in the output there, and it is different
> each run (as I expect).
Right. I'd suggest temporarily
postgres=# drop type if exists foo;
NOTICE: type "foo" does not exist, skipping
DROP TYPE
postgres=# drop table if exists foo;
NOTICE: table "foo" does not exist, skipping
DROP TABLE
postgres=# drop function if exists foo();
NOTICE: function foo() does not exist ... skipping
DROP FUNCTION
postg
> -Original Message-
> From: Joachim Wieland [mailto:[EMAIL PROTECTED]
> Sent: 25 September 2006 13:25
> To: Dave Page
> Cc: Andrew Dunstan; pgsql-hackers@postgresql.org;
> [EMAIL PROTECTED]
> Subject: Re: [HACKERS] Buildfarm alarms
>
> On Sun, Sep 24, 2006 at 11:51:49AM +0100, Dave P
Not being an expert, but to me it looks like the client_encoding being set to
UTF8 but the data being sent is something other than UTF8. I've seen this
happen on Linux when connecting with PuTTY from Windows (and then psql from the
linux machine) and having the wrong encoding set in PuTTY. I'd
Hi, Csaba,
Csaba Nagy wrote:
> dbval=# select 1;
> ERROR: column " 1" does not exist
>
> The full story is that I typed 'ü' (u-umlaut if it won't render
> correctly) and backspace before the '1'. I guess the backspace will
> delete byte-wise and will so fail to delete properly multi-byte
> cha
> Not being an expert, but to me it looks like the client_encoding being set to
> UTF8 but the data being sent is something other than UTF8. I've seen this
> happen on Linux when connecting with PuTTY from Windows (and then psql from
> the linux machine) and having the wrong encoding set in PuTT
> Linux:
>
> $ echo 'DROP FUNCTION if exists foo(int);' | psql 1c Timing is on.
> SET
> Time: 197.941 ms
> NOTICE: function foo(░) does not exist ... skipping
> ERROR: invalid byte sequence for encoding "UTF8": 0x90
> HINT: This error can also happen if the byte sequence does not
> match the en
Linux:
$ echo 'DROP FUNCTION if exists foo(int);' | psql 1c
Timing is on.
SET
Time: 197.941 ms
NOTICE: function foo(░) does not exist ... skipping
ERROR: invalid byte sequence for encoding "UTF8": 0x90
HINT: This error can also happen if the byte sequence does not match the
encoding expecte
Hi, Dave,
Dave Cramer wrote:
>> I just read the docs about DELETE RETURNING in 8.2, and a small idea
>> arised:
>>
>> INSERT INTO logtable DELETE * FROM lifetable WHERE date<'2006-01-01'
>> RETURNING *;
>>
>> Will this work as expected?
> What is your expected result here ? It would return all th
On Sun, Sep 24, 2006 at 11:51:49AM +0100, Dave Page wrote:
> wrong to the monitoring processes - what had happened was that both had
> hung or got in an inifinite loop in ECPG-check, the machine was running
> just fine
Is this still an issue? Can you provide more information? What happens if you
r
Teodor Sigaev wrote:
current default of 1000 pages (8Mb) seems really pretty silly for modern
machines; we could certainly set it to 10 times that without problems,
and maybe much more. Thoughts?
May be, set by default effective_cache_size equal to number of shared
buffers?
If pgsql is conf
It's very weird, because if you get through to this stage it means you
have already run initdb successfully during the make-check stage.
Certainly the trace below looks like it's a failure in the startup code
- maybe a DLL mismatch, although that shouldn't be possible? Does your
Cygwin insta
On 25-Sep-06, at 4:31 AM, Markus Schaber wrote:
Hi,
I just read the docs about DELETE RETURNING in 8.2, and a small
idea arised:
INSERT INTO logtable DELETE * FROM lifetable WHERE date<'2006-01-01'
RETURNING *;
Will this work as expected?
What is your expected result here ? It would retur
> I just had a look at the reports and it seems we have several
> things going on:
>
> 1) libpq gives additional information when not able to connect:
> could not connect to server: Connection refused
> (0x274D/10061)
>instead of just:
> could not connect to server: Connection
On Sep 22, 2006, at 2:50 PM, Joshua D. Drake wrote:
And how were you planning to tell if a patch cam from a regular?
Hopefully
you weren't planning on blindly trusting the "from" header.
Misuse of the build farm in a way the effects other sites could
get the
project a big black eye, so you w
Hi,
http://developer.postgresql.org/pgdocs/postgres/release-8-2.html tells:
> Add pg_dump -X no-data-for-failed-tables option to suppress loading
> data if table creation failed (the table already exists) (Martin
> Pitt)
However, http://developer.postgresql.org/pgdocs/postgres/app-pgdump.html
se
At the end of the following page:http://www.postgresql.org/docs/8.0/static/indexes-partial.html there is a link [
Generalized Partial Indexes] which is pointing to a missing link. Can someone update the link with a live doc? Probably
this one Regards,-- [EMAIL PROTECTED][EMAIL PROTECTED] gmail
> -Original Message-
> From: Michael Meskes [mailto:[EMAIL PROTECTED]
> Sent: 25 September 2006 11:57
> To: Dave Page
> Cc: pgsql-hackers@postgresql.org
> Subject: Re: [HACKERS] Windows build farm failures
>
> On Sun, Sep 24, 2006 at 08:54:35PM +0100, Dave Page wrote:
> > Snake and Ban
On Sun, Sep 24, 2006 at 08:54:35PM +0100, Dave Page wrote:
> Snake and Bandicoot are still hanging in ECPG-Check at the moment.
> Killing the dt_test.exe program that the regression tests seem to be
> running frees it all up to properly report the failure. I don't have
> time to investigate further
Hi,
I just read the docs about DELETE RETURNING in 8.2, and a small idea arised:
INSERT INTO logtable DELETE * FROM lifetable WHERE date<'2006-01-01'
RETURNING *;
Will this work as expected?
It might be a good example to put into the docs then.
If not, it may be worth the effort to make it wor
On Fri, 2006-09-22 at 14:16 +0100, Dave Page wrote:
> Following the recent discussion on this list and another on pgsql-core,
> we have decided that we would like to aim to meet the following schedule
> for the release of PostgreSQL 8.3:
>
> April 1st 2007 - Feature freeze
>
> May 1st 2007 - Beta
Hello,
The Cassowary buildfarm memeber is curently failing when performing initdb .
The corresponding log file initdb.log is empty.
When running initdb manually, it dies immediately "with code 0200".
Other executables (psql, createlang, createdb for example) fail in the same
manner. But some oth
current default of 1000 pages (8Mb) seems really pretty silly for modern
machines; we could certainly set it to 10 times that without problems,
and maybe much more. Thoughts?
May be, set by default effective_cache_size equal to number of shared buffers?
If pgsql is configured to use quarter o
Am Montag, 25. September 2006 04:04 schrieb ITAGAKI Takahiro:
> #shared_buffers = 32000kB # min 128kB or max_connections*16kB
> #temp_buffers = 8000kB # min 800kB
> #effective_cache_size = 8000kB
>
> Are there any reasons to continue to use 1000-unit numbers? Megabyte-unit
> (32MB an
Hi, Bruce,
Bruce Momjian wrote:
>>> I don't think that any of our SGML documentation is actually in UCS-4
>>> encoding.
>> The source files use nothing beyond plain ASCII (and should remain that
>> way, IMHO) so there isn't any need to inquire very far into exactly what
>> the toolchain thinks th
Hi, Hannu,
Hannu Krosing wrote:
>>> Are you sure it's UCS-4 ? I've always thought that XML is what is given
>>> in tag, and utf-8 if no charset is given.
>> You have to distinguish between the supported charset, and the document
>> encoding.
> UCS-4 and UTF-8 are both encodings for UNICODE
> se
Hi all,
I would like to submit two ideas:
1/
In the daily tasks I have as (also) a standard DBA, I found usefull to
view locks in a human point of view. I think the "~ '^pg_'" part of the
queries may be not so clean... Any ideas welcome :)
2/
Also, I like having a cache hit/miss ratio. This is w
61 matches
Mail list logo
