Peter Eisentraut wrote:
On Monday 11 August 2008 16:23:29 Jan Urbański wrote:
Often clients want their searches to be
accented-or-language-specific letters insensitive. So searching for
'łódź' returns 'lodz'. So the use case is there (in fact, the lack of
such facility made me consider not
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
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.
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
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 and
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
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?
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
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
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
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 would
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't
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
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.
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
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
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 with
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 approach,
where
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 about the
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
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 apply can
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:have
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 sounds best and I
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 as we
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
optionally
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 or around
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 cancel keys each time
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 execute the
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
--
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
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
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
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 architecture
*
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 rather than
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,
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 that
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,
* different
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
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 will
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
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
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
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 very
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
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 such a table it's
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 going to matter for
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 treated
.. 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 mailing list
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
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
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 defined
.. 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
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 a
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
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:
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
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
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 that
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 change represents
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
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 the
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 that every additional
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 to be
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
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
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 think the
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 when the
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 reproducibility.
-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: Re:
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
gettimeofday() call
70 matches
Mail list logo
