[HACKERS] Bitmap Indexes: request for feedback

2008-10-21 Thread Gianni Ciolli
Hi everybody, me and Gabriele Bartolini have been working on Bitmap Indexes (BMI) in the last weeks, with advice and guidance from Simon Riggs. We feel that we are about to approach the point where it is appropriate to ask for feedback from this list. Thank you, Dr. Gianni Ciolli - 2ndQuadrant

Re: Bitmap Indexes patch (was Re: [HACKERS] Bitmap Indexes: request for feedback)

2008-11-04 Thread Gianni Ciolli
the performance. Unfortunately, I have spent more than a day with almost void success. This can be helpful for us to explain one of the two open issues that we mentioned at submission time (meanwhile we have just fixed the other one): On Sat, Nov 01, 2008 at 01:01:54AM +0100, Gianni Ciolli wrote

Re: [HACKERS] usermap regexp support

2008-11-05 Thread Gianni Ciolli
the other IP address of my machine 192.168...). Then I added to pg_hba.conf one line enabling ident connections with map=review from that IP address. Finally I started the server, and as I connected with psql -h 192.168... the above warning showed. Best regards, Dr. Gianni Ciolli - 2ndQuadrant

Re: [HACKERS] Bitmap index - first look

2008-11-07 Thread Gianni Ciolli
for the useful remarks on the catalog); best regards, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support [EMAIL PROTECTED] | www.2ndquadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

[REVIEW] (was Re: [HACKERS] usermap regexp support)

2008-11-25 Thread Gianni Ciolli
On Tue, Nov 11, 2008 at 02:59:01PM +0100, Magnus Hagander wrote: Gianni Ciolli wrote: WARNING: detected write past chunk end in Postmaster 0x9b13650 Yes, that's a stupid bug: (...) Attached is an updated version of the patch that fixes this. Hi Magnus, please find below the review

Re: [HACKERS] Hot standby?

2009-08-11 Thread Gianni Ciolli
. IMHO the other case is preferrable, as the word sets synchronous/asynchronous and cold/warm/hot are more expressive because they measure two independent properties. Best regards, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it

Re: [HACKERS] Hot standby?

2009-08-11 Thread Gianni Ciolli
, they are currently discouraged by the documentation). Best regards, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it | www.2ndquadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Hot standby?

2009-08-11 Thread Gianni Ciolli
On Wed, Aug 12, 2009 at 12:11:28AM +0300, Peter Eisentraut wrote: On Tuesday 11 August 2009 18:16:04 Gianni Ciolli wrote: As for warm/hot, it depends on what you exactly mean with get ready: (A) If you mean it is possible to connect to the second node, then Simon's patch is hot

Re: [HACKERS] Time to finalize patches for 8.4 beta

2009-01-11 Thread Gianni Ciolli
release; thus we prefer to withdraw the patch from the current commitfest. We will update the corresponding Wiki page as soon as possible, although not immediately (I am experiencing some connectivity problems). Best regards, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services

[HACKERS] FATAL: could not open relation pg_tblspc/491086/467369/491103: No such file or directory

2009-01-16 Thread Gianni Ciolli
applied, is likely to be something to do with the guts of checkpointing. Best regards, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it | www.2ndquadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] FATAL: could not open relation pg_tblspc/491086/467369/491103: No such file or directory

2009-01-16 Thread Gianni Ciolli
On Fri, Jan 16, 2009 at 06:39:11PM +0100, Gianni Ciolli wrote: (...) During a Warm Standby session using current HEAD I obtained the following error on the standby node: On Fri, Jan 16, 2009 at 12:56:59PM -0500, Tom Lane wrote: Gianni Ciolli gianni.cio...@2ndquadrant.it writes: we found

Re: [HACKERS] Optimization rules for semi and anti joins

2009-02-11 Thread Gianni Ciolli
you, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it | www.2ndquadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] HotStandby vs. flatfile updates

2009-02-11 Thread Gianni Ciolli
know that Simon is having some difficulties with git). Thank you for testing, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it | www.2ndquadrant.it ---8--8--8--8--8--8--8--8--8--- STANDBY: try to connect

Re: [HACKERS] Autonomous subtransactions

2012-01-04 Thread Gianni Ciolli
the difference. Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it | www.2ndquadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Triggers with DO functionality

2012-02-22 Thread Gianni Ciolli
(such as replace the third trigger with ... or move trigger #4 in position #2, or deciding their order of execution). Cheers, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it | www.2ndquadrant.it -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Triggers with DO functionality

2012-02-23 Thread Gianni Ciolli
On Thu, Feb 23, 2012 at 08:26:47AM +, Thom Brown wrote: On 23 February 2012 07:15, Gianni Ciolli gianni.cio...@2ndquadrant.it wrote: Another complication: anonymous triggers would either have to be alone, or provide a mechanism to manage a sequence of anonymous triggers on the same

Re: [HACKERS] State of the on-disk bitmap index

2012-09-05 Thread Gianni Ciolli
. Regarding to the wiki, you, Jonah and Simon, were the last devs that touched this thing. Unfortunately I could not find the patch representing your state of that work. I could only capture the development history up to Gianni Ciolli Gabriele Bartolini from the old pgsql-patches

Re: [HACKERS] State of the on-disk bitmap index

2012-09-05 Thread Gianni Ciolli
Hi Daniel, On Wed, Sep 05, 2012 at 01:37:59PM +0200, Daniel Bausch wrote: Is that, what your bmi-perf-test.tar.gz from 2008 does? I did not look into that. IIRC yes (but it's been a long time and I don't have a copy at hand now). Best regards, Dr. Gianni Ciolli - 2ndQuadrant Italia

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

2012-03-24 Thread Gianni Ciolli
happened in the review phase. Some comments have also been added to explain why some choices have been forbidden. Best regards, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it | www.2ndquadrant.it ---8--8--8--8--8--8--8

[HACKERS] Dump EXTENSION sequences too

2012-04-19 Thread Gianni Ciolli
to the case when get_rel_name can't find a relation. Is there any objection to the above proposal? I did a little search of the archives, but I couldn't find any related discussions; I apologise if I missed something. Thanks, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

2012-06-17 Thread Gianni Ciolli
-to-many. In the aggregated model, you can easily specify a CHECK constraint that requires each polygon to have at least three points, while the corresponding condition cannot be specified in the non-aggregated model. Cheers, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support

Re: [HACKERS] [PATCH] Support for foreign keys with arrays

2011-11-20 Thread Gianni Ciolli
CASCADE and ON DELETE CASCADE. Thanks, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it | www.2ndquadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

[HACKERS] Autonomous subtransactions

2011-12-18 Thread Gianni Ciolli
and contributions, rather than a conclusive document. Thanks, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it | www.2ndquadrant.it p.s. The reason for the variation on the name is that there is always a parent transaction. -- Sent via pgsql

Re: [HACKERS] Autonomous subtransactions

2011-12-19 Thread Gianni Ciolli
On Mon, Dec 19, 2011 at 05:52:40PM +0200, Marti Raudsepp wrote: On Sun, Dec 18, 2011 at 10:28, Gianni Ciolli gianni.cio...@2ndquadrant.it wrote:  http://wiki.postgresql.org/wiki/Autonomous_subtransactions It is meant to be an ongoing project, requesting comments and contributions, rather

Re: [HACKERS] Autonomous subtransactions

2011-12-19 Thread Gianni Ciolli
match, otherwise an exception is raised (and a bug is detected). Regards, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it | www.2ndquadrant.it -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

[HACKERS] maximum digits for NUMERIC

2011-03-11 Thread Gianni Ciolli
Hi, maybe we should change the 1000 digits here: http://developer.postgresql.org/pgdocs/postgres/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL because ISTM that up to 2^17 digits are supported (which makes more sense than 1000). Best regards, Dr. Gianni Ciolli - 2ndQuadrant Italia

Re: [HACKERS] maximum digits for NUMERIC

2011-03-11 Thread Gianni Ciolli
On Fri, Mar 11, 2011 at 09:38:03AM -0500, Tom Lane wrote: Gianni Ciolli gianni.cio...@2ndquadrant.it writes: maybe we should change the 1000 digits here: http://developer.postgresql.org/pgdocs/postgres/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL because ISTM that up to 2^17

Re: [HACKERS] maximum digits for NUMERIC

2011-03-25 Thread Gianni Ciolli
On Sun, Mar 20, 2011 at 08:14:21PM -0400, Noah Misch wrote: On Fri, Mar 11, 2011 at 11:36:14AM +, Gianni Ciolli wrote: maybe we should change the 1000 digits here: http://developer.postgresql.org/pgdocs/postgres/datatype-numeric.html#DATATYPE-NUMERIC-DECIMAL because ISTM

Re: [HACKERS] maximum digits for NUMERIC

2011-03-25 Thread Gianni Ciolli
On Fri, Mar 25, 2011 at 08:46:17AM +, Gianni Ciolli wrote: On Sun, Mar 20, 2011 at 08:14:21PM -0400, Noah Misch wrote: Agreed. The documentation is suggestive of this limit: # CREATE TABLE n (c numeric(1001,0)); ERROR: NUMERIC precision 1001 must be between 1 and 1000 LINE 1

Re: [HACKERS] maximum digits for NUMERIC

2011-04-01 Thread Gianni Ciolli
. In particular, numeric limits are now correct and documented only in that table. Best regards, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it | www.2ndquadrant.it diff --git a/doc/src/sgml/datatype.sgml b/doc/src/sgml/datatype.sgml index

Re: [HACKERS] Transforming IN (...) to ORs, volatility

2011-04-01 Thread Gianni Ciolli
, while (random_boolean() = true) OR (random_boolean() = false) is not (has probability 75%). For instance, the first random_boolean() might return false while the second one returns true. Best regards, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio

[HACKERS] Proposed fix for NOTIFY performance degradation

2011-04-23 Thread Gianni Ciolli
Hi, while measuring NOTIFY execution time, I noticed a significant performance drop. Please find a patch attached, together with some tests; more details are shown below. Best regards, Dr. Gianni Ciolli - 2ndQuadrant Italia PostgreSQL Training, Services and Support gianni.cio...@2ndquadrant.it

[HACKERS] typo: XIDs are actually compared using modulo-2^32 arithmetic

2013-12-12 Thread Gianni Ciolli
Hi, It seems there is a typo here: http://www.postgresql.org/docs/devel/static/routine-vacuuming.html#VACUUM-FOR-WRAPAROUND where we say that we compare XIDs using arithmetic modulo 2^31, which should instead be 2^32 (as it is with uint32, e.g. xid_age). Best wishes, Dr. Gianni Ciolli

Re: [HACKERS] Why data of timestamptz does not store value of timezone passed to it?

2014-08-29 Thread Gianni Ciolli
myself to write a draft of that). Please notice that smallint is too small for tzoffset: SELECT d AT TIME ZONE 'Europe/Berlin' - d AT TIME ZONE 'Europe/Paris' FROM ( VALUES (date '1815-10-31') , (date '1897-02-19') ) AS f(d); Cheers, Dr. Gianni Ciolli - 2ndQuadrant