Re: [HACKERS] [GENERAL] pg_dump -s dumps data?!

2012-01-31 Thread Martijn van Oosterhout
day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts. -- Arthur Schopenhauer signature.asc Description: Digital signature

Re: [HACKERS] Add SPI results constants available for PL/*

2012-01-06 Thread Martijn van Oosterhout
{ print };\n; } print \t$1 = $2,\n if /#define (SPI_\S+)\s+\(?(-?\d+)\)?/;' src/include/executor/spi.h Well, there's also h2ph, but that may be overkill... Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses

Re: [HACKERS] 16-bit page checksums for 9.2

2011-12-25 Thread Martijn van Oosterhout
in performence. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts. -- Arthur Schopenhauer signature.asc Description: Digital signature

Re: [HACKERS] Page Checksums

2011-12-21 Thread Martijn van Oosterhout
with seqscans I have no idea. Certainly I think we could look to them for implementation ideas, but I don't imagine they've got something that can't be specialised for better performence. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes

Re: [HACKERS] WIP: URI connection string support for libpq

2011-12-14 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts. -- Arthur Schopenhauer signature.asc Description: Digital signature

Re: [HACKERS] Patch: add timing of buffer I/O requests

2011-11-28 Thread Martijn van Oosterhout
timer), but it's the fastest (IME) that gives guarenteed monotonic time. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts. -- Arthur

Re: [HACKERS] Notes on implementing URI syntax for libpq

2011-11-23 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts. -- Arthur Schopenhauer signature.asc Description: Digital signature

Re: [HACKERS] Inlining comparators as a performance optimisation

2011-11-18 Thread Martijn van Oosterhout
think anyone has written a proof of concept for this. It does have the advantage of scaling better than coding a qsort for each individual type. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset

Re: [HACKERS] Syntax for partitioning

2011-11-14 Thread Martijn van Oosterhout
On Mon, Nov 14, 2011 at 10:33:36AM +0100, Dimitri Fontaine wrote: Martijn van Oosterhout klep...@svana.org writes: While I agree that explicit partitioning is somewhat of a hack, it's a really useful hack. But for me the most important use of partitioning is dropping a billion rows

Re: [HACKERS] strict aliasing (was: const correctness)

2011-11-14 Thread Martijn van Oosterhout
Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts. -- Arthur Schopenhauer signature.asc Description: Digital signature

Re: [HACKERS] Syntax for partitioning

2011-11-12 Thread Martijn van Oosterhout
drives you to the latter can't be solved with the former. I hope so, but I'm not sure I'd like partitioning support to wait on someone hitting on the right idea. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby

[HACKERS] Re: [GENERAL] Strange problem with create table as select * from table;

2011-11-05 Thread Martijn van Oosterhout
was true when the code was written, but still. Hve a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts. -- Arthur Schopenhauer

Re: [HACKERS] Compiler branch prediction hints (was: So, is COUNT(*) fast now?)

2011-11-01 Thread Martijn van Oosterhout
. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts. -- Arthur Schopenhauer signature.asc Description: Digital signature

Re: [HACKERS] Add socket dir to pg_config..?

2011-10-30 Thread Martijn van Oosterhout
into the issue of hardcoded paths. If the directory it points to is not world writable then you've limited the users who can run the postgres server. Which is an unnecessary restriction imho). Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes

Re: [HACKERS] pgsql_fdw, FDW for PostgreSQL server

2011-10-29 Thread Martijn van Oosterhout
this is you use DECLARE CURSOR for all the queries upfront and then FETCH as needed. That way you can do it all over one connection. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he

Re: [HACKERS] patch: move dumpUserConfig call in dumpRoles function of pg_dumpall.c

2011-10-13 Thread Martijn van Oosterhout
opposite things in American and British english. I think the rest of the sentence makes it clear what you mean though :). Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach

Re: [HACKERS] Re: memory barriers (was: Yes, WaitLatch is vulnerable to weak-memory-ordering bugs)

2011-09-24 Thread Martijn van Oosterhout
of the knowing the address either, since the first load, if any, will be *q-items, irrespective of the precise value of num_items. This address may be calculated long in advance. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly

Re: [HACKERS] Re: memory barriers (was: Yes, WaitLatch is vulnerable to weak-memory-ordering bugs)

2011-09-24 Thread Martijn van Oosterhout
, although with loop unrolling you can't really be sure. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts. -- Arthur Schopenhauer

Re: [HACKERS] EXPLAIN and nfiltered, take two

2011-09-22 Thread Martijn van Oosterhout
still drop it but it gives a more useful output if the number of rows is really large. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts

Re: [HACKERS] Thinking about inventing MemoryContextSetParent

2011-09-11 Thread Martijn van Oosterhout
. The only issue I can think of is if people where allocating in the local context assuming it would be cleaned up and this data got kept as well. So it's probably not appropriate for things that happen really often. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog

Re: [HACKERS] postgresql.conf archive_command example

2011-09-09 Thread Martijn van Oosterhout
how it should be done. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts. -- Arthur Schopenhauer signature.asc Description

Re: [HACKERS] our buffer replacement strategy is kind of lame

2011-08-14 Thread Martijn van Oosterhout
, there are such things as lock-free linked lists. Whether they'd help here is the question though. http://www.cse.yorku.ca/~ruppert/papers/lfll.pdf Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does

Re: [HACKERS] mosbench revisited

2011-08-03 Thread Martijn van Oosterhout
/msg00197.php Perhaps we now have a benchmark where the effect can be measured. There's the issue about whether it screws up the readahead mechanism... Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very

Re: [HACKERS] New partitioning WAS: Check constraints on partition parents only?

2011-07-28 Thread Martijn van Oosterhout
when the disk is nearly full. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ He who writes carelessly confesses thereby at the very outset that he does not attach much importance to his own thoughts. -- Arthur Schopenhauer signature.asc

Re: [HACKERS] Deriving release notes from git commit messages

2011-07-03 Thread Martijn van Oosterhout
. I think the idea is that every object can have one note. How that works with versioning I have no idea. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other

Re: [HACKERS] debugging tools inside postgres

2011-06-25 Thread Martijn van Oosterhout
structures in readable formats. I guess someone could write some script to make debugging postgresql nicer (pretty printing snapshots, locks, etc). Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first

Re: [HACKERS] Hugetables question

2011-06-23 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de Gaulle signature.asc Description: Digital signature

Re: [HACKERS] Hugetables question

2011-06-19 Thread Martijn van Oosterhout
a difference for Linux in the long term. As for your other problem, Perhaps you can put the shmem block first, before the hugemem block? Would require some pointer fiddling, but seems doable. Habe a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when

Re: [HACKERS] Range Types and extensions

2011-06-19 Thread Martijn van Oosterhout
is not really supposed to be assigned to object for storage. How that can be resolved I'm not sure. Mvg, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] POSIX shared memory redux

2011-04-14 Thread Martijn van Oosterhout
possibly be on NFS. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de Gaulle

Re: [HACKERS] getting carriage return character in vacuumo

2011-04-09 Thread Martijn van Oosterhout
, the default being determined by whether it's running in a terminal or not. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] Evaluation of secondary sort key.

2011-04-09 Thread Martijn van Oosterhout
as hidden fields to the query, like: select id, /*hidden*/ id, /*hidden*/ testsort(id) from test1 where id 3 order by 2, 3; Here it's obvious why the evaluation happens. To avoid this evaluation would require redoing the way sorts work (I think). Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] .ini support for .pgpass

2011-04-06 Thread Martijn van Oosterhout
for connections if you will. But this is precisely what the service file achieves, right? ISTM what you d like is to be able to specify the password in the service file, in which case pgpass is not consulted. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog

Re: [HACKERS] Open issues for collations

2011-03-29 Thread Martijn van Oosterhout
/CFLocaleConcepts.html I think the rule that we sort the same as the command-line sort program is still true however, so I don't think it's surprising as such. Just unfortunate. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people

Re: [HACKERS] WIP: Allow SQL-language functions to reference parameters by parameter name

2011-03-27 Thread Martijn van Oosterhout
parameters (dynamic parameter specifications) and are represented in SQL language by a question mark (?). which I think we can all agree is not a useful guide. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people

Re: [HACKERS] Open issues for collations

2011-03-27 Thread Martijn van Oosterhout
the default collation for the period of the function, which I think is perfectly defensible. We might allow people in the future to override it (a la search_path) but this is a good start. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love

Re: [HACKERS] Open issues for collations

2011-03-26 Thread Martijn van Oosterhout
. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de Gaulle signature.asc

Re: [HACKERS] I am confused after reading codes of PostgreSQL three week

2011-03-20 Thread Martijn van Oosterhout
. As the page says, stepping through the processed file reveals little, becuase it's the same code being executed over and over again, only the variables change. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes

Re: [HACKERS] Collations versus record-returning functions

2011-03-20 Thread Martijn van Oosterhout
like a good idea. Indeed not. A rowtype has an order, determined by the fields within it. Those fields may be strings and so may have a collation. Doesn't seem particularly magical to me. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism

Re: [HACKERS] WIP patch: collation assignment algorithm rewrite

2011-03-20 Thread Martijn van Oosterhout
confident of its correctness. Thanks for going over this. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] volatile markings to silence compilers

2011-03-17 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de Gaulle signature.asc Description

Re: [HACKERS] dependency between numbers keywords and parser speed

2011-03-15 Thread Martijn van Oosterhout
than executing them. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de Gaulle

Re: [HACKERS] Collations versus user-defined functions

2011-03-13 Thread Martijn van Oosterhout
they will sometimes get the default collation anyway. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] Collations versus user-defined functions

2011-03-13 Thread Martijn van Oosterhout
is stored, like views, functions, etc. That's my reading of it anyway. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] FuncExpr.collid/OpExpr.collid unworkably serving double duty

2011-03-12 Thread Martijn van Oosterhout
*/ + { + CollateState *result = makeNode(CollateState); + result-colltype = COLLATE_NONE; + result-colloid = InvalidOid; + return result; + } + } + -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism

Re: [HACKERS] Collations versus user-defined functions

2011-03-12 Thread Martijn van Oosterhout
. But the plpgsql problem should be done already right, given it already handles cached plans for different types. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other

Re: [HACKERS] Collations versus user-defined functions

2011-03-12 Thread Martijn van Oosterhout
attached to columns. If ORDER BY x and ORDER BY x || 'foo' Don't use the same collation then that is a first grade violation of the POLA. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism

Re: [HACKERS] FuncExpr.collid/OpExpr.collid unworkably serving double duty

2011-03-11 Thread Martijn van Oosterhout
. A substr has the collation of its sole string argument. I hope this helps, Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] FuncExpr.collid/OpExpr.collid unworkably serving double duty

2011-03-10 Thread Martijn van Oosterhout
tree in parse_expr. But for clarity the extra field is a definite win. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] FuncExpr.collid/OpExpr.collid unworkably serving double duty

2011-03-10 Thread Martijn van Oosterhout
be calculatable via a single pass of the tree by something like parse_expr. That's essentially what the variables are doing in the Expr nodes, though whether you need one or two is ofcourse another question. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org

Re: [HACKERS] FuncExpr.collid/OpExpr.collid unworkably serving double duty

2011-03-10 Thread Martijn van Oosterhout
VIEW foo AS func(x COLLATE A) COLLATE B; B is the collation for the output column, A is the collation for the function. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate

Re: [HACKERS] Theory of operation of collation patch

2011-03-09 Thread Martijn van Oosterhout
. data type is basically only used in CAST and snip Sounds like a good plan. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] Theory of operation of collation patch

2011-03-08 Thread Martijn van Oosterhout
there by other means. Hope this helps, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de Gaulle

Re: [HACKERS] Theory of operation of collation patch

2011-03-07 Thread Martijn van Oosterhout
will be ignored in 99% of the executer, except for operators like =, and that need to look at it. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your

Re: [HACKERS] Why our counters need to be time-based WAS: WIP: cross column correlation ...

2011-02-28 Thread Martijn van Oosterhout
ofcourse. But there's ofcourse lots of stats people want, it's just not clear how to get them. What you really need is to store the stats every few minutes, but that's what munin does. I doubt it's worth building RRD like capabilities into postgres. Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] WIP: cross column correlation ...

2011-02-26 Thread Martijn van Oosterhout
can't even build useful 1D histograms for city and zip code, so the fact that 2D is hard is not surprising. The histograms we do build work fine from and , just equality. The 2D will handle the same. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog

Re: [HACKERS] Debian readline/libedit breakage

2011-02-19 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de Gaulle signature.asc Description

Re: [HACKERS] Debian readline/libedit breakage

2011-02-19 Thread Martijn van Oosterhout
On Sat, Feb 19, 2011 at 07:42:20PM +0100, Martijn van Oosterhout wrote: ODBC uses it as well. It really uses it for communication. As far as Google Code Search can it's the only one that does. But if the intention is to do it by adding new functions, we can and let the ODBC guys sort it out

Re: [HACKERS] Debian readline/libedit breakage

2011-02-19 Thread Martijn van Oosterhout
be freed with PQfreemem() */ + extern int PQsetPassthrough(PGconn *conn, PQpassthrough **state ); + -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] Debian readline/libedit breakage

2011-02-17 Thread Martijn van Oosterhout
could remove the old code and change the SSL library at leasure. I guess the painless option however is no longer available. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate

Re: [HACKERS] Debian readline/libedit breakage

2011-02-11 Thread Martijn van Oosterhout
for that backend was just icing, but trivial once the frontend was done. It can be left out. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes

Re: [HACKERS] Range Types: empty ranges

2011-02-11 Thread Martijn van Oosterhout
then empty ranges should pose no problems. Sure, it may be that an empty range will be both to the left and to the right of every other set. That doesn't make it wrong. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own

Re: [HACKERS] Caution when removing git branches

2011-01-26 Thread Martijn van Oosterhout
branchname $ git checkout branchname This will work as long as git gc hasn't been run since the delete. If it's referenced from somewhere else then it will work even after garbage collection. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism

Re: [HACKERS] texteq/byteaeq: avoid detoast [REVIEW]

2011-01-19 Thread Martijn van Oosterhout
it, since by definition it must be faster than strcoll(). I suppose a test would be interesting. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own

Re: [HACKERS] limiting hint bit I/O

2011-01-15 Thread Martijn van Oosterhout
multiple times, if one tuple can be frozen on a page, we should freeze as many as possible, but the logic may do that already. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate

Re: [HACKERS] arrays as pl/perl input arguments [PATCH]

2011-01-13 Thread Martijn van Oosterhout
; my $self = shift; return bless $self, $class; } sub FETCH { my $self = shift; return join(,, @$self); } my @a=(1,2); tie $a, MyClass, \@a; print \$a='$a'\n; print \$a[0]='$a[0]'\n; -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love

Re: [HACKERS] WIP: Range Types

2011-01-11 Thread Martijn van Oosterhout
to determine itself what kind of Datum it is dealing with. Thought experiment: the datum is an integer, but the oid says it's a pass-by-ref datum. Now the code may now to use the integer to derefence an arbitrary place in memory. Have a nice day, -- Martijn van Oosterhout klep...@svana.org

Re: [HACKERS] can shared cache be swapped to disk?

2011-01-04 Thread Martijn van Oosterhout
are really hard. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de Gaulle

Re: [HACKERS] writable CTEs

2010-12-29 Thread Martijn van Oosterhout
reference the equivalent page in other versions. That would be extremely useful when trying to work out what works in your particular version. I've never done anything serious with SGML, but it'd be cool if it was possible. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http

Re: [HACKERS] knngist - 0.8

2010-12-28 Thread Martijn van Oosterhout
could use it with ints/floats/etc as well, since you could skip the function call overhead. You'd be trading (n log n int compares + n sortkeys) with (n log n comparisions). Just some thoughts, Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism

Re: [HACKERS] Extensions, patch v20 (bitrot fixes)

2010-12-20 Thread Martijn van Oosterhout
such a parameter at all? UTF-8 is not a superset of all encodings. I think you mean Unicode is not a superset of all character sets. I've heard this before but never found what's missing. [citation needed]? Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog

Re: [HACKERS] bug in SignalSomeChildren

2010-12-20 Thread Martijn van Oosterhout
process doesn't notice. This has been a bug since forever though, so I wouldn't hold my breath. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes

Re: [HACKERS] Extensions, patch v20 (bitrot fixes)

2010-12-20 Thread Martijn van Oosterhout
are public it should be a SMOP to *prove* roundtrip conversions are safe, or identify the problems. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your

Re: [HACKERS] can shared cache be swapped to disk?

2010-12-19 Thread Martijn van Oosterhout
to swap our your shared memory rather than say the webserver. Your shared memory should be reasonably sized, but you should make sure the kernel has enough cache memory it can throw away first. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism

Re: [HACKERS] proposal : cross-column stats

2010-12-12 Thread Martijn van Oosterhout
that for many dimensions most of the grid will be not interesting. In fact, storing the 20 largest values may be enough. Worth an experiment. Hope this helps, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism

Re: [HACKERS] Idle git question: how come so many objects?

2010-11-30 Thread Martijn van Oosterhout
and these got merged? Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de Gaulle

Re: [HACKERS] Rethinking representation of sort/hash semantics in queries and plans

2010-11-28 Thread Martijn van Oosterhout
direction and nulls-first flags Sounds like a good idea to me. Quite aside from the performance issues, having one way to represent things will make it clearer what's going on and easier to extend in the future. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog

Re: [HACKERS] Report: Linux huge pages with Postgres

2010-11-28 Thread Martijn van Oosterhout
. I think if you got good statistics on how much time your CPU is waiting for memory it'd be pretty depressing. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people

Re: [HACKERS] Spread checkpoint sync

2010-11-21 Thread Martijn van Oosterhout
van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de Gaulle signature.asc Description: Digital signature

Re: [HACKERS] Per-column collation

2010-11-16 Thread Martijn van Oosterhout
, then make it better. /me ducks Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles

Re: [HACKERS] POSIX shared memory redux

2010-11-14 Thread Martijn van Oosterhout
use the non-existance of the SysV SHM to determine the non-existance of the other segment. Quite a bit more work, ISTM. Haveva nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate

Re: [HACKERS] temporary functions (and other object types)

2010-11-06 Thread Martijn van Oosterhout
whether it goes beyond that? IIRC correctly it's because even unpriveledged users can make things in the pg_temp schema and it's implicitly at the front of the search_path. There was a CVE about this a while back, no? Have a nice day, -- Martijn van Oosterhout klep...@svana.org http

Re: [HACKERS] ask for review of MERGE

2010-10-24 Thread Martijn van Oosterhout
already. Simply, if the row is visible in the current snapshot you do an update otherwise an insert. If you get an error, raise it. Icing can be added later. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes

Re: [HACKERS] Creation of temporary tables on read-only standby servers

2010-10-19 Thread Martijn van Oosterhout
there was the idea to have a sort of permanent temporary tables which would have a pg_class entry but each session would have its own copy. Replicated slaves would then also be able to use this construction. Doesn't help with the XIDs though. Have a nice day, -- Martijn van Oosterhout klep...@svana.org

Re: [HACKERS] knngist - 0.8

2010-10-16 Thread Martijn van Oosterhout
and that perhaps we should be looking for a way to push that to the index implementation code, with the default rule being: same collection yes, different no. Just some thoughts, Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own

Re: [HACKERS] Which file does the SELECT?

2010-10-10 Thread Martijn van Oosterhout
manipulate it. The type is not stored inside the datum. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] Why is time with timezone 12 bytes?

2010-09-25 Thread Martijn van Oosterhout
wants to try. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de Gaulle

Re: Interruptible sleeps (was Re: [HACKERS] CommitFest 2009-07: Yay, Kevin! Thanks, reviewers!)

2010-09-08 Thread Martijn van Oosterhout
is explicitly configured to do so? Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first. - Charles de

Re: [HACKERS] Streaming a base backup from master

2010-09-05 Thread Martijn van Oosterhout
On Sat, Sep 04, 2010 at 02:42:40PM +0100, Greg Stark wrote: On Fri, Sep 3, 2010 at 8:30 PM, Martijn van Oosterhout klep...@svana.org wrote: rsync is not rocket science. All you need is for the receiving end to send a checksum for each block it has. The server side does the same checksum

Re: [HACKERS] Streaming a base backup from master

2010-09-03 Thread Martijn van Oosterhout
of rsync (finding block that have moved) is not needed here. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] performance issue: logical operators are slow inside SQL function: missing optimalization?

2010-08-29 Thread Martijn van Oosterhout
of expressions. I don't believe currently expressions can refer to Vars at the same level (it would make projections somewhat messy) but if you could fix that you could avoid the double evaluation and still have decent performance, right? Have a nice day, -- Martijn van Oosterhout klep...@svana.org

Re: [HACKERS] refactoring comment.c

2010-08-28 Thread Martijn van Oosterhout
arrange for GCC to throw an error if the first argument to elog was non-constant, which would prevent bugs creeping in due to double evaluation. That still won't help users of other compilers though. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism

Re: [HACKERS] git: uh-oh

2010-08-18 Thread Martijn van Oosterhout
as well not do it at all. What's the loss? Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

Re: [HACKERS] dynamically allocating chunks from shared memory

2010-08-09 Thread Martijn van Oosterhout
having to reconfigure the kernel makes it (ISTM) worthwhile doing irrespective of anything else. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own

Re: [HACKERS] Compiling CVS HEAD with clang under OSX

2010-08-03 Thread Martijn van Oosterhout
it the ultra-safe way. FWIW, here's a site with some gcc magic which will allow you to detect overflows during addition. Ofcourse, the fact that it's gcc specific makes it a lot less useful. http://www.fefe.de/intof.html Have a nice day, -- Martijn van Oosterhout klep...@svana.org http

Re: [HACKERS] non-overlapping, consecutive partitions

2010-07-25 Thread Martijn van Oosterhout
by end_date, simple index scanning won't work while a merge sort will work beautifully. You're also not limited to how the partitioning machinery will eventually work. Hope this helps, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people

Re: [HACKERS] Admission Control

2010-06-26 Thread Martijn van Oosterhout
at a certain threshold since it would allow plans that *need* memory to work efficiently will still be able to. (It doesn't help in situations where you can't accurately predict memory usage, like hash tables.) Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org

Re: [HACKERS] Admission Control

2010-06-26 Thread Martijn van Oosterhout
On Sat, Jun 26, 2010 at 11:37:16AM -0400, Robert Haas wrote: On Sat, Jun 26, 2010 at 11:03 AM, Martijn van Oosterhout (It doesn't help in situations where you can't accurately predict memory usage, like hash tables.) Not sure what you mean by this part. We already predict how much memory

Re: [HACKERS] 9.0beta2 - server crash when using HS + SR

2010-06-13 Thread Martijn van Oosterhout
. For a first cut it would seem to me that you should just be able to ignore the tablespace commands on the slave. Not sure whether that's easy or not though. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes

Re: [HACKERS] How to pass around collation information

2010-05-28 Thread Martijn van Oosterhout
if COLLATE could finally be implemented, it'd be quite useful. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Patriotism is when love of your own people comes first; nationalism, when hate for people other than your own comes first

<    1   2   3   4   5   6   7   8   9   10   >