Re: [PATCHES] dblink connection security

2007-07-01 Thread Gregory Stark
. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match

Re: [PATCHES] Load Distributed Checkpoints, final patch

2007-07-03 Thread Gregory Stark
test with very short checkpoint intervals. Something like 30s. Just to make sure that the logic is all correct and unexpected things don't start happening. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast

Re: [PATCHES] dblink connection security

2007-07-08 Thread Gregory Stark
able to connect to a postgres server shouldn't mean being able to open tcp connections *from* that server to arbitrary other host/ports. Consider for example that it would allow a user to perform a port scan from inside your network to see what internal services are running. -- Gregory Stark

Re: [PATCHES] dblink connection security

2007-07-08 Thread Gregory Stark
. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get

Re: [PATCHES] dblink connection security

2007-07-08 Thread Gregory Stark
they create any function using an untrusted language. And the author of the script here is not being careful in this respect. The sysadmin isn't the one writing the create function statement. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end

Re: [PATCHES] dblink connection security

2007-07-08 Thread Gregory Stark
the same concerns arise and the same conclusion reached. That users should be granted permission to execute it based on local policies. Certainly granting execute permission to public by default is a bad start in that regard. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com

Re: [PATCHES] dblink connection security

2007-07-08 Thread Gregory Stark
the security model by merely being installed then programmers or dependent modules can request packages and dbas can be confident that installing them won't introduce security holes. Isn't that a property software should have even if it's just an add-on module? -- Gregory Stark EnterpriseDB

Re: [PATCHES] dblink connection security

2007-07-09 Thread Gregory Stark
. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get

Re: [PATCHES] dblink connection security

2007-07-09 Thread Gregory Stark
have multiple users. All I'm suggesting is that the default install script should just do that rather than do something that the docs will then recommend you undo. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast

Re: [PATCHES] Maintaining cluster order on insert

2007-07-10 Thread Gregory Stark
a way to make this work usefully. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED

Re: [PATCHES] Deferred RI trigger for non-key UPDATEs and subxacts

2007-07-16 Thread Gregory Stark
, but it has no other user visible behavior. On the other hand what happens if you have constraints not deferred, insert a record, then set constraints deferred and update it? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast

Re: [PATCHES] Deferred RI trigger for non-key UPDATEs and subxacts

2007-07-16 Thread Gregory Stark
Gregory Stark [EMAIL PROTECTED] writes: On the other hand what happens if you have constraints not deferred, insert a record, then set constraints deferred and update it? After having a coffee this is obviously not a problem since if you have constraints not deferred then the constraint

Re: [PATCHES] Silly bug in pgbench's random number generator

2007-07-16 Thread Gregory Stark
Uhm, this is a one-line *bug fix*. Bruce Momjian [EMAIL PROTECTED] writes: This has been saved for the 8.4 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Gregory Stark wrote: pgbench's

Re: [PATCHES] WIP: rewrite numeric division

2007-07-17 Thread Gregory Stark
really necessary. My fix does resolve the only actual documented inaccuracy in the existing method. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [PATCHES] WIP: rewrite numeric division

2007-07-17 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: Yeah. I was basically waiting to see if anyone could come up with a faster solution. Since no one seems to have an idea how to do it better, I'm inclined to apply the patch for 8.3

Re: [PATCHES] WIP: rewrite numeric division

2007-07-17 Thread Gregory Stark
calculate the precision to be precisely enough to maintain the original precision. Ie, /1000 should just give you n.nnn not n.nnn and more importantly it should never round. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast

Re: [PATCHES] CREATE TABLE LIKE INCLUDING INDEXES support

2007-07-20 Thread Gregory Stark
Tatsuo Ishii [EMAIL PROTECTED] writes: Can someone enligten me what the usecase for CREATE TABLE LIKE at this moment is? One of the main use cases I envision is wanting to create new partitions suitable for being added to a partitioned table. -- Gregory Stark EnterpriseDB http

Re: [PATCHES] CREATE TABLE LIKE INCLUDING INDEXES support

2007-07-21 Thread Gregory Stark
Jim C. Nasby [EMAIL PROTECTED] writes: On Fri, Jul 20, 2007 at 12:40:46PM +0100, Gregory Stark wrote: One of the main use cases I envision is wanting to create new partitions suitable for being added to a partitioned table. Except that's normally done with CREATE TABLE INHERITS, which

Re: [PATCHES] Async Commit, v21 (now: v22)

2007-07-24 Thread Gregory Stark
with async commits or with something like commit_delay and some extra logic in the walwriter to aim for grouping together the maximum number of commits. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast

Re: [PATCHES] plperl warnings on win32

2007-07-24 Thread Gregory Stark
. */ /*#define HAS_GETPGRP2 / **/ /* HAS_GETPPID: * This symbol, if defined, indicates that the getppid routine is * available to get the parent process ID. */ #define HAS_GETPPID /**/ -- Gregory Stark EnterpriseDB http://www.enterprisedb.com

Re: [PATCHES] plperl warnings on win32

2007-07-24 Thread Gregory Stark
the config.h file themselves and they missed this detail. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail

Re: [PATCHES] Async Commit, v21 (now: v22)

2007-07-24 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Without async commits? Do we really want the walwriter doing the majority of the wal-flushing work for normal commits? It seems like that's not going to be any advantage over just having some random backend do

Re: [PATCHES] msvc const warnings

2007-07-24 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Magnus Hagander [EMAIL PROTECTED] writes: Stefan mentioned that the warning may be one that shows up in a different compiler somewhere as well, thouh, which might indicate that we should fix the underlying issue

Re: [PATCHES] Async Commit, v21 (now: v22)

2007-07-24 Thread Gregory Stark
but the related transaction commit is lost then you have a problem. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [PATCHES] allow CSV quote in NULL

2007-07-27 Thread Gregory Stark
there's no way to include it (if it needs quoting) but only when you specify it this way. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

[PATCHES] Repair cosmetic damage (done by pg_indent?)

2007-07-27 Thread Gregory Stark
,/* Stop history lookup if a match of 128 bytes is found */ ! 6 /* Look harder for a good match. */ }; const PGLZ_Strategy * const PGLZ_strategy_always = strategy_always_data; -- Gregory Stark EnterpriseDB http://www.enterprisedb.com

Re: [PATCHES] [HACKERS] Document and/or remove unreachable code in tuptoaster.c from varvarlena patch

2007-07-27 Thread Gregory Stark
-- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

Re: [PATCHES] Repair cosmetic damage (done by pg_indent?)

2007-07-30 Thread Gregory Stark
Decibel! [EMAIL PROTECTED] writes: On Fri, Jul 27, 2007 at 04:07:01PM +0100, Gregory Stark wrote: Fwiw, do we really not want to compress anything smaller than 256 bytes (everyone in Postgres uses the default strategy, not the always strategy). Is there actually a way to specify always

[PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-30 Thread Gregory Stark
documenting it on the comparison operators page -- the only page where it seems it would make sense -- would be a bad idea. pg_convert_to_scalar.patch.gz Description: Binary data -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-30 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Attached is a patch which implements, as discussed briefly on -hackers, a user-visible function to get at the information that convert_to_scalar uses to generate selectivity estimates. This is an astonishingly bad

Re: [PATCHES] HOT latest patch - version 8

2007-07-31 Thread Gregory Stark
are used to ensure that no transaction for which the older tuples are visible can use the index. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-31 Thread Gregory Stark
wonder if it makes more sense to make this an optional btree operator class support procedure rather than a type function. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 1: if posting/reading

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-31 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: When complaining I hadn't read the pghackers thread in which you suggested this, and now that I'm caught up on email I remain unconvinced. What do you need convert_to_scalar

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-07-31 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: How so? The entries in the histogram are equidistant by definition. Huh? They have equal number of values between them, they're not equidistant in the scalar space. So the area

Re: [PATCHES] Export user visible function to make use of convert_to_scalar

2007-08-01 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: I was planning to use the first and last histogram values for the frame of reference. It could still produce some weird graphs but those cases are precisely the cases where users

Re: [PATCHES] Correction of how to use TimeZone by ControlFile(xlog.c)

2007-08-03 Thread Gregory Stark
the timestamps in the appropriate timezone for user's consumption. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PATCHES] Correction of how to use TimeZone by ControlFile(xlog.c)

2007-08-03 Thread Gregory Stark
be parsed by anything. But perhaps I overestimate Excel's abilities. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating

Re: [PATCHES] Correction of how to use TimeZone by ControlFile(xlog.c)

2007-08-03 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: I don't think it's an acceptable change in either place. People who want to see UTC in their logs can start the postmaster in UTC. Those who are accustomed to seeing local time

Re: [PATCHES] Repair cosmetic damage (done by pg_indent?)

2007-08-04 Thread Gregory Stark
Decibel! [EMAIL PROTECTED] writes: On Sun, Jul 29, 2007 at 12:06:50PM +0100, Gregory Stark wrote: You would have to recompile with the value at line 214 of src/backend/utils/adt/pg_lzcompress.c set to a lower value. Doesn't seem to be working for me, even in the case of a table with a bunch

Re: [PATCHES] Repair cosmetic damage (done by pg_indent?)

2007-08-04 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: The scenario I was describing was having, for example, 20 fields each of which are char(100) and store 'x' (which are padded with 99 spaces). So the row is 2k but the fields are highly compressible, but shorter than

Re: [PATCHES] Repair cosmetic damage (done by pg_indent?)

2007-08-04 Thread Gregory Stark
effective. They require a static dictionary but then that's precisely what I'm thinking of. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PATCHES] tsearch core path, v0.58

2007-08-16 Thread Gregory Stark
would like to see all the data types in a file in adt. Even if it's just a single file containing mostly just glue functions into code in sc/backend/tsearch. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast

Re: [PATCHES] HOT patch - version 14

2007-08-30 Thread Gregory Stark
declaring that the tid might sometimes not change after an update. Not sure what this translates to for MaxHeapTuplesPerPage though. The rest I know less about and will leave to Pavan and Heikki (or anyone else who was following those details more closely). -- Gregory Stark EnterpriseDB

Re: [PATCHES] HOT patch - version 14

2007-08-30 Thread Gregory Stark
Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: Pavan Deolasee [EMAIL PROTECTED] writes: Please see the version 14 of HOT patch attached. I expected to find either a large new README, or some pretty substantial additions to existing README files, to document how

Re: [PATCHES] HOT patch - version 14

2007-08-30 Thread Gregory Stark
. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq

[PATCHES] Buglet in Sort Method explain output in degenerate case

2007-09-01 Thread Gregory Stark
); + state-boundUsed = true; state-status = TSS_BOUNDED; } @@ -2284,7 +2285,6 @@ REVERSEDIRECTION(state); state-status = TSS_SORTEDINMEM; - state-boundUsed = true; } /* -- Gregory Stark EnterpriseDB http://www.enterprisedb.com

Re: [PATCHES] HOT documentation README

2007-09-04 Thread Gregory Stark
? Corrections? You should also take the appendix to Heikki's README about CREATE INDEX that I wrote. I plan to put this in src/backend/access/heap/README.HOT. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast

Re: [PATCHES] HOT documentation README

2007-09-04 Thread Gregory Stark
are using old snapshots if we can be sure they can't use the new plan then it would still be safe to use the index in the new plan. Also in SERIALIZABLE mode those same statements hold for temporary tables. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com

Re: [PATCHES] HOT documentation README

2007-09-04 Thread Gregory Stark
? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 4: Have you searched our list archives? http://archives.postgresql.org

Re: [PATCHES] HOT patch - version 15

2007-09-05 Thread Gregory Stark
. It seems an index lookup tries to prune a heap chain, and he was asking if it should look at other chains on the page; I said not. Whether the index lookup should prune the heap chain is another issue. Pruning chains is kind of the whole point of the exercise no? -- Gregory Stark EnterpriseDB

Re: [PATCHES] HOT patch - version 15

2007-09-05 Thread Gregory Stark
already have the page pinned yourself. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about

Re: [PATCHES] WIP patch for latestCompletedXid method of computing snapshot xmax

2007-09-07 Thread Gregory Stark
transactions to work, but on the whole it seems at least as clean as the code we have now. Comments? Just that it will be fascinating to see what effects this has on the benchmarks. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast

Re: [PATCHES] HOT patch - version 15

2007-09-10 Thread Gregory Stark
it unused). -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do

Re: [PATCHES] HOT patch - version 15

2007-09-11 Thread Gregory Stark
aligned. So actually it would never cross a hardware sector boundary. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [PATCHES] Yet more tsearch refactoring

2007-09-11 Thread Gregory Stark
the code will work of course) we should at a minimum be certain that the build farm will detect the problem. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 9: In versions below 8.0, the planner

Re: [PATCHES] WIP patch for latestCompletedXid method of computing snapshot xmax

2007-09-11 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Tom Lane [EMAIL PROTECTED] writes: This patch implements Florian's idea about how to manage snapshot xmax without the ugly and performance-losing tactic of taking XidGenLock and ProcArrayLock at the same time. I had

Re: [PATCHES] PL/TCL Patch to prevent postgres from becoming multithreaded

2007-09-14 Thread Gregory Stark
maintainers for modules of free software are often found anyways. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PATCHES] [COMMITTERS] pgsql: Avoid possibly-unportable initializer, per buildfarm warning.

2007-09-17 Thread Gregory Stark
, sizeof(TheLexeme), cmpLexemeQ); if (res == NULL) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 5: don't forget to increase your free space map settings

[PATCHES] Eliminate more detoast copies for packed varlenas

2007-09-21 Thread Gregory Stark
changed, 5 insertions(+), 364 modifications(!) packed-varlena-efficiency_v0.patch.gz Description: Binary data -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 2: Don't 'kill -9' the postmaster

Re: [PATCHES] [HACKERS] 'Waiting on lock'

2007-09-25 Thread Gregory Stark
database locks for user-visible operations which users can drag out for long periods of time. (Not saying I agree with that design but there are arguments for it and people do do it) -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast

[PATCHES] Packed varlena tuptoaster.c oops

2007-10-11 Thread Gregory Stark
; - toast_sizes[i] = VARSIZE(toast_values[i]); need_change = true; need_free = true; -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 7: You can help support

[PATCHES] Assertion failure with small block sizes

2007-10-14 Thread Gregory Stark
-rd_rel-relkind == RELKIND_UNCATALOGED); /* * Get the tuple descriptor and break down the tuple(s) into fields. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 2: Don't 'kill -9

Re: [PATCHES] Assertion failure with small block sizes

2007-10-14 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: Testing Postgres with a small block size runs into an assertion failure when it tries to toast a pg_proc tuple during initdb. I think the assertion is just wrong and RELKIND_UNCATALOGUED is valid here. Uh, what

Re: [PATCHES] Assertion failure with small block sizes

2007-10-15 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: If I push the TOAST_TUPLES_PER_PAGE up to 16 I get another failure on the same line from trying to toast a sequence. If I add RELKIND_SEQUENCE to the assertion then it passes all regression tests even if I push

Re: [PATCHES] Win32: Minimising desktop heap usage

2007-10-23 Thread Gregory Stark
likely to change and you can always adjust the environment variable manually to fix the problem. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 4: Have you searched our list archives

Re: [PATCHES] Autovacuum cancellation

2007-10-25 Thread Gregory Stark
already fired its deadlock check before it was waiting directly on autovacuum. But the only way I can see it happening is if another process is cancelled before its deadlock check fires and the signals are processed out of order. I'm not sure that's a case we really need to worry about. -- Gregory

Re: [PATCHES] Autovacuum cancellation

2007-10-26 Thread Gregory Stark
if multiple deadlock check signals fire for the same autovacuum? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com ---(end of broadcast)--- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe

Re: [PATCHES] V0.2 patch for TODO Item: SQL-language referenceparameters by name.

2007-11-03 Thread Gregory Stark
when the driver misinterprets the parameters. I think it would be a very bad idea to require that people use the function name in parameters, I think were talking about only allowing it to disambiguate if the name is shadowed by a variable in an inner scope. -- Gregory Stark EnterpriseDB

Re: [PATCHES] Better default_statistics_target

2007-11-19 Thread Gregory Stark
fields take more space and take longer to compare so to make consistent use of resources you would want to avoid storing and comparing large numbers of them whereas you could afford much larger targets for small quick columns. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com

[PATCHES] Ordered Append WIP patch v1

2007-11-22 Thread Gregory Stark
Here's the WIP patch I described on -hackers to implemented ordered append nodes. merge-append-v1.diff.gz Description: Binary data -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's Slony Replication support! ---(end

Re: [PATCHES] [DOCS] Partition: use triggers instead of rules

2007-11-29 Thread Gregory Stark
Joshua D. Drake [EMAIL PROTECTED] writes: Tom Lane wrote: A trigger will probably beat a rule for inserts/updates involving a small number of rows. Which is exactly what partitioning is doing. Say what? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me

Re: [PATCHES] [DOCS] Partition: use triggers instead of rules

2007-11-29 Thread Gregory Stark
triggers over rules if only because rules are just harder to understand. Arguably they don't really work properly for this use anyways given what happens if you use volatile functions like random() in your where clause. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask

Re: [PATCHES] [DOCS] Partition: use triggers instead of rules

2007-11-29 Thread Gregory Stark
partitions should actually receive the updates and deletes. I think triggers are the only solution for insert though. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! ---(end of broadcast

Re: [PATCHES] [GENERAL] Empty arrays with ARRAY[]

2007-11-30 Thread Gregory Stark
[]); could be allowed if they could be contrived to introduce an assignment cast. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! ---(end of broadcast)--- TIP 4: Have you

Re: [PATCHES] Better default_statistics_target

2007-12-05 Thread Gregory Stark
to distinguish the dense areas from the sparse areas. Perhaps something like starting with 1 bucket, splitting it into 2, seeing if the distributions are similar in which case we stop. If not repeat for each bucket. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [PATCHES] Proposed patch to make mergejoin cost estimation more symmetric

2007-12-07 Thread Gregory Stark
make me think you ran them but just didn't show them though. What about a merge join against an empty table? I suppose there would just be no statistics? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support

Re: [PATCHES] Proposed patch to make mergejoin cost estimationmore symmetric

2007-12-07 Thread Gregory Stark
data in there and have it be the UI's responsibility to decide what data to display. When that happens it would be nice to have the raw data used to generate the cost estimations. At least the most important factors. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me

Re: [PATCHES] [HACKERS] OUTER JOIN performance regression remains in 8.3beta4

2008-01-09 Thread Gregory Stark
of it that's not going to help at all. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! ---(end of broadcast)--- TIP 4: Have you searched our list archives? http

Re: [PATCHES] [8.4] Updated WITH clause patch (non-recursive)

2008-01-27 Thread Gregory Stark
so I don't have strong feelings for this part either way. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning ---(end of broadcast)--- TIP 3: Have you checked our

Re: [PATCHES] Proposed patch: synchronized_scanning GUC variable

2008-01-27 Thread Gregory Stark
row ordering. This is a pretty trivial patch, but seeing how late we are in the 8.3 release cycle, I thought I'd better post it for comment anyway. +1 I liked the synchronized_sequential_scans idea myself. But otherwise, sure. -- Gregory Stark EnterpriseDB http

Re: [PATCHES] WIP: plpgsql source code obfuscation

2008-01-28 Thread Gregory Stark
. It would be just another PL language to load which can be installed like other ones. This could be a big advantage because it doesn't look like there is a lot of support for putting th obfuscation directly into the core code. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask

Re: [PATCHES] WIP: plpgsql source code obfuscation

2008-01-28 Thread Gregory Stark
for other applications like compiled languages, though I think they would still want to save the source in prosrc and the bytecode in probin. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training

Re: [PATCHES] WIP: plpgsql source code obfuscation

2008-01-28 Thread Gregory Stark
. In such a scheme I think you would put the key in an attribute of the language. Either in pg_lang or some configuration location which the obfuscate:plperl interpreter knows where to find. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's

Re: [PATCHES] WIP: plpgsql source code obfuscation

2008-01-28 Thread Gregory Stark
stop some other country from coming up with the same idea of course but we don't generally worry about what laws some hypothetical country might introduce at some point in the future. That way lies madness. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about

Re: [PATCHES] Proposed patch: synchronized_scanning GUC variable

2008-01-29 Thread Gregory Stark
for one. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about EnterpriseDB's PostgreSQL training! ---(end of broadcast)--- TIP 6: explain analyze is your friend

Re: [PATCHES] [8.4] Updated WITH clause patch (non-recursive)

2008-01-30 Thread Gregory Stark
perhaps there's a path available which would work for this read of it. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's On-Demand Production Tuning ---(end of broadcast)--- TIP 7: You can help support

[PATCHES] Bitmap index scan preread using posix_fadvise (Was: There's random access and then there's random access)

2008-01-30 Thread Gregory Stark
= construct_array(elems, n, INT4OID, 4, true, 'i'); PG_RETURN_ARRAYTYPE_P(retval); } -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! ---(end of broadcast)--- TIP 7: You can help

Re: [PATCHES] Bitmap index scan preread using posix_fadvise

2008-02-01 Thread Gregory Stark
Gregory Stark [EMAIL PROTECTED] writes: Aside from some autoconf tests and the documentation for the GUC I think it's all in there. I'm sorry, it seems I accidentally grabbed an old tree to generate this patch. I'll send along a better more recent version. Argh. -- Gregory Stark

Re: [PATCHES] Bitmap index scan preread using posix_fadvise

2008-02-01 Thread Gregory Stark
()*100)::integer from generate_series(1,100))); bitmap-preread-v8.diff.gz Description: Binary data -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support! ---(end of broadcast

Re: [PATCHES] Proposed patch for bug #3921

2008-02-03 Thread Gregory Stark
. Not sure how easy it would be to shoehorn into t he like processing, I could look at that if you want. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! ---(end of broadcast

Re: [PATCHES] Proposed patch for 8.3 VACUUM FULL crash

2008-02-11 Thread Gregory Stark
the opposite problem. The patch was fairly heavily tested on this end before it was posted and I'm not sure those tests have been repeated since the merge. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's 24x7 Postgres support

Re: [PATCHES] Logging conflicted queries on deadlocks

2008-03-21 Thread Gregory Stark
the outermost session user's ID instead of current ID, but that might only move the security risks someplace else. Thoughts? Perhaps we should only do this if the current user's ID is the same as the outermost session user's ID? -- Gregory Stark EnterpriseDB http

Re: [PATCHES] Logging conflicted queries on deadlocks

2008-03-21 Thread Gregory Stark
Gregory Stark [EMAIL PROTECTED] writes: There's no way the other transaction's timeout could fire while we're doing this is there? Are we still holding the lw locks at this point which would prevent that? Ah, reading the patch I see comments indicating that yes that's possible and no, we

Re: [PATCHES] int8/float8/time/timestamp[tz]/float4 passed by value, was Re: Fix HAVE_LONG[_LONG]_INT_64 to really define to 1

2008-03-24 Thread Gregory Stark
of the passbyval nature of int8, the !AggState version is not slower than using the pointer directly. Does this mean count() and sum() are slower on a 32-bit machine? -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Get trained by Bruce Momjian - ask me about

Re: [PATCHES] int8/float8/time/timestamp[tz]/float4 passed by value, was Re: Fix HAVE_LONG[_LONG]_INT_64 to really define to 1

2008-03-24 Thread Gregory Stark
. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask me about EnterpriseDB's RemoteDBA services! -- Sent via pgsql-patches mailing list (pgsql-patches@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-patches

Re: [PATCHES] Re: int8/float8/time/timestamp[tz]/float4 passed by value, was Re: Fix HAVE_LONG[_LONG]_INT_64 to really define to 1

2008-03-24 Thread Gregory Stark
Zoltan Boszormenyi [EMAIL PROTECTED] writes: Zoltan Boszormenyi írta: Gregory Stark írta: 4) Your problems with tsearch and timestamp etc raise an interesting problem. We don't need to mark this in pg_control because it's a purely a run-time issue and doesn't affect on-disk storage

Re: [PATCHES] Consistent \d commands in psql

2008-03-31 Thread Gregory Stark
as we add more and more system functions too. It might be cute to see if the pattern matches any user functions and if not try again with system functions. So you would still get results if you did \df rtrim for example. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com Ask

Re: [PATCHES] Consistent \d commands in psql

2008-03-31 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: It might be cute to see if the pattern matches any user functions and if not try again with system functions. So you would still get results if you did \df rtrim for example. Interesting idea. IIUC, \df would give

Re: [PATCHES] Consistent \d commands in psql

2008-03-31 Thread Gregory Stark
Tom Lane [EMAIL PROTECTED] writes: Gregory Stark [EMAIL PROTECTED] writes: One --perhaps nice, perhaps not-- property of this is that if you defined a function named rtrim and then did \df rtrim it would show you _both_ the system and user function and make it easier to see the conflict

Re: [PATCHES] Consistent \d commands in psql

2008-04-01 Thread Gregory Stark
of non-globbing cases for pattern. As in, I would want \df rtrim to work. I suppose it could be annoying to have to type \df public.* -- there's nothing stopping us from having \dfU and \dfS too I suppose, though I doubt most people would find them. -- Gregory Stark EnterpriseDB http

<    1   2   3   >