On Friday 28 August 2015 13:28:49 Alvaro Herrera wrote:
Andres Freund wrote:
On 2015-08-28 12:32:45 -0300, Alvaro Herrera wrote:
YUriy Zhuravlev wrote:
Hello Hackers
How would you react if I provided a patch which introduces a CMake
build
system?
What's your
On Tuesday 14 July 2015 11:33:34 Peter Geoghegan wrote:
On Sun, Jul 12, 2015 at 4:09 AM, Yourfriend doudou...@gmail.com wrote:
Suggestion: When a conflict was found for UPSERT, don't access the
sequence, so users can have a reasonable list of ID.
This is not technically feasible. What if
Oh well... then, THANKS GUYS!!!
I'm not the original poster, btw.
I felt a bit 'abandoned' a while back, since I started using
Interbase/Firebird since, like, ~2000. But since Firebird never really took
off, I felt I had to look for better solutions. I worked with Oracle for a
bit, and then
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
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
. 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
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
-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
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
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
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
(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
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
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
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
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
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
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
. 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
, 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
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
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
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
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
. 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
, 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
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
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
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
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
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
Dear Josh,
On Mon, Jan 05, 2009 at 05:12:27PM -0800, Josh Berkus wrote:
-- On-Disk Bitmap Index (Gianni says new patch in a week.)
while we are still working on the issues raised on pgsql-hackers, at
this point it looks like that we will not be able to resolve all of
them in time for the 8.4
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
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
the identical
substitution
review/(.*)nni \1nni
in my pg_ident.conf so that I can trigger regexps while connecting as
gianni.
To avoid removing all the standard lines from pg_hba.conf, I edited
postgresql.conf in order to make it listen from a different IP address
(actually
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
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
37 matches
Mail list logo
