Re: [HACKERS] Set LC_COLLATE to de_DE_phoneb

2010-04-10 Thread Martijn van Oosterhout
and even custom sort orders. 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] pg_ctl stop -m immediate on the primary server inflates sequences

2010-04-10 Thread Martijn van Oosterhout
with anything not important, like for example gaps in sequences. You're essentially crashing the DB. Have a ncie 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] PostgreSQL::PLPerl::Call - Simple interface for calling SQL functions from PostgreSQL PL/Perl

2010-02-16 Thread Martijn van Oosterhout
van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] LISTEN/NOTIFY versus encoding conversion

2010-02-15 Thread Martijn van Oosterhout
was because we couldn't decide. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] review: More frame options in window functions

2010-02-11 Thread Martijn van Oosterhout
, but if there is only one suitable possibility I think this can be made to work. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc

Re: [HACKERS] C function accepting/returning cstring vs. text

2010-01-27 Thread Martijn van Oosterhout
necessary. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Testing with concurrent sessions

2010-01-11 Thread Martijn van Oosterhout
module which works as well and is one tenth of the size. It also doesn't have external dependancies. It's just a plain wrapper around libpq, which for the purposes of testing may be better. http://search.cpan.org/~mergl/pgsql_perl5-1.9.0/Pg.pm Have a nice day, -- Martijn van Oosterhout klep

Re: [HACKERS] Testing with concurrent sessions

2010-01-11 Thread Martijn van Oosterhout
something that was close to libpq and had no external dependancies than taking a module with an external dependancy (namely DBI). Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding

Re: [HACKERS] So do we really *need* those substring() ops in tab-completion queries?

2010-01-03 Thread Martijn van Oosterhout
if it works. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Cancelling idle in transaction state

2010-01-03 Thread Martijn van Oosterhout
: put transaction in aborted state If no statement active: do nothing However, I see that the documentation wants to be able to abort a *specific* statement, which is not being proposed here. Can that be implemented on top of the current proposal? Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] Range types

2009-12-16 Thread Martijn van Oosterhout
byte rather than the content. In the implementation you may need to copy the content before processing to satisfy the alignment of the contained type, but that's just a SMOP. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree

Re: [HACKERS] Range types

2009-12-16 Thread Martijn van Oosterhout
I recognise. There are contiguous sets, but they are something else. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc

Re: [HACKERS] Range types

2009-12-16 Thread Martijn van Oosterhout
the database enforce it. (Intermediate values may become a different kind, just as long as the result being stored it the right kind.) Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding

Re: [HACKERS] Range types

2009-12-14 Thread Martijn van Oosterhout
actual usecase for a distretized range type for timestamp? Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description

Re: [HACKERS] Adding support for SE-Linux security

2009-12-07 Thread Martijn van Oosterhout
/2009-01/msg02295.php (It seems we've gone from a patch that had been around for years solving actual people's problems to a patch which does barely anything and we don't know whether it solves anybodies problem). Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org

Re: [HACKERS] SE-PgSQL patch review

2009-11-25 Thread Martijn van Oosterhout
). As far as I can tell, just about all the interesting cases are for row-level security. While MAC on tables and columns will be interesting, my guess the real uptake will be when row-level control is in. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please

Re: [HACKERS] Listen / Notify rewrite

2009-11-11 Thread Martijn van Oosterhout
on disk with pages mapped into shared memory for read/write access. While I can't really comment on the implementation, from your description it looks like a big improvement. Nice work! Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up

Re: [HACKERS] Rules: A Modest Proposal

2009-10-05 Thread Martijn van Oosterhout
values (floor(random()*1000)::integer); becomes something like: WITH NEW AS ( insert into t values (floor(random()*1000)::integer); RETURNING * ) insert into t_log values (NEW.a); Would this not have the required semantics? Have a nice day, -- Martijn van Oosterhout klep...@svana.org http

Re: [HACKERS] Rules: A Modest Proposal

2009-10-05 Thread Martijn van Oosterhout
On Mon, Oct 05, 2009 at 10:32:53AM -0400, Tom Lane wrote: Martijn van Oosterhout klep...@svana.org writes: WITH NEW AS ( insert into t values (floor(random()*1000)::integer); RETURNING * ) insert into t_log values (NEW.a); Would this not have the required semantics

Re: [HACKERS] Disable and enable of table and column constraints

2009-09-12 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] combined indexes with Gist - planner issues?

2009-08-31 Thread Martijn van Oosterhout
index: execute multiple queries of the form: ... AND display_price = 0.01 and display_price 1; ... AND display_price = 1 and display_price 10; Because you match less records the sort won't be so expensive and you can stop once you have enough records. Hope this helps, -- Martijn van Oosterhout

Re: [HACKERS] [pgsql-hackers] Daily digest v1.9418 (15 messages)

2009-08-29 Thread Martijn van Oosterhout
results it could give you good results as to the reliability of the recovery process. Probably more a research project than anything else though. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while

Re: [HACKERS] clang's static checker report.

2009-08-23 Thread Martijn van Oosterhout
trickier. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Geometric Elimination

2009-08-21 Thread Martijn van Oosterhout
way. Hope this helps, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Geometric Elimination

2009-08-21 Thread Martijn van Oosterhout
On Fri, Aug 21, 2009 at 09:42:57PM +1000, Paul Matthews wrote: Martijn van Oosterhout wrote: I haven't completely understood what you're trying to do Putting in place the missing 'box op point' and 'point op box' operators. The problematic queries are at the bottom of the email

Re: [HACKERS] More thoughts on sorting

2009-08-01 Thread Martijn van Oosterhout
day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] plpgsql: support identif%TYPE[], (from ToDo)

2009-07-28 Thread Martijn van Oosterhout
[]) ... declare f a%element; begin ... I would have thought: declare f a[0]%type; as in: the type of a[0]. Perhaps a[]%type but that seems less natural. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap

Re: [HACKERS] SE-PostgreSQL Specifications

2009-07-24 Thread Martijn van Oosterhout
somewhere. The same for the db_* convention. Do you have a reference to naming conventions for SELinux permissions? I need to think it over some more, but it's a really good start. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree

Re: [HACKERS] [PATCH] SE-PgSQL/tiny rev.2193

2009-07-20 Thread Martijn van Oosterhout
. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] generic explain options v3 - RR Review

2009-07-19 Thread Martijn van Oosterhout
). Hope this helps, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] [PATCH] SE-PgSQL/tiny rev.2193

2009-07-18 Thread Martijn van Oosterhout
, just supplement them. Merely my opinion ofcourse, which doesn't count for much :) Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines

Re: [HACKERS] Should mdxxx functions(e.g. mdread, mdwrite, mdsync etc) PANIC instead of ERROR when I/O failed?

2009-06-15 Thread Martijn van Oosterhout
... Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] forward declaration in c

2009-05-25 Thread Martijn van Oosterhout
day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Multiple sorts in a query

2009-05-19 Thread Martijn van Oosterhout
the memory to the kernel, irrespective of other allocations. The threshold is dynamic apparently, but starts at 128KB. Just a thought, Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding

Re: [HACKERS] Fixing the libxml memory allocation situation

2009-05-18 Thread Martijn van Oosterhout
that different users of the same library can control their own memory usage without affecting others. Not a short term solution, but it might help longer term. We certainly have enough examples to convince them of the problem. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http

Re: [HACKERS] high shared buffer and swap

2009-05-04 Thread Martijn van Oosterhout
processes I might be running. On a NUMA machine you want to be keeping your memory on the local node and letting the kernel copy that data from elsewhere to your local memory when you need it. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up

Re: [HACKERS] To know what a macro does

2009-04-27 Thread Martijn van Oosterhout
what you're trying to achieve. Why are you changing the source code? Maybe someone else can answer your question specifically. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank

Re: [HACKERS] RFE: Transparent encryption on all fields

2009-04-27 Thread Martijn van Oosterhout
and there is. I know of no such standard support of either of the standard OSes. For the record, in Debian Linux you can setup an encrypted root FS during installation and it will ask to a password on every boot. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog

Re: [HACKERS] To know what a macro does

2009-04-26 Thread Martijn van Oosterhout
day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] [PATCH] unalias of ACL_SELECT_FOR_UPDATE

2009-04-20 Thread Martijn van Oosterhout
do. Namely, label stuff secret and be sure no-one without clearence can read it, even if someone makes a setuid function for it. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding

Re: [HACKERS] [rfc] unicode escapes for extended strings

2009-04-17 Thread Martijn van Oosterhout
On Fri, Apr 17, 2009 at 07:07:31PM +0300, Marko Kreen wrote: Btw, is there any good reason why we don't reject \000, \x00 in text strings? Why forbid nulls in text strings? Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree

Re: [HACKERS] Unicode string literals versus the world

2009-04-15 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Unicode support

2009-04-15 Thread Martijn van Oosterhout
. Once Postgres decides it want to do unicode properly and thus imports the tables in some way, it could get the code to work with it for 20% extra. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant

Re: [HACKERS] SSL over Unix-domain sockets

2009-04-01 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Crash in gist insertion on pathological box data

2009-03-28 Thread Martijn van Oosterhout
that everything has been put in one node (left or right) and in that case just split the list straight down the middle (since clearly it doesn't matter on which side they appear.). Or switch algorithms, but that's more than just a bugfix. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http

Re: [HACKERS] DTrace probes broken in HEAD on Solaris?

2009-03-24 Thread Martijn van Oosterhout
the macro check that it can take the address of the arguments, which amounts to almost the same thing. It only doesn't work on constants. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding

Re: [HACKERS] DTrace probes broken in HEAD on Solaris?

2009-03-24 Thread Martijn van Oosterhout
On Tue, Mar 24, 2009 at 10:18:08PM +, Greg Stark wrote: On Tue, Mar 24, 2009 at 10:12 PM, Martijn van Oosterhout klep...@svana.org wrote: Not really a GCC extension, but you could have the macro check that it can take the address of the arguments, which amounts to almost the same thing

Re: [HACKERS] contrib function naming, and upgrade issues

2009-03-21 Thread Martijn van Oosterhout
of a function could add the appropriate magic to set the visiblity to public and alter PGXS to set the default visibility to hidden. Voila, modules whose only exported symbols are those declared with a version-1 declaration. Perhaps a little too much magic :) Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] Problem with accesing Oracle from plperlu functionwhen using remote pg client.

2009-03-17 Thread Martijn van Oosterhout
. It shouldn't effect the ps output. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Has anybody think about changing BLCKSZ to an option of initdb?

2009-03-14 Thread Martijn van Oosterhout
products such as EDB's but the Windows installer makes a pretty good argument on its own). And all the linux distributions which ship precompiled binaries. I'm sure there are people who compile postgres themselves but I think there are more who don't. Have a nice day, -- Martijn van Oosterhout

Re: [HACKERS] SE-PostgreSQL and row level security

2009-02-16 Thread Martijn van Oosterhout
, this is precisely what Veil does (and information_schema for that matter). Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description

Re: [HACKERS] SE-PostgreSQL and row level security

2009-02-15 Thread Martijn van Oosterhout
obvious, I'm just not seeing it. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] WIP: fix SET WITHOUT OIDS, add SET WITH OIDS

2009-02-09 Thread Martijn van Oosterhout
on tables may be an easier option. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] WIP: fix SET WITHOUT OIDS, add SET WITH OIDS

2009-02-09 Thread Martijn van Oosterhout
time, not dump time... Another idea, have WITH OIDS just append a column to the table called OID with SERIAL type. People see them, go whoops and drop them. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap

Re: [HACKERS] Is a plan for lmza commpression in pg_dump

2009-02-08 Thread Martijn van Oosterhout
can use their compression algorithm of the week and we don't need to care about the licence or anything. It's not like the case of TOAST where it actually needs to be builtin. Tar doesn't have any compression builtin, yet you don't see many uncompressed tar files... Have a nice day, -- Martijn van

Re: [HACKERS] why declare arg as a array in FunctionCallInfoData structure

2009-02-02 Thread Martijn van Oosterhout
heap? It saves more momery if 'arg' and 'argnull' declares as pointer type. I imagaine it's because most of the time this structure would be allocated on the stack, where allocation is essentially free. Having to allocate two arrays from the heap would be slower. Have a nice day, -- Martijn van

Re: [HACKERS] adding stuff to parser, question

2009-02-01 Thread Martijn van Oosterhout
as UNRESERVED_KEYWORD there rather than RESERVED_KEYWORD. Quite frankly, the grammer is not that hard part. If you can get it to work with any grammer at all, some yacc guru can fix it to match any grammer anyone wants in a very short time. Have a nice day, -- Martijn van Oosterhout klep

Re: [HACKERS] [PATCH] Space reservation v02

2009-01-31 Thread Martijn van Oosterhout
. Ofcourse, the simplest way to me for handling type changes seems to be to keep the old type OID reserved and have the new version of the type with a new OID. Then the entire problem vanishes. But it was decided a long time ago not to do that. Have a nice day, -- Martijn van Oosterhout klep

Re: [HACKERS] 8.4 release planning

2009-01-27 Thread Martijn van Oosterhout
On Mon, Jan 26, 2009 at 08:28:32PM -0500, Tom Lane wrote: Hmm, you think selinux people read pgsql-announce? Maybe not, but it got it onto LWN, which is a lot more people. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree

Re: [HACKERS] Updates of SE-PostgreSQL 8.4devel patches (r1403)

2009-01-14 Thread Martijn van Oosterhout
On Wed, Jan 14, 2009 at 09:52:20AM -0500, Tom Lane wrote: Martijn van Oosterhout klep...@svana.org writes: On Tue, Jan 13, 2009 at 10:05:45AM -0300, Alvaro Herrera wrote: pgace.h: you have a bunch of static inline functions in here. As far as I know this doesn't work in compilers other

Re: [HACKERS] Updates of SE-PostgreSQL 8.4devel patches (r1403)

2009-01-13 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Significant oversight in that #include-removal script

2009-01-08 Thread Martijn van Oosterhout
to sloppiness in libraries, but it might help. Have anice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [GENERAL] [HACKERS] ERROR: failed to find conversion function from unknown to text

2009-01-06 Thread Martijn van Oosterhout
in postgres. This generally works fine, except in the case of UNION where none of the branches provide the necessary type info. Have a nice day, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you

Re: [HACKERS] Significantly larger toast tables on 8.4?

2009-01-02 Thread Martijn van Oosterhout
find it quickly. This barely costs you anything in the compression ratio mostly. Implementation though, that's harder. The size of the blobs is tunable also. I imagine the optimal value will probably be around 100KB. (12 blocks uncompressed). Have a nice day, -- Martijn van Oosterhout klep

Re: [HACKERS] incoherent view of serializable transactions

2008-12-22 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout klep...@svana.org http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Debug crash

2008-12-11 Thread Martijn van Oosterhout
debug symbols in both the backend server and your module, otherwise you're setting youself up for a lot of pain. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Martijn van Oosterhout
animal and several test sets. Animals defines HW+OS version and test set specify PG version, configure switches, compiler and so on. Well, you could name them animal-1, animal-2, animal-3, etc... Once the list reaches 100 entries we can think about alternatives... Have a nice day, -- Martijn van

Re: [HACKERS] Synchronous replication: sleeping

2008-12-08 Thread Martijn van Oosterhout
sleep? In theory, none. SIGALRM is not set as SA_RESTART so any system call should be interrupted. This applies to POSIX systems though, not sure about Windows. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap

Re: [HACKERS] Simple postgresql.conf wizard

2008-11-30 Thread Martijn van Oosterhout
the total SYSV memory allowed by the OS. Otherwise you've just output an unstartable config. The output of /sbin/sysctl should tell you. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while

Re: [HACKERS] Column reordering in pg_dump

2008-11-25 Thread Martijn van Oosterhout
. Fortunatly, we don't need to do too much arithmetic on them. If the size of the object doesn't matter, you can do thing like typedef a pointer to a one byte struct. Then most standard arithmetic operations will still work (IIRC the Linux kernel uses this trick a lot). Have a nice day, -- Martijn van

Re: [HACKERS] Block-level CRC checks

2008-11-17 Thread Martijn van Oosterhout
be mitigated to only pages which are hint-bit *only* changed, not dirty with already-wal-logged changes) That's a long running debate. Hint bits do save I/O, the question is the tradeoff. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please

Re: [HACKERS] Block-level CRC checks

2008-11-16 Thread Martijn van Oosterhout
all and continue. The checksums need not be of equal strength. The extreme case is an ECC where you explicitly can set it so you can alter N bits before you need to recalculate the checksum. Computationally though, that sucks. Hope this helps, -- Martijn van Oosterhout [EMAIL PROTECTED] http

Re: [HACKERS] Pl/Perl function: Speed of the First time executing pl/perl function in connection;

2008-11-16 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Block-level CRC checks

2008-11-14 Thread Martijn van Oosterhout
is that you want to continue in the face of torn pages, something which is AFAICS ambitious. At least MS-SQL just blows up on a torn page, havn't found results for other databases... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree

Re: [HACKERS] Block-level CRC checks

2008-11-13 Thread Martijn van Oosterhout
a COMP_CRC32_WITH_COPY() macro would do it. Just allocate a block on the stack, copy/checksum it there, do the write() syscall and forget it. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding

Re: [HACKERS] Block-level CRC checks

2008-11-12 Thread Martijn van Oosterhout
the COMP_CRC32_ONE I mentioned. Actually changing the memory probably means locking so why bother. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn

Re: [HACKERS] Block-level CRC checks

2008-11-11 Thread Martijn van Oosterhout
].hintbits # If n == numtups, next = BLOCK_SIZE else: CRC_ADD( block[pos] pos++ This only handles one byte of hintbits but can easily be extended. No need to actually *store* the hintbit free version anywhere... Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org

Re: [HACKERS] WIP: Page space reservation (pgupgrade)

2008-11-10 Thread Martijn van Oosterhout
once the upgrade is complete. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Block-level CRC checks

2008-11-09 Thread Martijn van Oosterhout
which could probably get that down to a few KB. Although, maybe locking of the hint bits would be a problem? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying

Re: [HACKERS] Block-level CRC checks

2008-11-09 Thread Martijn van Oosterhout
this issue? Might be better anyway. A single copy-and-checksum would probably be quite cheap (pulling the page into L2 cache). Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding

Re: [HACKERS] Updates of SE-PostgreSQL 8.4devel patches (r1197)

2008-11-07 Thread Martijn van Oosterhout
about covert channels. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] [WIP] In-place upgrade

2008-11-05 Thread Martijn van Oosterhout
room. So Phase one moves a few tuples to make room. Phase 2 actually converts the pages inplace. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines

Re: [HACKERS] [WIP] In-place upgrade

2008-11-05 Thread Martijn van Oosterhout
solve the overflow problem on the old page... Sure it does. You move just enough tuples that you can convert the page without an overflow. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while

Re: [HACKERS] Well done, Hackers

2008-11-02 Thread Martijn van Oosterhout
feedback, hopefully. I imagine a number of people submit patches because they hope to get some feedback on them, something which does always happen at other times... I think all this development is good. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog

Re: [HACKERS] Block-level CRC checks

2008-10-30 Thread Martijn van Oosterhout
it's supposed to end up. No need to preseed (or more accurately, it doesn't matter how you preseed, the result is the same). For checking it doesn't matter either, just checksum the page and if you get zero it's correct. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http

Re: [HACKERS] Window Functions: v07 APIs and buffering strateties

2008-10-28 Thread Martijn van Oosterhout
than adding two reserved words. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Window Functions: v07 APIs and buffering strateties

2008-10-28 Thread Martijn van Oosterhout
BY expressions anyway? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] WIP patch: convert SQL-language functions to return tuplestores

2008-10-27 Thread Martijn van Oosterhout
clause. In the tuplestore case you evaluate everything then throw it away. Your test cases, if you append LIMIT 1 to all of them, how do the timings compare then? Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain

Re: [HACKERS] new correlation metric

2008-10-26 Thread Martijn van Oosterhout
think the code is in the right direction, but I think want you want is some kind of estimate of given I've looked for tuple X, how many tuples in the next k pages are near this one. Unfortunatly I don't see a way of calculating it other than a full simulation. Have a nice day, -- Martijn van

Re: [HACKERS] SSL cleanups/hostname verification

2008-10-21 Thread Martijn van Oosterhout
there is no certificate at all, so why would you if the certificate is untrusted? You seem to be making the assertion that making an encrypted connection to an untrusted server is worse than making a plaintext connection to an untrusted server, which seems bogus to me. Have a nice day, -- Martijn van

Re: [HACKERS] SSL cleanups/hostname verification

2008-10-21 Thread Martijn van Oosterhout
On Tue, Oct 21, 2008 at 11:55:32AM +0100, Gregory Stark wrote: Martijn van Oosterhout [EMAIL PROTECTED] writes: You seem to be making the assertion that making an encrypted connection to an untrusted server is worse than making a plaintext connection to an untrusted server, which seems

Re: [HACKERS] SSL cleanups/hostname verification

2008-10-21 Thread Martijn van Oosterhout
a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] PGDay.it collation discussion notes

2008-10-18 Thread Martijn van Oosterhout
as they are cast to text, since the text type will have a default collation (just like it has a default operator class). Nice to see some progress being made here. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap

Re: [HACKERS] PGDay.it collation discussion notes

2008-10-18 Thread Martijn van Oosterhout
think the storage space considerations make that a difficult option. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc

Re: [HACKERS] Cross-column statistics revisited

2008-10-17 Thread Martijn van Oosterhout
van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] Cross-column statistics revisited

2008-10-17 Thread Martijn van Oosterhout
such functions easily in practice doesn't change the fact that zip codes and city names are highly correlated. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn

Re: [HACKERS] Cross-column statistics revisited

2008-10-16 Thread Martijn van Oosterhout
potential use case is the (startdate,enddate) columns. Here what you want to detect somehow that the distribution of (enddate-startdate) is constant. I think the real question is: what other kinds of correlation might people be interested in representing? Have a nice day, -- Martijn van

Re: [HACKERS] Cross-column statistics revisited

2008-10-16 Thread Martijn van Oosterhout
with a partial index. This should be fairly easy to do I think. It might be worthwhile someone trawling through the archives looking for examples where we estimate the correlation wrong. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree

Re: [HACKERS] The Axe list

2008-10-12 Thread Martijn van Oosterhout
, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description: Digital signature

Re: [HACKERS] WIP patch: Collation support

2008-09-23 Thread Martijn van Oosterhout
/locales. You may be able to guess a few but certainly not all of them. Have a nice day, -- Martijn van Oosterhout [EMAIL PROTECTED] http://svana.org/kleptog/ Please line up in a tree and maintain the heap invariant while boarding. Thank you for flying nlogn airlines. signature.asc Description

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