Hello Heikki,
For the kicks, I wrote a quick dirty patch for interleaving the fsyncs, see
attached. It works by repeatedly scanning the buffer pool, writing buffers
belonging to a single relation segment at a time.
I tried this patch on the same host I used with the same -R 25 -L 200 -T
Hello Peter,
Here is a review:
The version 2 of the patch applies cleanly on current head.
The ability to generate and reuse a temporary installation for different
tests looks quite useful, thus putting install out of pg_regress and in
make seems reasonnable.
However I'm wondering
Re: Fabrízio de Royes Mello 2014-06-25
CAFcNs+oAb8h-0w2vLEWj6R-Gv=xizgdBya3K=SCd_9Tjyo=z...@mail.gmail.com
On Wed, Jun 25, 2014 at 3:52 PM, Tom Lane t...@sss.pgh.pa.us wrote:
Would like that, but I'm not sure what pgindent will do with the //
comments. It's been on my to-do list to switch
On 8/31/14 12:40 AM, Dobes Vandermeer wrote:
The background workers can apparently only connect to a single database
at a time, but I want to expose all the databases via the API.
I think the term background worker should be taken as a hint that
foreground protocol endpoint was not one of the
On 8/30/14 2:26 AM, Jeff Janes wrote:
But there cases were people use COPY in a loop with a small amount of
data in each statement.
What would be the reason for doing that?
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
On Tue, Aug 26, 2014 at 9:43 AM, Michael Paquier
michael.paqu...@gmail.com wrote:
On Tue, Aug 19, 2014 at 2:49 PM, Michael Paquier
michael.paqu...@gmail.com wrote:
On Mon, Aug 18, 2014 at 4:01 PM, Michael Paquier
michael.paqu...@gmail.com wrote:
On Mon, Aug 18, 2014 at 3:48 PM, Fujii Masao
Em domingo, 31 de agosto de 2014, Christoph Berg c...@df7cb.de escreveu:
Re: Fabrízio de Royes Mello 2014-06-25
CAFcNs+oAb8h-0w2vLEWj6R-Gv=xizgdBya3K=SCd_9Tjyo=z...@mail.gmail.com
javascript:;
On Wed, Jun 25, 2014 at 3:52 PM, Tom Lane t...@sss.pgh.pa.us
javascript:; wrote:
Would like
Em domingo, 31 de agosto de 2014, Peter Eisentraut pete...@gmx.net
escreveu:
On 8/31/14 12:40 AM, Dobes Vandermeer wrote:
The background workers can apparently only connect to a single database
at a time, but I want to expose all the databases via the API.
I think the term background
On Tue, August 26, 2014 14:24, Andrew Gierth wrote:
Erik == Erik Rijkers e...@xs4all.nl writes:
They apply cleanly for me at 2bde297 whether with git apply or
patch, except for the contrib one (which you don't need unless you
want to run the contrib regression tests without applying the
On Sun, Aug 31, 2014 at 9:07 PM, Erik Rijkers e...@xs4all.nl wrote:
On Tue, August 26, 2014 14:24, Andrew Gierth wrote:
Erik == Erik Rijkers e...@xs4all.nl writes:
They apply cleanly for me at 2bde297 whether with git apply or
patch, except for the contrib one (which you don't need
On 2014-08-31 21:09:59 +0530, Atri Sharma wrote:
On Sun, Aug 31, 2014 at 9:07 PM, Erik Rijkers e...@xs4all.nl wrote:
I have found that the unrecognized node type error is caused by:
It's a warning, not an error, right?
shared_preload_libraries = pg_stat_statements
in postgresql.conf (as
# actual new tmp installation
.tmp_install:
$(RM) ./.tmp_install.*
$(RM) -r ./tmp_install
# create tmp installation...
touch $@
# tmp installation for the nonce
.tmp_install.$(MAKE_NONCE): .tmp_install
touch $@
Oops, I got it wrong, the install
On Sunday, August 31, 2014, Andres Freund and...@2ndquadrant.com wrote:
On 2014-08-31 21:09:59 +0530, Atri Sharma wrote:
On Sun, Aug 31, 2014 at 9:07 PM, Erik Rijkers e...@xs4all.nl
javascript:; wrote:
I have found that the unrecognized node type error is caused by:
It's a warning, not
Bruce Momjian br...@momjian.us writes:
I have developed the attached patch to warn about column reordering in
this odd case. The patch mentions the reordering of c:
NOTICE: merging column a with inherited definition
NOTICE: merging column c with inherited definition; column
On 30 August 2014 18:24, Tom Lane t...@sss.pgh.pa.us wrote:
3. I am thinking about name - I don't think so varwidth_bucket is correct
-- in relation to name width_bucket ... what about range_bucket or
scope_bucket ?
Neither of those seem like improvements from here. I agree with the
Tom Lane-2 wrote
Bruce Momjian lt;
bruce@
gt; writes:
I have developed the attached patch to warn about column reordering in
this odd case. The patch mentions the reordering of c:
NOTICE: merging column a with inherited definition
NOTICE: merging column c with inherited
* Isn't X Y equivalent to network_scan_first(X) Y AND
network_scan_last(X) Y? Or at least close enough for selectivity
estimation purposes? Pardon my ignorance - I'm not too familiar with the
inet datatype - but how about just calling scalarineqsel for both bounds?
Actually, X Y is
Heikki Linnakangas hlinnakan...@vmware.com writes:
* inet_mcv_join_selec() is O(n^2) where n is the number of entries in
the MCV lists. With the max statistics target of 1, a worst case
query on my laptop took about 15 seconds to plan. Maybe that's
acceptable, but you went through
Simon Riggs si...@2ndquadrant.com writes:
Suggest discretize() as a much more informative name. The other names
will be overlooked by anybody that doesn't already know what to look
for.
I did not like that idea to begin with, but it's growing more attractive.
In particular, I think it would be
What you did there is utterly unacceptable from a modularity standpoint;
and considering that the values will be nowhere near right, the argument
that it's better than returning a constant seems pretty weak. I think
you should just take that out again.
I will try to come up with a better,
David G Johnston david.g.johns...@gmail.com writes:
Would it be proper to issue an additional top-level warning with the column
moved notification? Thus there would be NOTICE, NOTICE, WARNING in the
above example? Or, more generically, columns reordered to match inherited
column order to
Hi community,
while I am currently investigating why a certain table with highly redundant
and utterly verbose xml becomes worse storage wise when making the xml more
compact. Since i am quite new to this, I believe its the lz compression in the
text database. But thats irrelevant now, just
On 01/09/14 06:00, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
Suggest discretize() as a much more informative name. The other names
will be overlooked by anybody that doesn't already know what to look
for.
I did not like that idea to begin with, but it's growing more attractive.
On 30/08/14 19:24, Tom Lane wrote:
Pavel Stehule pavel.steh...@gmail.com writes:
1. I am thinking so reduction to only numeric types is not necessary -
although we can live without it - but there are lot of non numeric
categories: chars, date, ...
I wasn't terribly happy about that either. I
Another thought about this general topic:
Alvaro Herrera alvhe...@2ndquadrant.com writes:
...
Allowed actions on a RELKIND_PARTITION:
* CREATE INDEX .. ON PARTITION n ON TABLE xyz
...
Still To Be Designed
* Are indexes/constraints inherited from the parent rel?
I
Petr Jelinek p...@2ndquadrant.com writes:
On 30/08/14 19:24, Tom Lane wrote:
I wasn't terribly happy about that either. I still think we should
reduce this to a single polymorphic function, as in the attached.
I did try to write generic function very similar to what you wrote but
discarded
On 08/31/2014 10:03 PM, Tom Lane wrote:
Another thought about this general topic:
Alvaro Herrera alvhe...@2ndquadrant.com writes:
...
Allowed actions on a RELKIND_PARTITION:
* CREATE INDEX .. ON PARTITION n ON TABLE xyz
...
Still To Be Designed
* Are
On Fri, Aug 29, 2014 at 12:35:50PM -0400, Tom Lane wrote:
Each partition is assigned an Expression that receives a tuple and
returns boolean. This expression returns true if a given tuple belongs
into it, false otherwise.
-1, in fact minus a lot. One of the core problems of the current
On 31 August 2014 20:44, Gavin Flower gavinflo...@archidevsys.co.nz wrote:
On 01/09/14 06:00, Tom Lane wrote:
Simon Riggs si...@2ndquadrant.com writes:
Suggest discretize() as a much more informative name. The other names
will be overlooked by anybody that doesn't already know what to look
On 31/08/14 22:33, Tom Lane wrote:
Petr Jelinek p...@2ndquadrant.com writes:
On 30/08/14 19:24, Tom Lane wrote:
I wasn't terribly happy about that either. I still think we should
reduce this to a single polymorphic function, as in the attached.
I did try to write generic function very
Simon Riggs wrote
width_bucket() seems to refer to an equal-width binning process. The
function being discussed here is a generic mechanism, the boundaries
of which could have been decided using equal-frequency or other
mechanisms. Using the word width in those contexts could be
confusing.
Petr Jelinek p...@2ndquadrant.com writes:
On 31/08/14 22:33, Tom Lane wrote:
Petr Jelinek p...@2ndquadrant.com writes:
The difference between my generic and Tom's generic is because Tom's is
slowed down by the deconstruct_array.
Meh. It looked to me like your version would have O(N^2)
David G Johnston david.g.johns...@gmail.com writes:
Since bucket is the 'verb' here (in this specific case meaning lookup the
supplied value in the supplied bucket definition) and width is a modifier
(the bucket specification describes an equal-width structure) I suggest
literal_bucket(val,
On Sun, Aug 31, 2014 at 7:48 PM, Tom Lane t...@sss.pgh.pa.us wrote:
David G Johnston david.g.johns...@gmail.com writes:
Since bucket is the 'verb' here (in this specific case meaning lookup
the
supplied value in the supplied bucket definition) and width is a
modifier
(the bucket
On 08/31/2014 12:40 PM, Dobes Vandermeer wrote:
1. Connecting to multiple databases
The background workers can apparently only connect to a single database
at a time, but I want to expose all the databases via the API.
bgworkers are assigned a database at launch time (if SPI is enabled),
On Sun, Aug 31, 2014 at 10:10 AM, Peter Eisentraut pete...@gmx.net wrote:
On 8/30/14 2:26 AM, Jeff Janes wrote:
But there cases were people use COPY in a loop with a small amount of
data in each statement.
What would be the reason for doing that?
I used that to the same thing many times.
On 08/29/2014 04:59 AM, Kevin Grittner wrote:
I just took a quick look at the spec to refresh my memory, and it
seems to require that the WITH TIME ZONE types store UTC (I suppose
for fast comparisons), it requires the time zone in the form of a
hour:minute offset to be stored with it, so you
Adam, all,
* Brightwell, Adam (adam.brightw...@crunchydatasolutions.com) wrote:
Attached is a patch for RLS that was create against master at
01363beae52700c7425cb2d2452177133dad3e93 and is ready for review.
Many thanks for posting this. As others may realize already, I've
reviewed and
38 matches
Mail list logo