I'm now participating in a PG project.I need to modify some parts of the
log buffer flushing function and the data buffer flushing function.I don't
know where they are.
Could you tell me where the following two functions are:
--Log Buffer Flush:Only flush the dirty log buffer into the disk
On Sat, Mar 11, 2006 at 12:15:08PM -0500, Tom Lane wrote:
> "Markus Bertheau" <[EMAIL PROTECTED]> writes:
> > Why is it trying to use 5432? Am I missing something? Is that the
> > expected behaviour?
>
> > Michael Fuhr hinted that
> > http://archives.postgresql.org/pgsql-committers/2006-02/msg0013
BTW, I noticed difference of outputs from pg_freespacemap and
pgstattuple.
I ran pgbench and inspected "accounts" table by using these tools.
pg_freespacemap:
sum of bytes: 250712
pgstattuple:
free_space: 354880
Shouldn't they be identical?
--
Tatsuo Ishii
SRA OSS, Inc. Japan
-
Mark,
I have tried your patches and it worked great. Thanks.
--
Tatsuo Ishii
SRA OSS, Inc. Japan
> Tom Lane wrote:
> > Mark Kirkwood <[EMAIL PROTECTED]> writes:
> >
> >>>Good points! I had not noticed this test case. Probably NULL is better
> >
> >
> >>Would setting it to 'BLCKSZ - (fixed ind
Hannu Krosing <[EMAIL PROTECTED]> writes:
> At some point I had to compress a very busily updated table. I used the
> following approach:
> [ move a few rows at a time ]
We could possibly do something similar with VACUUM FULL as well: once
maintenance_work_mem is filled, start discarding per-page
Ühel kenal päeval, R, 2006-03-10 kell 12:23, kirjutas Steve Atkins:
> I get bitten by this quite often (customer machines, one giant table,
> purge out a lot of old data).
>
> CLUSTER is great for that, given the headroom, though I've often
> resorted to a dump and restore because I've not had th
From: "Jaime Casanova" <[EMAIL PROTECTED]>
To: "Pavel Stehule" <[EMAIL PROTECTED]>
CC: pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Function's final statement must not be a SELECT
Date: Sat, 11 Mar 2006 12:42:15 -0500
On 3/10/06, Pavel Stehule <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I
Tom Lane wrote:
> I wrote:
>
>>Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
>>
>>>samples %symbol name
>>>350318533 98.8618 mergepreread
>>>9718220.2743 tuplesort_gettuple_common
>>>4136740.1167 tuplesort_heap_siftup
>
>
>>I don't have enough memory to really reproduce th
On 3/10/06, Pavel Stehule <[EMAIL PROTECTED]> wrote:
> Hello,
>
> I want do sql wrap for woid plpgsql function. But void SQL function must not
> finish SELECT cmd. I don't know any others command which I can use.
>
> Can You help me?
> Thank You
> Pavel Stehule
>
perform * from your_table;
--
Ate
"Markus Bertheau" <[EMAIL PROTECTED]> writes:
> Why is it trying to use 5432? Am I missing something? Is that the
> expected behaviour?
> Michael Fuhr hinted that
> http://archives.postgresql.org/pgsql-committers/2006-02/msg00139.php
> may be the cause of that.
Confirmed here: \c drops the previo
Neil Conway wrote:
> On Thu, 2006-03-09 at 17:29 -0400, Bruce Momjian wrote:
> > Remove Jan Wieck's name from copyrights, and put in standard
> > boilerplate, with approval of author.
>
> You missed a few:
>
> src/pl/tcl/pltcl.c
> src/pl/tcl/license.terms
> src/backend/utils/adt/ruleutils.c
>
>
It's still not easy to come from Russia to Canada. I have to convince
officer in canadian embassy that
1) I have enough money for living in Canada
2) I don't want to immigrate
3) I'm a loyal citizen
Invitation from conference commitee could help me to get an official letter
from my institute to
Quoth [EMAIL PROTECTED] ("Marc G. Fournier"):
> Just curious, but how do ppl come to Canada as tourists from other
> countries? I don't imagine they need to be "invited" by a Canadian,
> do they?
Well, the "invitation" thing doesn't apply at all to people from North
America or Western Europe; it'
In an attempt to throw the authorities off his trail, pgman@candle.pha.pa.us
(Bruce Momjian) transmitted:
> Jan Wieck wrote:
>> We've been there before, and not only once. I wonder why we still find
>> more of these, because every time it comes up I agree to removal of it.
>
> Perhaps your name r
On Saturday 11 March 2006 05:51, Michael Glaesemann wrote:
> On Mar 11, 2006, at 19:36 , Markus Bertheau wrote:
> > I'm pretty sure you didn't have to specify the port with \c again in
> > earlier versions - so this is a regression, and a confusing one imho
>
> You couldn't connect to another host
On Mar 11, 2006, at 19:36 , Markus Bertheau wrote:
I'm pretty sure you didn't have to specify the port with \c again in
earlier versions - so this is a regression, and a confusing one imho
You couldn't connect to another host from the same psql session, so
including the port wasn't even an
On Mar 11, 2006, at 19:13 , Markus Bertheau wrote:
Why is it trying to use 5432? Am I missing something? Is that the
expected behaviour?
Was your 8.2devel install built with the default port of 5432? (i.e.,
do you need to set the port to 5433 in postgresql.conf or at server
start? It look
Hi,
this is from HEAD of a few days ago, it looks suspicious to me.
8.2devel runs on port 5433.
[EMAIL PROTECTED]:~/pgsql$ bin/psql -p 5433 template1 markus
Welcome to psql 8.2devel, the PostgreSQL interactive terminal.
Type: \copyright for distribution terms
\h for help with SQL commands
> > i am trying to download the windows version since 3 hours
> ago and just
> > get an error page no matters if i try the FTP browser, ftp
> mirrors or
> > bittorrent
> >
Fixed now, thanks for reporting.
//Magnus
---(end of broadcast)---
TIP 2
Tom Lane wrote:
> Stefan Kaltenbrunner <[EMAIL PROTECTED]> writes:
>
3. vacuuming this table - it turned out that VACUUM FULL is completly
unusable on a table(which i actually expected before) of this size not
only to the locking involved but rather due to a gigantic memory
require
Stefan,
On 3/11/06 12:21 AM, "Stefan Kaltenbrunner" <[EMAIL PROTECTED]> wrote:
>> So - you're getting 20MB/s on loading from a potential of 200MB/s?
>
> no - I can write 110MB/s on thw WAL LUN and 110MB/s on the other LUN
> concurrently.
The numbers you published earlier show you are getting a
Luke Lonergan wrote:
> Stefan,
>
> On 3/10/06 12:23 PM, "Stefan Kaltenbrunner" <[EMAIL PROTECTED]> wrote:
>
>
>>wrong(or rather extremely optimistic) the array itself only has two
>>(redundant) FC-loops(@2GB )to the attached expansion chassis. The array
>>has 2 active/active controllers (with a
22 matches
Mail list logo
