On Tue, Jun 25, 2019 at 11:52:28PM -0400, Tom Lane wrote:
I'm seeing a reproducible bus error here:
#0 0x00417420 in statext_mcv_serialize (mcvlist=0x62223450, stats=Variable
"stats" is not available.
)
at mcv.c:785
785 memcpy(ITEM_BASE_FREQUENCY(item, ndims),
&mcvitem-
Hello!
\c is followed by [-reuse-previous=on/off] positional syntax | conninfo
Using \c -reuse-previous=on positional syntax or \c positional syntax without
-reuse-previous option, some parameters which were omitted or notated as "-"
will be reused in the new connection.
The target is only "dbna
Hello all.
First, I'd like to appreciate with all your reviewing and discussion in the
last CommitFest[1].
I don't think that the rest one of my proposals has been rejected completely,
so I want to restart discussion.
It is a timeout parameter in interfaces/libpq.
Consider some situations whe
On 6/12/19 10:29 AM, Jamison, Kirk wrote:
>
>> From a user POW, the main issue with relation truncation is that it can block
>> queries on standby server during truncation replay.
>>
>> It could be interesting if you can test this case and give results of your
>> path.
>> Maybe by performing read
On Wed, Jun 26, 2019 at 6:32 PM Andrew Gierth
wrote:
> Pacific/Auckland -> NZ
Right. On a FreeBSD system here in New Zealand you get "NZ" with
default configure options (ie using PostgreSQL's tzdata). But if you
build with --with-system-tzdata=/usr/share/zoneinfo you get
"Pacific/Auckland", and
Dear GSoD PostgreSQL Organization Administrators,
I am a PhD Student in Istanbul Technical University, Computer Engineering.
Before the being full-time researcher in the laboratory, I was full-stack
software developer. Therefore, I am strongly familiar the SQL queries. Also,
specially, I used P
Hello
This is my first posting to hackers so sorry if I'm taking up valuable time.
I'm currently migrating a packaged application which supported oracle and sql
server to PostgreSQL.
Something that I've identified as hurting the performance a lot is loose index
scanning. I don't have access to
> On Wed, Jun 26, 2019 at 1:53 PM pguser wrote:
>
> If I apply the latest patch (which says 1 of 2? - maybe I'm missing a part of
> the patch?), I apply with
Hi,
First of all, thanks for evaluation!
> psql (12beta2)
> Type "help" for help.
>
> db1=> show enable_indexskipscan;
> enable_indexski
On Wed, 5 Jun 2019 at 17:22, Juan José Santamaría Flecha <
juanjo.santama...@gmail.com> wrote:
>
> On Wed, May 29, 2019 at 10:30 AM Haribabu Kommi
> wrote:
>
>>
>> Updated patches are attached.
>>
>>
> All patches apply, build and pass tests. The patch
> '0001-support-building-with-visual-studio-
> "Thomas" == Thomas Munro writes:
>> Pacific/Auckland -> NZ
Thomas> Right. On a FreeBSD system here in New Zealand you get "NZ"
Thomas> with default configure options (ie using PostgreSQL's tzdata).
Thomas> But if you build with --with-system-tzdata=/usr/share/zoneinfo
Thomas> you get
On 2019-06-25 15:39, Robert Haas wrote:
> On Tue, Jun 25, 2019 at 8:28 AM Peter Eisentraut
> wrote:
>> How are the requirements here different from ssl_passphrase_command?
>> Why do we need a new mechanism?
>
> I don't think that the requirements are different, and I don't think
> we need a new m
Tomas Vondra writes:
> On Tue, Jun 25, 2019 at 11:52:28PM -0400, Tom Lane wrote:
>> You can *not* cast something to an aligned pointer type if it's not
>> actually certain to be aligned suitably for that type.
> OK. So the solution is to ditch the casts altogether, and then do plain
> pointer ari
On Wed, Jun 26, 2019 at 09:49:46AM +0200, Tomas Vondra wrote:
On Tue, Jun 25, 2019 at 11:52:28PM -0400, Tom Lane wrote:
I'm seeing a reproducible bus error here:
#0 0x00417420 in statext_mcv_serialize (mcvlist=0x62223450, stats=Variable
"stats" is not available.
)
at mcv.c:785
785
‐‐‐ Original Message ‐‐‐
On Wednesday, June 26, 2019 1:07 PM, Dmitry Dolgov <9erthali...@gmail.com>
wrote:
> > On Wed, Jun 26, 2019 at 1:53 PM pguser pgu...@diorite.uk wrote:
> > If I apply the latest patch (which says 1 of 2? - maybe I'm missing a part
> > of the patch?), I apply with
‐‐‐ Original Message ‐‐‐
On Wednesday, June 26, 2019 2:55 PM, pguser wrote:
> ‐‐‐ Original Message ‐‐‐
> On Wednesday, June 26, 2019 1:07 PM, Dmitry Dolgov 9erthali...@gmail.com
> wrote:
>
> > > On Wed, Jun 26, 2019 at 1:53 PM pguser pgu...@diorite.uk wrote:
> > > If I apply th
Hi all,
We have been using RAND_OpenSSL(), a function new as of OpenSSL 1.1.0
in pgcrypto until fe0a0b5 which has removed the last traces of the
function in the tree. We still have a configure check for it and the
related compilation flag in pg_config.h.in, and both are now useless.
Any objectio
> On 26 Jun 2019, at 16:25, Michael Paquier wrote:
> Any objections to the cleanup done in the attached patch?
None, LGTM.
cheers ./daniel
Michael Paquier writes:
> We have been using RAND_OpenSSL(), a function new as of OpenSSL 1.1.0
> in pgcrypto until fe0a0b5 which has removed the last traces of the
> function in the tree. We still have a configure check for it and the
> related compilation flag in pg_config.h.in, and both are no
On Wed, Jun 26, 2019 at 02:12:55PM +, pguser wrote:
‐‐‐ Original Message ‐‐‐
On Wednesday, June 26, 2019 2:55 PM, pguser wrote:
‐‐‐ Original Message ‐‐‐
On Wednesday, June 26, 2019 1:07 PM, Dmitry Dolgov 9erthali...@gmail.com wrote:
> > On Wed, Jun 26, 2019 at 1:53 PM pgu
Tomas Vondra writes:
> Attached is a patch that should (hopefully) fix this. It essentially
> treats the item as (char *) and does all pointer arithmetics without any
> additional casts. So there are no intermediate casts.
This passes the eyeball test, and it also allows my OpenBSD/hppa
installat
‐‐‐ Original Message ‐‐‐
On Wednesday, June 26, 2019 4:07 PM, Tomas Vondra
wrote:
> That might be dangerous, if there may be differences in contents of
> catalogs. I don't think the patch does that though, and for me it works
> just fine. I can initdb database using current master, cre
On Wed, Jun 26, 2019 at 11:26:21AM -0400, Tom Lane wrote:
Tomas Vondra writes:
Attached is a patch that should (hopefully) fix this. It essentially
treats the item as (char *) and does all pointer arithmetics without any
additional casts. So there are no intermediate casts.
This passes the ey
Tomas Vondra writes:
> On Wed, Jun 26, 2019 at 11:26:21AM -0400, Tom Lane wrote:
>> #define SizeOfMCVList(ndims,nitems) \
>> is both woefully underdocumented and completely at variance with
>> reality. It doesn't seem to be accounting for the actual data values.
> I agree about the macro being
Andrew Gierth writes:
> "Thomas" == Thomas Munro writes:
> Thomas> Right. On a FreeBSD system here in New Zealand you get "NZ"
> Thomas> with default configure options (ie using PostgreSQL's tzdata).
> Thomas> But if you build with --with-system-tzdata=/usr/share/zoneinfo
> Thomas> you get "P
Further on this --- I now remember that the reason we used to want to
reject the "Factory" timezone is that it used to report this as the
zone abbreviation:
Local time zone must be set--see zic manual page
which (a) resulted in syntactically invalid timestamp output from the
timeofday() f
Hi
po 24. 6. 2019 v 10:28 odesílatel Anthony Nowocien
napsal:
> Hi,
> patch no longer applies (as of 12beta2).
>
> postgres@ubuntudev:~/pg_testing/source/postgresql-12beta2$ patch -p1 <
> drop-database-force-20190310_01.patch
> patching file doc/src/sgml/ref/drop_database.sgml
> patching file do
Greg Stark writes:
> Actually thinking about this for two more seconds the question is what it
> would do with a query like
> WHERE col = ANY '1,2,3'::integer[]
> Or
> WHERE col = ANY ARRAY[1,2,3]
> Whichever the language binding that is failing to do parameterized queries
> is doing to emulate th
Here is a v3 which fixes \errverbose, hopefully.
V5 is a rebase and an slightly improved documentation.
It was really v4. v5 is a rebase.
--
Fabien.diff --git a/doc/src/sgml/ref/psql-ref.sgml b/doc/src/sgml/ref/psql-ref.sgml
index c6c20de243..a7557af0fe 100644
--- a/doc/src/sgml/ref/psql-re
Hi Nikolay,
> On 3 Apr 2019, at 20:54, Nikolay Shaplov wrote:
>
> В письме от вторник, 19 марта 2019 г. 16:09:13 MSK пользователь Michael
> Paquier написал:
>
>> Thanks for doing the effort to split that stuff. This looks like an
>> interesting base template for anybody willing to look after
On Wed, Jun 26, 2019 at 12:31:13PM -0400, Tom Lane wrote:
Tomas Vondra writes:
On Wed, Jun 26, 2019 at 11:26:21AM -0400, Tom Lane wrote:
#define SizeOfMCVList(ndims,nitems) \
is both woefully underdocumented and completely at variance with
reality. It doesn't seem to be accounting for the
> "Tom" == Tom Lane writes:
Tom> No zone1970.tab.
zone.tab is an adequate substitute - a fact which I thought was
sufficiently obvious as to not be worth mentioning.
(also see https://reviews.freebsd.org/D20646 )
Tom> I do not think we can rely on that file being there, since zic
Tom> i
> On 27 Jun 2019, at 00:48, Andrew Gierth wrote:
> Tom> In general, the point I'm trying to make is that our policy should
> Tom> be "Ties are broken arbitrarily, and if you don't like the choice
> Tom> that initdb makes, here's how to fix it".
>
> Yes, you've repeated that point at some length,
On Mon, 17 Jun 2019 at 15:05, Tsunakawa, Takayuki
wrote:
> (1)
> +#define LOCKMETHODLOCALHASH_SHRINK_SIZE 64
>
> How about LOCKMETHODLOCALHASH_SHRINK_THRESHOLD, because this determines the
> threshold value to trigger shrinkage? Code in PostgreSQL seems to use the
> term threshold.
That's prob
Thomas Munro writes:
> While looking at bug #15857[1], I wondered why the following two
> queries get different plans, given the schema and data from the bug
> report:
> ...
> Here's my question: how could it ever be OK to sort/unique something
> and put it in a hash table, but not OK to put exact
On Wed, Jun 26, 2019 at 04:35:43PM +0200, Daniel Gustafsson wrote:
> None, LGTM.
Thanks, committed.
--
Michael
signature.asc
Description: PGP signature
Greetings,
* Daniel Gustafsson (dan...@yesql.se) wrote:
> > On 27 Jun 2019, at 00:48, Andrew Gierth wrote:
>
> > Tom> In general, the point I'm trying to make is that our policy should
> > Tom> be "Ties are broken arbitrarily, and if you don't like the choice
> > Tom> that initdb makes, here's h
From: David Rowley [mailto:david.row...@2ndquadrant.com]
v5 is attached.
Thank you, looks good. I find it ready for committer (I noticed the status is
already set so.)
Regards
Takayuki Tsunakawa
Andres Freund writes:
> On 2019-02-14 09:52:33 +1300, Thomas Munro wrote:
>> Just to make sure I understand: it's OK for the file not to be there
>> when we try to fsync it by name, because a concurrent checkpoint can
>> remove it, having determined that we don't need it anymore? In other
>> word
Hello,
On Tue, Jun 25, 2019 at 1:45 PM yuzuko wrote:
>
> Hello Shawn, Alvaro,
>
> Thank you for testing patches and comments.
> Yes, there are two patches:
> (1) v4_default_partition_pruning.patch fixes problems with default
> partition pruning
> and (2) v3_ignore_contradictory_where_clauses_at_p
=?UTF-8?Q?Darafei_=22Kom=D1=8Fpa=22_Praliaskouski?= writes:
> I'm looking at PostGIS geometry GiST index build times and try to optimize
> withing the current GiST framework. The function that shows a lot on my
> flame graphs is penalty.
> I spent weekend rewriting PostGIS penalty to be as fast a
Hi
We are facing an issue where the cost shows up "cost=100.00" so
trying to find where that is set.
Could anyone point me to the code where the cost "cost=100.00" is
set?
It doesn't show up when searching through find.
find . -type f -print | xargs grep 100 | grep -v "/
AminPG Jaffer writes:
> We are facing an issue where the cost shows up "cost=100.00" so
> trying to find where that is set.
That means you've turned off enable_seqscan (or one of its siblings)
but the planner is choosing a seqscan plan (or other plan type you
tried to disable) anyway beca
Tomas Vondra writes:
> OK. Attached is a patch ditching the alignment in serialized data. I've
> ditched the macros to access parts of serialized data, and everything
> gets copied.
I lack energy to actually read this patch right now, and I don't currently
have an opinion about whether it's worth
Deja vu from this time last year when despite everyone's best efforts
(mostly Alvaro) we missed getting run-time pruning in for MergeAppend
into the PG11 release. This year it was ModifyTable, which is now
possible thanks to Amit and Tom's modifications to the inheritance
planner.
I've attached
Hi Andres,
On Wed, May 29, 2019 at 1:50 PM Pavan Deolasee
wrote:
>
>
> On Tue, 28 May 2019 at 4:36 PM, Andres Freund wrote:
>
>> Hi,
>>
>> On 2019-04-07 18:04:27 -0700, Andres Freund wrote:
>> > Here's a *prototype* patch for this. It only implements what I
>> > described for heap_multi_insert
I wrote:
> > I found a possible other way to bring the size of the transition table
> > under 32k entries while keeping the existing no-backup rules in place:
> > Replace the "quotecontinue" rule with a new state. In the attached
> > draft patch, when Flex encounters a quote while inside any kind
Alexander Lakhin detected the bug in the 'remove self joins' patch:
test:
=
CREATE TABLE t (a INT UNIQUE);
INSERT INTO t VALUES (1);
SELECT 1 FROM (SELECT x.* FROM t AS x, t AS y WHERE x.a = y.a) AS q,
LATERAL generate_series(1, q.a) gs(i);
Description:
FUNCTIONS, TABLEFUNCS
47 matches
Mail list logo
