[HACKERS] Enhanced containment selectivity function

2005-08-04 Thread Matteo Beccati
= ltree, PROCEDURE = ltree_risparent, COMMUTATOR = '@', RESTRICT = contstatsel, JOIN = contjoinsel ); Of course any comments/feedback are welcome. Best regards -- Matteo Beccati http://phpadsnew.com/ http://phppgads.com/ Index: src/backend/utils/adt/selfuncs.c

Re: [HACKERS] Enhanced containment selectivity function

2005-08-04 Thread Matteo Beccati
it depends on other functions declared in selfuncs.c (get_restriction_variable, etc). Thank you for your feedback Best regards -- Matteo Beccati http://phpadsnew.com/ http://phppgads.com/ ---(end of broadcast)--- TIP 4: Have you searched our

Re: [HACKERS] Enhanced containment selectivity function

2005-08-06 Thread Matteo Beccati
errors a few days ago (some cvs updates ago). Best regards -- Matteo Beccati http://phpadsnew.com/ http://phppgads.com/ Index: contrib/ltree/ltree.sql.in === RCS file: /projects/cvsroot/pgsql/contrib/ltree/ltree.sql.in,v retrieving

[HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-27 Thread Matteo Beccati
. Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-27 Thread Matteo Beccati
) at postmaster.c:943 #11 0x08131092 in main (argc=3, argv=0xbfbfed3c) at main.c:256 Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-27 Thread Matteo Beccati
(port=0x8361200) at postmaster.c:2498 #58 0x081ad86b in ServerLoop () at postmaster.c:1231 #59 0x081ad0eb in PostmasterMain (argc=3, argv=0xbfbfed3c) at postmaster.c:943 #60 0x08163962 in main (argc=3, argv=0xbfbfed3c) at main.c:256 Best regards -- Matteo Beccati http://phpadsnew.com http

Re: [HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-27 Thread Matteo Beccati
unable to produce a test case :( Lat me know what other I can do to help fixing the bug. Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-27 Thread Matteo Beccati
was actually useless because I removed the FOR UPDATE clause that was causing the deadlock, but the alloc error is still there. I'll try to search through the code to find some other subtransactions. Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com

Re: [HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-27 Thread Matteo Beccati
Hi Alvaro, It would be good to see the contents of MultiXactState. I suspect there's a race condition in the MultiXact code. Good, but... where do I find the contents of MultiXactState? ;) Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com

Re: [HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-27 Thread Matteo Beccati
= {nextMXact = 320308, nextOffset = 4235265, lastTruncationPoint = 302016, perBackendXactIds = {0}} Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-27 Thread Matteo Beccati
and with no errors until now. Thanks to Matteo for finding the bug! Thanks to you all for helping out and fixing it :) Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 1: if posting/reading

Re: [HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-27 Thread Matteo Beccati
if you need to test some other patches. Again, thank you Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-28 Thread Matteo Beccati
to be an alternative to it. Unfortunately it doesn't solve the invalid alloc request issue. Should I try Alvaro's second patch that you said not going to work? Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast

Re: [HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-28 Thread Matteo Beccati
Hi, Should I try Alvaro's second patch that you said not going to work? I'll add that this works for me, that's it prevents invalid alloc requests to show. Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast

Re: [HACKERS] ERROR: invalid memory alloc request size a_big_number_here

2005-10-28 Thread Matteo Beccati
:) Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

[HACKERS] Does EXPLAIN ANALYZE show a wrong plan for MIN/MAX?

2005-11-11 Thread Matteo Beccati
=1) - Seq Scan on stats_200511 stats (cost=0.00..1.04 rows=4 width=8) (actual time=0.028..0.041 rows=4 loops=1) Total runtime: 30692.627 ms (15 rows) Time: 30694.357 ms = Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com

Re: [HACKERS] Does EXPLAIN ANALYZE show a wrong plan for MIN/MAX?

2005-11-11 Thread Matteo Beccati
: times for the same query are 15s vs 63s with EXPLAIN ANALYZE. Of course I know 8.0 doesn't optimize min/max the same way 8.1 does. Hope this helps. Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP

Re: [HACKERS] Does EXPLAIN ANALYZE show a wrong plan for MIN/MAX?

2005-11-11 Thread Matteo Beccati
Tom Lane wrote: Martijn van Oosterhout kleptog@svana.org writes: On Fri, Nov 11, 2005 at 11:05:45AM +0100, Matteo Beccati wrote: It seems that the plan outputted is not the optimized one (available since 8.1) that is really used when running the plain query. It may also be that the overhead

Re: [HACKERS] MERGE vs REPLACE

2005-11-12 Thread Matteo Beccati
) VALUES (1, 1); SELECT * FROM t; +---+--+--+ | a | b| c| +---+--+--+ | 1 |1 | NULL | +---+--+--+ I wanted to point it out this because people are commonly mistaking this. Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com

Re: [HACKERS] PL/php in pg_pltemplate

2005-11-26 Thread Matteo Beccati
as writing a new PHP sapi (i.e. sapi/pgsql) which builds the .so without requiring Apache or other software. I've also seen there is an experimental embed sapi which could already be what you need (--enable-embed). Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com

Re: [HACKERS] PL/php in pg_pltemplate

2005-11-30 Thread Matteo Beccati
to be available since PHP 4.3.0: http://cvs.php.net/php-src/sapi/embed/php_embed.c Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http

Re: [HACKERS] Copyright

2006-03-05 Thread Matteo Beccati
Mark, After all - you wouldn't want somebody to say that PostgreSQL copied them, because the date was later, would you? :-) I think it won't be hard to understand what Copyright (c) 1996-2006 means ;) Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com

Re: [HACKERS] Enhanced containment selectivity function

2006-03-10 Thread Matteo Beccati
statistics would give a better result than using a constant selectivity. Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] @ versus ~, redux

2006-09-04 Thread Matteo Beccati
is a descendant of right argument (or equal). Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your

Re: [HACKERS] @ versus ~, redux

2006-09-06 Thread Matteo Beccati
@ and @ for future strict comparison operators. Since the choice of @ and @ comes from current ltree operators I'd like to point out that they are non-strict for ltree, and this could add a little bit of inconsistence. Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com

Re: [HACKERS] -HEAD planner issue wrt hash_joins on dbt3 ?

2006-09-18 Thread Matteo Beccati
) { recalculate_selectivity_matching_histogram_values() if (new_selectivity old_selectivity) return new_selectivity else return old_selectivity } Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 6: explain analyze is your

Re: [HACKERS] -HEAD planner issue wrt hash_joins on dbt3 ?

2006-09-18 Thread Matteo Beccati
Tom Lane ha scritto: Matteo Beccati [EMAIL PROTECTED] writes: I cannot see anything bad by using something like that: if (histogram is large/representative enough) Well, the question is exactly what is large enough? I feel a bit uncomfortable about applying the idea to a histogram with only

Re: [HACKERS] -HEAD planner issue wrt hash_joins on dbt3 ?

2006-09-20 Thread Matteo Beccati
now restoring a bigger database to get more reliable results. I hope Stefan can confirm the improvement on dbt3 too. Thanks Tom :) Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 1: if posting

Re: [HACKERS] -HEAD planner issue wrt hash_joins on dbt3 ?

2006-09-27 Thread Matteo Beccati
for l_orderkey? Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [HACKERS] regression in analyze

2008-11-06 Thread Matteo Beccati
mailing list and I couldn't find a reasonable explanation for it. Cheers -- Matteo Beccati OpenX - http://www.openx.org -- 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] regression in analyze

2008-11-07 Thread Matteo Beccati
an official anwser ;) Cheers -- Matteo Beccati OpenX - http://www.openx.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

[HACKERS] PQescapeByteaConn and the new hex encoding

2009-12-25 Thread Matteo Beccati
PQescapeByteaConn to honour it. Not sure if changing the current behaviour is at all possible, desirable and really worth it, but I'm going to hold the patches to the php test suite until I get some feedback here. Thoughts? Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent

Re: [HACKERS] PQescapeByteaConn and the new hex encoding

2009-12-25 Thread Matteo Beccati
a corner case though and it can be dealt with at the client side, if necessary. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

[HACKERS] PHP and PostgreSQL 8.5 compatibility

2009-12-25 Thread Matteo Beccati
the process[1]. This means that most of the PHP applications should work fine with 8.5 when running recent enough PHP versions. The few that are using both PDO and bytea fields will require a switch to 5.3 (or 5.2.13 whenever it comes out). [1] http://bugs.php.net/50575 Cheers -- Matteo

Re: [HACKERS] mailing list archiver chewing patches

2010-01-11 Thread Matteo Beccati
of the day, that is, because I have to take care of the other daughter). I'll be probably away for (at least) a week when she does; and I'll probably have somewhat of a shortage of spare time after that. BTW, congrats Alvaro! Cheers -- Matteo Beccati Development Consulting - http

Re: [HACKERS] mailing list archiver chewing patches

2010-01-11 Thread Matteo Beccati
to set up AOX and hook it up to a domain. An email account is now subscribed to the hackers ML. I'll try to estimate how hard it could be to write a web app that displays the archive from the db, even though I'm not sure that this is a good way to proceed. Cheers -- Matteo Beccati Development

Re: [HACKERS] mailing list archiver chewing patches

2010-01-11 Thread Matteo Beccati
this afternoon. It's not feature complete, nor probably very scalable, but at least it features attachment download ;) http://archives.beccati.org/pgsql-hackers/message/37 Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] planner or statistical bug on 8.5

2010-01-12 Thread Matteo Beccati
=# ANALYZE a; ANALYZE test=# EXPLAIN SELECT * from a; QUERY PLAN - Seq Scan on a (cost=0.00..14.80 rows=2400 width=4) (1 row) That said, 2400^3 (cross join of 3 tables) == 1382400 Cheers -- Matteo Beccati Development

Re: [HACKERS] mailing list archiver chewing patches

2010-01-12 Thread Matteo Beccati
can proceed with the evaluation if you think it's useful. I have a feeling that AOX is not truly the right tool for the job, but we might be able to customise it to suit our needs. Are there any other requirements that weren't specified? Cheers -- Matteo Beccati Development Consulting

Re: [HACKERS] mailing list archiver chewing patches

2010-01-12 Thread Matteo Beccati
, and it was less than 30 minutes of hacking. Can't seem to find the script ATM though, but you get the idea. Let's not focus on that part, we can easily solve that. Agreed. That's the part that worries me less. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via

Re: [HACKERS] mailing list archiver chewing patches

2010-01-12 Thread Matteo Beccati
wording wasn't right... I was more thinking about adding new tables, materialized views or whatever else might be missing to make it fit out purpose. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] mailing list archiver chewing patches

2010-01-13 Thread Matteo Beccati
into it. The link I've previously sent will most likely return a 500 error for the time being. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] mailing list archiver chewing patches

2010-01-14 Thread Matteo Beccati
Il 14/01/2010 08:22, Matteo Beccati ha scritto: Hi, 3) A nice set of SQL queries to return message, parts, threads, folders based on $criteria (search, id, folder, etc) I guess Matteo's working on that… Right, but this is where I want to see the AOX schema imporove... In ways like adding

Re: [HACKERS] mailing list archiver chewing patches

2010-01-14 Thread Matteo Beccati
arc_messages a USING (mailbox) WHERE t.uid = a.parent_uid ) SELECT * FROM t ORDER BY idx Any improvements to sorting are welcome :) Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] mailing list archiver chewing patches

2010-01-14 Thread Matteo Beccati
in the evening or tomorrow. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- 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] mailing list archiver chewing patches

2010-01-14 Thread Matteo Beccati
is the other way around, with newer posts/threads at the bottom. Again I'll give it a try as soon as I find time to work again on it. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] mailing list archiver chewing patches

2010-01-15 Thread Matteo Beccati
Hi everyone, Il 14/01/2010 19:36, David Fetter ha scritto: On Thu, Jan 14, 2010 at 03:08:22PM +0100, Matteo Beccati wrote: Il 14/01/2010 14:39, Dimitri Fontaine ha scritto: Matteo Beccatip...@beccati.com writes: Any improvements to sorting are welcome :) ... ARRAY[uid

Re: [HACKERS] mailing list archiver chewing patches

2010-01-16 Thread Matteo Beccati
, but I've able to reproduce the issue with a few days old backup running on a test 8.5alpha3 instance that still has a stock postgresql.conf. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] mailing list archiver chewing patches

2010-01-18 Thread Matteo Beccati
Il 16/01/2010 14:21, Matteo Beccati ha scritto: Il 16/01/2010 11:48, Dimitri Fontaine ha scritto: Matteo Beccatip...@beccati.com writes: Anyway, I've made further changes and I would say that at this point the PoC is feature complete. There surely are still some rough edges and a few things

Re: [HACKERS] mailing list archiver chewing patches

2010-01-18 Thread Matteo Beccati
on production (symfony/php vs django/python). Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- 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] mailing list archiver chewing patches

2010-01-18 Thread Matteo Beccati
the likeliness of an index scan. But I'm happy to examine other alternatives too. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org

Re: [HACKERS] mailing list archiver chewing patches

2010-01-19 Thread Matteo Beccati
for the layout part. By default symfony uses plain PHP files as templates, but some plugins allow using a templating engine instead. I guess I can give them a try. -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] WARNING: pgstat wait timeout

2010-01-21 Thread Matteo Beccati
works fin in that os I've seen it a few days ago with 8.5alpha3 on NetBSD when I left the backend running for a few days. Backend was completely inactive but the massage was repeated 3-4 times. Googling didn't help and I didnt' know how to replicate it. Cheers -- Matteo Beccati Development

Re: [HACKERS] mailing list archiver chewing patches

2010-01-30 Thread Matteo Beccati
) is implemented, but I just realized that it has problems dealing with the old archive weirdness (2009-12 shows also some messages dated aug 2009 nov 2009 or jan 2010 for -hackers). That said, there are still a few visual improvements to be done, but overall I'm pretty much satisfied. Cheers -- Matteo

Re: [HACKERS] mailing list archiver chewing patches

2010-01-30 Thread Matteo Beccati
On 30/01/2010 17:54, Alvaro Herrera wrote: Matteo Beccati wrote: Il 19/01/2010 09:44, Magnus Hagander ha scritto: As long as the templating is separated from the code, it doesn't matter if it's a dedicated templating engine or PHP. The point being, focus on the contents and interface, porting

Re: [HACKERS] mailing list archiver chewing patches

2010-01-31 Thread Matteo Beccati
, M156273, M156275 and I've verified that it also has happened before. I don't know why, but I'm pretty sure that my MTA was contacted only once for those messages, while normally I get two connections (my own address + aox address). Cheers -- Matteo Beccati Development Consulting - http

Re: [HACKERS] mailing list archiver chewing patches

2010-01-31 Thread Matteo Beccati
, I probably just need some directions ;) Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- 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] mailing list archiver chewing patches

2010-02-01 Thread Matteo Beccati
On 01/02/2010 03:27, Alvaro Herrera wrote: Matteo Beccati wrote: Incidentally, I've just found out that the mailing lists are dropping some messages. According to my qmail logs the AOX account never received Joe's message yesterday, nor quite a few others: M156252, M156259, M156262, M156273

Re: [HACKERS] mailing list archiver chewing patches

2010-02-01 Thread Matteo Beccati
linked to the grand-parent. Injecting the missing message afterwards will put it at the same level as its replies. If it happens only once in a while I guess we can live with it, but definitely not if it happens tens of times a day. Cheers -- Matteo Beccati Development Consulting - http

Re: [HACKERS] mailing list archiver chewing patches

2010-02-01 Thread Matteo Beccati
days, but I will see what I can do when I get back. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- 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] patternsel() and histogram_selectivity() and the hard cutoff of 100

2008-02-12 Thread Matteo Beccati
samples and up. Incidentally I hacked up a patch to do this: Sounds sensible to me, at least much more than a hardcoded magic number a few people know about... Cheers -- Matteo Beccati Openads - http://www.openads.org ---(end of broadcast

[HACKERS] DISCARD ALL failing to acquire locks on pg_listen

2009-02-11 Thread Matteo Beccati
. Cheers -- Matteo Beccati OpenX - http://www.openx.org -- 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] DISCARD ALL failing to acquire locks on pg_listen

2009-02-11 Thread Matteo Beccati
. Ok, I'll take sometime tonight to give my patch a try and eventually submit it. Cheers -- Matteo Beccati OpenX - http://www.openx.org -- 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] DISCARD ALL failing to acquire locks on pg_listen

2009-02-12 Thread Matteo Beccati
Note: DISCARD doesn't produce any debug output, because the guc variables are being reset before the Async_UnlistenAll is called. Cheers -- Matteo Beccati OpenX - http://www.openx.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] DISCARD ALL failing to acquire locks on pg_listen

2009-02-12 Thread Matteo Beccati
Tom Lane ha scritto: Matteo Beccati p...@beccati.com writes: Seems like we could/should fix UNLISTEN * to not do anything if it is known that the current backend never did any LISTENs. Here's my proposed patch, both for HEAD and 8.3: This seems a bit overcomplicated. I had in mind

Re: [HACKERS] DISCARD ALL failing to acquire locks on pg_listen

2009-02-12 Thread Matteo Beccati
fix :) Cheers -- Matteo Beccati OpenX - http://www.openx.org -- 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] Re: [BUGS] BUG #4689: Expanding the length of a VARCHAR column should not induce a table rewrite

2009-03-05 Thread Matteo Beccati
type definition were exactly the same (i.e. varchar(64)). I can live with it, but I suppose this fix might be related to the varlen one. Cheers -- Matteo Beccati OpenX - http://www.openx.org -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] New trigger option of pg_standby

2009-03-26 Thread Matteo Beccati
to know if they understand how it works now and if it's what they intended when they set it up. My fault not RTFM well enough, but I was surprised finding out that -t is working like that. +1 for me to switch -t to the new behaviour. Cheers -- Matteo Beccati OpenX - http://www.openx.org -- Sent

Re: [HACKERS] Incorrect behavior with CE and ORDER BY

2006-10-25 Thread Matteo Beccati
tried a few times to write a patch to handle it, but I wasn't able to do it because of my lack of internals knowledge and spare time. Best regards -- Matteo Beccati http://phpadsnew.com http://phppgads.com ---(end of broadcast)--- TIP 3: Have you

[HACKERS] ERROR: out of memory when using aggregates over a partitioned table

2009-05-04 Thread Matteo Beccati
=3130785 width=24) - Seq Scan on part_f foo (cost=0.00..60484.31 rows=3127231 width=24) Cheers -- Matteo Beccati http://www.openx.org/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] automating CF submissions (was xlog location arithmetic)

2012-01-17 Thread Matteo Beccati
back to our conversations about migrating archives to your stuff too. How confident with Django are you? I've never wrote a line of Python in my life, so someone else should work on porting the web part, I'm afraid... Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com

Re: [HACKERS] automating CF submissions (was xlog location arithmetic)

2012-01-17 Thread Matteo Beccati
On 17/01/2012 18:10, Matteo Beccati wrote: On 17/01/2012 17:50, Alvaro Herrera wrote: Excerpts from Matteo Beccati's message of mar ene 17 12:33:27 -0300 2012: My proof of concept archive for the hackers ML site is still online, in case anyone has trouble downloading the patches or just wants

Re: [HACKERS] automating CF submissions (was xlog location arithmetic)

2012-01-17 Thread Matteo Beccati
...@alvh.no-ip.org Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- 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] archives, attachments, etc

2010-10-29 Thread Matteo Beccati
to point this thread out. I've been overly busy lately and missed it. I'll try to debug what happens with your message formatting as soon as I can find some time. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Allow substitute allocators for PGresult.

2011-11-12 Thread Matteo Beccati
a pretty nice win. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- 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] pg_restore --no-post-data and --post-data-only

2011-11-13 Thread Matteo Beccati
the result of my script. The only little thing I've noticed is a missing ending ) in the --help message. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] uuid-ossp (Re: [pgsql-packagers] Postgresapp 9.4 beta build ready)

2014-05-22 Thread Matteo Beccati
keep the extension name? If not, what would be the plan? - the patch also uses BSD's own md5 and sha1 implementations: for md5 I should be able to use pg's own core version, but I'm not sure about sha1, as it lives in pgcrypto. Any suggestion? Cheers -- Matteo Beccati Development Consulting - http

Re: [HACKERS] uuid-ossp (Re: [pgsql-packagers] Postgresapp 9.4 beta build ready)

2014-05-23 Thread Matteo Beccati
On 22/05/2014 21:55, Matteo Beccati wrote: On 22/05/2014 17:07, Tom Lane wrote: Well, *I* don't want to do that work. I was hoping to find a volunteer, but the silence has been notable. I think deprecation is the next step. This sounds an easy enough task to try and submit a patch, if I'm

Re: [HACKERS] uuid-ossp (Re: [pgsql-packagers] Postgresapp 9.4 beta build ready)

2014-05-23 Thread Matteo Beccati
On 23/05/2014 10:05, Matteo Beccati wrote: You can find the code here: https://github.com/mbeccati/uuid # NetBSD variant https://github.com/mbeccati/uuid/tree/linux # Ubuntu variant For now, I've forked just RhodiumToad's uuid-freebsd extension, but I've made sure make works fine when

Re: [HACKERS] [PATCH] Replacement for OSSP-UUID for Linux and BSD

2014-05-25 Thread Matteo Beccati
Hi Tom, thanks for the feedback. On 25/05/2014 21:10, Tom Lane wrote: Matteo Beccati p...@beccati.com writes: here's the latest version of my uuid changes patch, according to proposal (2) from Tom in the thread about OSSP-UUID[1]. Hmm ... this is not actually what I had in mind. Unless

Re: [HACKERS] [PATCH] Replacement for OSSP-UUID for Linux and BSD

2014-05-26 Thread Matteo Beccati
On 26/05/2014 19:31, Andres Freund wrote: On 2014-05-26 13:25:49 -0400, Tom Lane wrote: Matteo Beccati p...@beccati.com writes: I'm attaching v2 of the patch. Here's a list of changes from v1: * Restored --with-ossp-uuid. Configure tries ossp support first, then falls back to Linux and BSD

Re: [HACKERS] [PATCH] Replacement for OSSP-UUID for Linux and BSD

2014-05-27 Thread Matteo Beccati
it's safe to hardcode 13 as the argument is ignored anyway with ossp, so I've fixed that. I've also fixed v1mc generation on linux to match the OSSP and BSD variants and added a regression test for it. Cheers -- Matteo Beccati Development Consulting - http://www.beccati.com/ diff --git a/contrib

Re: [HACKERS] [PATCH] Replacement for OSSP-UUID for Linux and BSD

2014-05-27 Thread Matteo Beccati
Hi Tom, On 27/05/2014 15:52, Tom Lane wrote: Matteo Beccati p...@beccati.com writes: On 27/05/2014 03:07, Tom Lane wrote: I do not have a machine on which to try --with-bsd-uuid, so it's possible I broke that portion of Matteo's patch. Would someone try that case on a FreeBSD box? I've

Re: [HACKERS] kqueue

2016-09-14 Thread Matteo Beccati
. FWIW, I've tested HEAD vs patch on a 2-cpu low end NetBSD 7.0 i386 machine. HEAD: 1890/1935/1889 tps kqueue: 1905/1957/1932 tps no weird surprises, and basically no differences either. Cheers -- Matteo Beccati Development & Consulting - http://www.beccati.com/ -- Sent via pgsql-hac

Re: [HACKERS] kqueue

2016-09-20 Thread Matteo Beccati
% vs fairly recent HEAD (same as my last pgbench runs). Cheers -- Matteo Beccati Development & Consulting - http://www.beccati.com/ -- 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] jsonb problematic operators

2016-12-16 Thread Matteo Beccati
to the actual escape method to use. Cheers -- Matteo Beccati Development & Consulting - http://www.beccati.com/ -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers