PgSql
in [SQL]
|
Dept of ugly hacks: eliminating padding space insystem indexes On Mon, 2008-06-23 at 15:52 -0400, Tom Lane wrote: CVS HEAD w/patch savings pg_database_size('postgres') 4439752 4071112 8.3% pg_relation_size('pg_class_relname_nsp_index') 57344 40960 28% pg_relation_size('pg_proc_proname_args_nsp_index') 319488 204800 35% Cutting a third ... 23 Jun 2008 18:55
count(*) performance improvement ideas Added to TODO: * Allow custom variables to appear in pg_settings() --------------------------------------------------------------------------- Tom Lane wrote: Magnus Hagander <magnus(a)hagander.net> writes: Tom Lane wrote: Really? [ pokes around ... ] Hm, you're right, because add_plac... 23 Jun 2008 18:55
Dept of ugly hacks: eliminating padding space in systemindexes Tom Lane wrote: Cutting a third off the size of a system index has got to be worth something, but is it worth a hack as ugly as this one? I think so. cheers andrew -- Sent via pgsql-hackers mailing list (pgsql-hackers(a)postgresql.org) To make changes to your subscription: http://www... 1 Jul 2008 11:18
stat() vs cygwin Magnus, was this fixed/resolved? --------------------------------------------------------------------------- Magnus Hagander wrote: It seems my fix for stat() broke cygwin, because it doesn't have dosmaperr() available. The way I see it there are two ways to fix this: 1) Don't apply the stat fix fo... 28 Jun 2008 14:44
Kludge in pg_standby.c Alvaro Herrera wrote: Gregory Stark wrote: There's a suspicious ifdef in pg_standby for WIN32 which smells like a kludge added to work around a Windows problem which makes it work but at great expense: #ifdef WIN32 /* * Wind... 23 Jun 2008 17:53
Remove hacks for old bad qsort()implementations? Added to TODO: * Consider whether duplicate keys should be sorted by block/offset http://archives.postgresql.org/pgsql-hackers/2008-03/msg00558.php --------------------------------------------------------------------------- Tom Lane wrote: There are several places in tuplesort.c (and perhaps elsewh... 23 Jun 2008 16:51
Dept of ugly hacks: eliminating padding spacein system indexes I would mention in the C comment that we are doing this for space savings, but other than that, it seems fine. --------------------------------------------------------------------------- Tom Lane wrote: I was thinking a bit about how we pad columns of type NAME to fixed-width, even though they're semanti... 23 Jun 2008 16:51
Dept of ugly hacks: eliminating padding space in system indexes I was thinking a bit about how we pad columns of type NAME to fixed-width, even though they're semantically equivalent to C strings. The reason for wasting that space is that it makes it possible to overlay a C struct onto the leading columns of most system catalogs. I don't wish to propose changing that (at least ... 24 Jun 2008 17:29
Proposal of SE-PostgreSQL patches [try#2] Hi, The following patch set is our second proposals of SE-PostgreSQL. It contains many of fixes and improvements from the previous version. Please add them a reviwing queue of the next commit fest. Thanks, List of Patches =============== [1/4] Core facilities of PGACE/SE-PostgreSQL http://sepgsql.... 12 Aug 2008 07:01
Hash index build patch has *worse* performance at small table sizes Bruce Momjian <bruce(a)momjian.us> writes: Did we ever do anything about this? Seems to be in there in CVS HEAD: /* * If we just insert the tuples into the index in scan order, then * (assuming their hash codes are pretty random) there will be no locality * of access to the index, and if th... 21 Jun 2008 20:56 |