Tom Lane <[EMAIL PROTECTED]> wrote:
> ITAGAKI Takahiro <[EMAIL PROTECTED]> writes:
> > Here is a patch to add duration option (-T) to pgbench instead of
> > number of transactions (-t). -t and -T are mutually exclusive.
>
> This seems like a fairly bad idea, because it introduces a
> gettimeofda
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:pgsql-hackers-
> [EMAIL PROTECTED] On Behalf Of Bruce Momjian
> Sent: Tuesday, August 12, 2008 9:04 PM
> To: Robert Haas
> Cc: Markus Wanner; Matthew T. O'Connor; Tom Lane; Greg Sabino Mullane;
> pgsql-hackers@postgresql.org
> Subject:
Tom Lane wrote:
> Alvaro Herrera <[EMAIL PROTECTED]> writes:
> > Tom Lane wrote:
> >> What I think Simon was actually driving at was query-shipping, which is
> >> not my idea of "WAL" at all. It has some usefulness, but also a bunch
> >> of downsides of its very own, mostly centered around reprodu
Robert Haas wrote:
> >> > .. an OS-agnostic way of installing packages.
> >> Uh.. I don't think such a thing exists.
> > Seems to in Firefox.
>
> I think nearly all Firefox extensions are written in XML and
> Javascript. It's quite a bit easier to have an OS-agnostic way of
> installing packages
Alvaro Herrera <[EMAIL PROTECTED]> writes:
> Tom Lane wrote:
>> What I think Simon was actually driving at was query-shipping, which is
>> not my idea of "WAL" at all. It has some usefulness, but also a bunch
>> of downsides of its very own, mostly centered around reproducibility.
> Actually I th
Hi Tom,
Part of this is semantics-I like Simon's logical vs. physical terminology
because it distinguishes neatly between replication that copies implementation
down to OIDs etc. and replication that copies data content including schema
changes but not implementation. It seems a noble goal get
Tom Lane wrote:
> What I think Simon was actually driving at was query-shipping, which is
> not my idea of "WAL" at all. It has some usefulness, but also a bunch
> of downsides of its very own, mostly centered around reproducibility.
> With the current WAL design I have some faith that the slaves
Magnus Hagander <[EMAIL PROTECTED]> writes:
> Andrew Gierth wrote:
>> That's easily solved: when the client wants to do a cancel, have it
>> send, in place of the actual cancel key, an integer N and the value
>> HMAC(k,N) where k is the cancel key. Replay is prevented by requiring
>> the value of N
On Tue, 2008-08-12 at 23:58 +0100, Gregory Stark wrote:
> "Simon Riggs" <[EMAIL PROTECTED]> writes:
>
> > On Tue, 2008-08-12 at 15:46 -0400, Tom Lane wrote:
> >> Simon Riggs <[EMAIL PROTECTED]> writes:
> >> > Proposal: Make the first block of a seq scan cost random_page_cost, then
> >> > after th
Decibel! <[EMAIL PROTECTED]> writes:
> I disagree. While we don't guarantee stats are absolutely up-to-date,
> or atomic I don't think that gives license for them to just magically
> not exist sometimes.
> Would it really be that hard to have the system copy the file out
> before telling all
Markus Wanner <[EMAIL PROTECTED]> writes:
> Robert Hodges wrote:
>> Could you expand on why logical application of WAL records is impractical in
>> these cases? This is what Oracle does. Moreover once you are into SQL a
>> lot of other use cases immediately become practical, such as large scale
>
Gregory Stark <[EMAIL PROTECTED]> writes:
>> On Tue, 2008-08-12 at 15:46 -0400, Tom Lane wrote:
>>> This is only going to matter for a table of 1 block (or at least very
>>> few blocks), and for such a table it's highly likely that it's in RAM
>>> anyway. So I'm unconvinced that the proposed chang
Tom Raney <[EMAIL PROTECTED]> writes:
> My question is: How would I let the planner know when a planner session
> has been invoked by the "explain" command? If I can slip a flag into
> PlannerInfo or PlannerGlobal, that would be perfect. But, I'm a bit
> stuck on how to get explain context to
ITAGAKI Takahiro <[EMAIL PROTECTED]> writes:
> Here is a patch to add duration option (-T) to pgbench instead of
> number of transactions (-t). -t and -T are mutually exclusive.
This seems like a fairly bad idea, because it introduces a
gettimeofday() call per transaction. On lots of (admittedly
Robert Treat escreveu:
On Saturday 09 August 2008 21:31:28 Euler Taveira de Oliveira wrote:
Hi,
After the Magnus patch [1], that make it possible store statistics files
at another (RAM-based) disk, I was thinking that would be useful to add
an option at initdb time to do the symlink as we alrea
Hello,
Here is a patch to add duration option (-T) to pgbench instead of
number of transactions (-t). -t and -T are mutually exclusive.
$ pgbench -n -S -c10 -T10
transaction type: SELECT only
scaling factor: 1
query mode: simple
number of clients: 10
number of transactions actually processed: 225
On Aug 12, 2008, at 18:12, Robert Haas wrote:
I realize many prefer their OS-native packaging system, but
that isn't the target audience of a packaging system that will
increase
adoption.
Really? Who is it?
Those of us who don't use packaging systems. And, we are legion.
Best,
David
-
On Tue, 2008-08-12 at 23:58 +0100, Gregory Stark wrote:
> People lower random_page_cost because we're not doing a good job
> estimating how much of a table is in cache.
Is it because of a bad estimate about how much of a table is in cache,
or a bad assumption about the distribution of access to
>> > .. an OS-agnostic way of installing packages.
>> Uh.. I don't think such a thing exists.
> Seems to in Firefox.
I think nearly all Firefox extensions are written in XML and
Javascript. It's quite a bit easier to have an OS-agnostic way of
installing packages when the packages are platform-in
Simon Riggs <[EMAIL PROTECTED]> wrote:
> On Tue, 2008-08-12 at 13:34 -0400, Bruce Momjian wrote:
> > Is there a TODO here?
>
> Yes, three:
> * create plugin API to allow extensible reloptions
Yes, and some index access methods (gist and gin) should have
abilities to handle reloptions in user d
I've been working on a client application (based on the Red Hat Visual
Explain tool) to display all plans the planner considers graphically and
it does that. But, the trace functionality in the planner is always on
(and thus, taking up cycles and resources) whether or not it is
requested by th
On Aug 12, 2008, at 12:27 PM, Magnus Hagander wrote:
I don't think it'd be that hard to handle the SIGHUP case - just have
the stats collector start writing it in the new location the next time
it writes it out, and backends will start reading from there.
There's a
short window where the backe
.. an OS-agnostic way of installing packages.
>>>
>>> Uh.. I don't think such a thing exists.
>>
>> Seems to in Firefox.
>
> And Perl's CPAN repository and installation module.
Don't forget the command line installation of packages for the R
programming language.
--
Sent via pgsql-hackers m
On Aug 11, 2008, at 3:40 PM, Gregory Stark wrote:
"Decibel!" <[EMAIL PROTECTED]> writes:
On Aug 8, 2008, at 3:23 PM, Tom Lane wrote:
* has no set operations (UNION etc), grouping, set-returning
functions
in the SELECT list, LIMIT, or a few other funny cases
Couldn't union/union all be trea
"Simon Riggs" <[EMAIL PROTECTED]> writes:
> On Tue, 2008-08-12 at 15:46 -0400, Tom Lane wrote:
>> Simon Riggs <[EMAIL PROTECTED]> writes:
>> > Proposal: Make the first block of a seq scan cost random_page_cost, then
>> > after that every additional block costs seq_page_cost.
>>
>> This is only go
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
>> Proposal: Make the first block of a seq scan cost
>> random_page_cost, then after that every additional block costs
>> seq_page_cost.
Tom> This is only going to matter for a table of 1 block (or at least
Tom> very few blocks), and for su
Hi,
Robert Hodges wrote:
Could you expand on why logical application of WAL records is impractical in
these cases? This is what Oracle does. Moreover once you are into SQL a
lot of other use cases immediately become practical, such as large scale
master/slave set-ups for read scaling.
I cann
On Tue, 2008-08-12 at 15:46 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > Proposal: Make the first block of a seq scan cost random_page_cost, then
> > after that every additional block costs seq_page_cost.
>
> This is only going to matter for a table of 1 block (or at least
Hi Tom,
Could you expand on why logical application of WAL records is impractical in
these cases? This is what Oracle does. Moreover once you are into SQL a
lot of other use cases immediately become practical, such as large scale
master/slave set-ups for read scaling.
Thanks, Robert
On 8/12/08
On Aug 12, 2008, at 12:42 PM, Bruce Momjian wrote:
Markus Wanner wrote:
Hi,
Robert Haas wrote:
I can't speak for anyone else, but I much prefer packages that make
use of my operating system's package management system rather than
rolling their own. If I need a perl package that I can't get
On Aug 12, 2008, at 13:16, Bruce Momjian wrote:
.. an OS-agnostic way of installing packages.
Uh.. I don't think such a thing exists.
Seems to in Firefox.
And Perl's CPAN repository and installation module.
Best,
David
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.or
Markus Wanner wrote:
> Hi,
>
> Bruce Momjian wrote:
> > .. an OS-agnostic way of installing packages.
>
> Uh.. I don't think such a thing exists.
Seems to in Firefox.
> > I realize many prefer their OS-native packaging system, but
> > that isn't the target audience of a packaging system that wi
Hi,
Bruce Momjian wrote:
.. an OS-agnostic way of installing packages.
Uh.. I don't think such a thing exists.
I realize many prefer their OS-native packaging system, but
that isn't the target audience of a packaging system that will increase
adoption.
I'm just arguing that such a packagin
On Tue, 2008-08-12 at 15:40 -0400, Tom Lane wrote:
> Simon Riggs <[EMAIL PROTECTED]> writes:
> > On Tue, 2008-08-12 at 11:52 -0400, Bruce Momjian wrote:
> >> What is the attraction of logical application of the WAL logs?
> >> Transmitting to a server with different architecture?
>
> > Yes,
>
>
Simon Riggs <[EMAIL PROTECTED]> writes:
> Proposal: Make the first block of a seq scan cost random_page_cost, then
> after that every additional block costs seq_page_cost.
This is only going to matter for a table of 1 block (or at least very
few blocks), and for such a table it's highly likely tha
On Tue, 12 Aug 2008, Bruce Momjian wrote:
There's already some changes needed in this area needed to execute the
full GUC cleanup/wizard plan that's being worked on. The pg_settings view
really should show the value both as the user input it and as it's stored
internally for cases like these, w
Markus Wanner wrote:
> Hi,
>
> Robert Haas wrote:
> > I can't speak for anyone else, but I much prefer packages that make
> > use of my operating system's package management system rather than
> > rolling their own. If I need a perl package that I can't get through
> > yum, I build my own RPMs ra
Simon Riggs <[EMAIL PROTECTED]> writes:
> On Tue, 2008-08-12 at 11:52 -0400, Bruce Momjian wrote:
>> What is the attraction of logical application of the WAL logs?
>> Transmitting to a server with different architecture?
> Yes,
> * different release
> * different encoding
> * different CPU archi
If we access a 1 block table using a SeqScan then it costs
seq_page_cost, or 1 by default.
If we access the same 1 block table using an IndexScan then the access
costs random_page_cost to access the index block and then
random_page_cost to access to the data block.
So the same block accessed for
Hi,
Robert Haas wrote:
I can't speak for anyone else, but I much prefer packages that make
use of my operating system's package management system rather than
rolling their own. If I need a perl package that I can't get through
yum, I build my own RPMs rather than installing through CPAN.
I ve
I can't speak for anyone else, but I much prefer packages that make
use of my operating system's package management system rather than
rolling their own. If I need a perl package that I can't get through
yum, I build my own RPMs rather than installing through CPAN.
I actually think that the bigge
On Tue, 2008-08-12 at 13:34 -0400, Bruce Momjian wrote:
> Is there a TODO here?
Yes, three:
* create plugin API to allow extensible reloptions
* allow reloptions to be copied when using INCLUDING DEFAULTS
(if I got that right..)
* allow new option to copy comments INCLUDING COMMENTS
--
Simo
Greg Smith wrote:
> On Thu, 24 Jul 2008, Greg Sabino Mullane wrote:
>
> > Bite the bullet and start showing the buffer settings as a pure number of
> > bytes
> > everywhere, and get rid of the confusing '8kB' unit in pg_settings?
>
> There's already some changes needed in this area needed to exe
Andrew Gierth wrote:
>> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
>
> > Alvaro Herrera <[EMAIL PROTECTED]> writes:
> >> I wonder if we can do something diffie-hellman'ish, where we have
> >> a parameter exchanged in the initial SSL'ed handshake, which is
> >> later used to generate new
Is there a TODO here?
---
ITAGAKI Takahiro wrote:
>
> Simon Riggs <[EMAIL PROTECTED]> wrote:
>
> > On Thu, 2008-07-24 at 11:41 -0400, Tom Lane wrote:
> >
> > > Now, if you're suggesting we need a plugin hook somewhere in
Simon Riggs wrote:
> > > > with values of:
> > > >
> > > > nothing:have network traffic send WAL as needed
> > > > netflush: wait for flush of WAL network packets to slave
> > > > process:wait for slave to process WAL traffic and
> > > >
Robert Treat wrote:
> On Saturday 09 August 2008 21:31:28 Euler Taveira de Oliveira wrote:
>> Hi,
>>
>> After the Magnus patch [1], that make it possible store statistics files
>> at another (RAM-based) disk, I was thinking that would be useful to add
>> an option at initdb time to do the symlink a
On Tue, 2008-08-12 at 12:54 -0400, Bruce Momjian wrote:
> Simon Riggs wrote:
> >
> > On Tue, 2008-08-12 at 11:51 -0400, Bruce Momjian wrote:
> > > I think you need to make it an enumerated type like log_min_messages;
> > > something like:
> > >
> > > wal_transfer_wait
> >
> > Yeh, that way s
Simon Riggs wrote:
>
> On Tue, 2008-08-12 at 11:51 -0400, Bruce Momjian wrote:
> > I think you need to make it an enumerated type like log_min_messages;
> > something like:
> >
> > wal_transfer_wait
>
> Yeh, that way sounds best and I like name.
>
> > with values of:
> >
> > nothing:
Simon Riggs wrote:
> > What is the attraction of logical application of the WAL logs?
> > Transmitting to a server with different architecture?
>
> Yes,
>
> * different release
> * different encoding
> * different CPU architecture
> * (with the correct transform) a different DBMS
>
> So logical
On Tue, 2008-08-12 at 11:51 -0400, Bruce Momjian wrote:
> I think you need to make it an enumerated type like log_min_messages;
> something like:
>
> wal_transfer_wait
Yeh, that way sounds best and I like name.
> with values of:
>
> nothing:have network traffic send WAL as
Markus Wanner wrote:
> Hi,
>
> Bruce Momjian wrote:
> > The bottom line is that for software to be successful we need a critical
> > mass, and as long as we are doing OS-specific plugins we aren't going to
> > reach that critical mass because the OS-specific aspect splits up
> > demand.
>
> What
On Tue, 2008-08-12 at 11:52 -0400, Bruce Momjian wrote:
> Simon Riggs wrote:
> >
> > On Sat, 2008-07-26 at 10:17 +0200, Markus Wanner wrote:
> > > What I still don't understand is, why you are speaking about
> > > "logical"
> > > replication. It rather sounds like an ordinary log shipping approa
Simon Riggs wrote:
>
> On Sat, 2008-07-26 at 10:17 +0200, Markus Wanner wrote:
> > What I still don't understand is, why you are speaking about
> > "logical"
> > replication. It rather sounds like an ordinary log shipping approach,
> > where the complete WAL is sent over the wire. Nothing wrong
Simon Riggs wrote:
> We can generalise this as three closed questions, answered either Yes
> (Synchronous) or No (Asynchronous)
>
> * Does WAL get forced to disk on primary at commit time?
> * Does WAL get forced across link to standby at commit time?
> * Does WAL get forced to disk on standby at
Hi,
Bruce Momjian wrote:
The bottom line is that for software to be successful we need a critical
mass, and as long as we are doing OS-specific plugins we aren't going to
reach that critical mass because the OS-specific aspect splits up
demand.
What about the pgxs toolchain? Doesn't that provi
On Saturday 09 August 2008 21:31:28 Euler Taveira de Oliveira wrote:
> Hi,
>
> After the Magnus patch [1], that make it possible store statistics files
> at another (RAM-based) disk, I was thinking that would be useful to add
> an option at initdb time to do the symlink as we already do with xlog.
Peter Eisentraut wrote:
> Am Tuesday, 12. August 2008 schrieb Bruce Momjian:
> > I feel the above comment about Firefox is the crux of the plugin issue.
>
> The difference is that Firefox is an interactive eye-candy system whereas
> PostgreSQL is a functionality-based server system. A PostgreSQL
Markus Wanner wrote:
> Hi,
>
> Bruce Momjian wrote:
> > So, ideally, if we do a plug-in system, I think we need some way to have
> > these plugins be very easily installed, perhaps by choosing object files
> > pre-compile by the build farm for each operating system.
>
> IIRC the main problem isn'
Tom Lane wrote:
> Magnus Hagander <[EMAIL PROTECTED]> writes:
>> The problem was (third IIRC here :-P) in other clients, such as the JDBC
>> driver (I think that one was checked specifically) which currently only
>> accept the BackendKeyData message during startup. All drivers not based
>> on libpq
Josh Berkus wrote:
KaiGai Kohei wrote:
On the WiKi of CommitFest:Sep,
http://wiki.postgresql.org/wiki/CommitFest:2008-09
The entry of SE-PostgreSQL points a message when I submitted older
version
of our patch set. But the latest ones are listed on another message.
Please add a link to the
Am Tuesday, 12. August 2008 schrieb Bruce Momjian:
> I feel the above comment about Firefox is the crux of the plugin issue.
The difference is that Firefox is an interactive eye-candy system whereas
PostgreSQL is a functionality-based server system. A PostgreSQL database
system needs to have a
Hi Zdenek,
Zdenek Kotala wrote:
It is not related to fork maps. The idea is to learn PostgreSQL process
to read old data page structures. It is part of in-place upgrade and it
was discussed on PGCon this year. You can see more info on
http://wiki.postgresql.org/wiki/In-place_upgrade
http://ww
Markus Wanner napsal(a):
Hi,
Zdenek Kotala wrote:
I finished first prototype of new page API.
This might seem obvious to you, but could you please describe the
problem you are trying to solve with this new page API? How does it
relate to the relation forks, that have just been committed?
We're currently printing the warning about connecting to the wrong version of
the server *before* syncing variables. On reconnecting this results in using
the *old* server version before reconnecting. I'm not sure what happens for
the initial connection but it can't be good. connection_warnings al
Here is an updated version of the "Copy storage parameters" patch.
http://archives.postgresql.org/pgsql-hackers/2008-07/msg01417.php
This patch copies only column storage parameters and does not copy
reloptions as a result of the discussion, in which reloptions should
not be copied because LIKE an
Hi,
Zdenek Kotala wrote:
I finished first prototype of new page API.
This might seem obvious to you, but could you please describe the
problem you are trying to solve with this new page API? How does it
relate to the relation forks, that have just been committed?
Regards
Markus
--
Sent
Hi,
Bruce Momjian wrote:
So, ideally, if we do a plug-in system, I think we need some way to have
these plugins be very easily installed, perhaps by choosing object files
pre-compile by the build farm for each operating system.
IIRC the main problem isn't compilation and packaging of plugins.
On Tue, Aug 12, 2008 at 4:13 AM, Bruce Momjian <[EMAIL PROTECTED]> wrote:
> So, ideally, if we do a plug-in system, I think we need some way to have
> these plugins be very easily installed, perhaps by choosing object files
> pre-compile by the build farm for each operating system.
Hmm, that idea
69 matches
Mail list logo
