Re: [HACKERS] Parsing config files in a directory

setting changes aren't being overridden by config files parsed later than we might expect from external tuning tools. Magnus, was there anything else you wanted feedback on here? -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list

Re: [HACKERS] a question about relkind of RelationData handed over to heap_update function

too. There's example of how to use it in the documentation for that module and I've got some additional ones on my web page at http://www.westnet.com/~gsmith/content/postgresql in the slides and examples for Inside the PostgreSQL Buffer Cache. -- * Greg Smith gsm...@gregsmith.com http

Re: [HACKERS] Parsing config files in a directory

(which includes SET PERSISTENT) should have to interact with the primary postgresql.conf is just to confirm that include directive exists before they create/update a simpler config file in the directory. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql

Re: [HACKERS] Parsing config files in a directory

a Windows-oriented glob: http://cpansearch.perl.org/src/TATE/File-Glob-Windows-0.1.3/lib/File/Glob/Windows.pm you can see it even worries about things like correctly handling the fact that there's a current directory on each drive in Windows land. -- * Greg Smith gsm...@gregsmith.com http

Re: [HACKERS] Parsing config files in a directory

enough to figure out where the directory(s) of additional config files is at. That level of config file manipulation there's already code for in initdb, I was planning to refactor that into a library I can include for the built-in pgtune I've been planning. -- * Greg Smith gsm...@gregsmith.com

Re: [HACKERS] Parsing config files in a directory

introducing it says, the goal this aims at is making life easier for tool builders. I think you're extrapolating beyond its intended scope in your evaluation of what problem it's aiming to solve. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers

Re: [HACKERS] per table random-page-cost?

. This is only because your A/R collections staff includes people with guns. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] Going, going, GUCs!

the postgresql.conf file easier to work with. That needs a much larger pruning before moving in that direction is actually going to help anyone. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] per table random-page-cost?

. Allowing a user-set value for that is a lot more reasonable if the system computes a reasonable one itself under normal circumstances. That's what I think people really want, even if it's not what they're asking for. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD

Re: [HACKERS] Wire protocol docs

://www.postgresql.org/docs/8.4/static/libpq-envars.html and http://www.postgresql.org/docs/8.4/static/libpq-connect.html are what I think it's alluding to here. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints

possible, so you might as well start with that if the simpler views can be derived from them. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] how to use eclipse when debugging postgreSQL backend

This whole discussion looked helpful to save, I put a summary of the issue and the suggested solution at https://wiki.postgresql.org/wiki/Working_with_Eclipse#Debugging_with_child_processes so nobody has to reinvent this. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore

Re: [HACKERS] COPY enhancements

manipulate the rejects as simple text. Making that harder just for this edge case wouldn't match the priorities of the users of this feature I've encountered. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Concurrency testing

on the buildfarm, which makes something written in it useful here, while Tsung is not. Unfortunately. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] COPY enhancements

. If the performance only suffers when you're targeting unclean data, the users this feature targets will glady accept that trade-off. You're still way ahead of the other options here at the finish line. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql

Re: [HACKERS] COPY enhancements

and batch size parts are the trivial and well understood parts here. Actually getting all this to play nicely with transactions and commit failures (rather than just bad data failures) is what's difficult. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql

Re: [HACKERS] [PATCH] pgbench: new feature allowing to launch shell commands

for the next CommitFest, where I think it can be a useful feature to add. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] COPY enhancements

a public git repo or something to serve as an integration point for dependency merge management and testing that resists bit-rot while splitting things up functionally. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] Concurrency testing

there impact existing committer's daily workflow. The complexity level of test you need to find the juicy concurrent issues is not one you're going to want to run every time you do make check. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers

Re: [HACKERS] COPY enhancements

, but as it is people interested in it can't consider it without also staring at the logging stuff. And people who are focusing on the logging bits find it distracting, so nobody is really happy with the current combined patch. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com

Re: [HACKERS] COPY enhancements

On Wed, 7 Oct 2009, Robert Haas wrote: On Wed, Oct 7, 2009 at 3:17 AM, Greg Smith gsm...@gregsmith.com wrote: I doubt taskmaster Robert is going to let this one linger around with scope creep for too long before being pushed out to the next CommitFest. I'm can't decide whether to feel good

Re: [HACKERS] Concurrency testing

is sufficient for what David had in mind I can't say. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Performance testing framework..

of things, but basically one test at a time. The specific piece I've been working on lately is spawning off system monitoring daemons to collect information during the test, I think I'm on my 3rd generation of trying to get a solution I'm happy with to that problem. -- * Greg Smith gsm

Re: [HACKERS] [PATCH] pgbench: new feature allowing to launch shell commands

as an integer for this to work right, there may be some int vs. string considerations here) If you got something like that working first before moving onto these more complicated examples and I think you'll have an easier time of things. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com

Re: [HACKERS] Linux LSB init script

to immediate for the sake of other programs that can shut themselves down more cleanly if the server goes through the fast shutdown stage first. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Feedback on getting rid of VACUUM FULL

-mover if it could serve both purposes. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] generic copy options

. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Elementary dependency look-up

GROUP BY n1.nspname,c1.relname,c1.oid,c1.relkind, n2.nspname,c2.relname,c2.oid,c2.relkind ORDER BY n1.nspname,c1.relname; I could throw this on the Wiki as a code snippet if anyone else wanted to tinker with it. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD

Re: [HACKERS] Streaming Replication patch for CommitFest 2009-09

familiar with the replication internals can help me nail down a spec on what to watch. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] COPY enhancements

significant contortions. I don't think that's really true though, and would like to keep open the possibilty of accepting some simple but useful ad-hoc features in this area, even if they don't solve every possible problem in this space just yet. -- * Greg Smith gsm...@gregsmith.com http

Re: [HACKERS] COPY enhancements

collected by the code block with the comment Get default info if needed. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] COPY enhancements

in this area or considered writing one showing up just among people on the hackers list. That should be hint as to how common these requests are. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] COPY enhancements

these cleanly into separate patches where the partitioning one depends on the logging one before even starting to look at the code, it's too much stuff to consume properly in one gulp. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Linux LSB init script

platforms. Your code is interesting but I'm not sure what problem it's intended to solve yet. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] 8.5 release notes idea

to contribute someday! I think any Bruce or Tom who tries to submit a patch will have to be given a funny nickname instead. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Linux LSB init script

the standard approach due to its slots implementation. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] 8.5 release timetable, again

/026142.html -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Memory context usage

stuff I'm suspicious of, using something like this passed the PID of the process I want to watch: #!/bin/bash gdb -p $1 EOF p MemoryContextStats(TopMemoryContext) detach quit EOF -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list

Re: [HACKERS] machine-readable explain output v4

the source code is available for the web app, that puts you back to needing to install the tool locally, and I've found web apps tend to be more complicated to get running than a typical standalone app. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql

Re: [HACKERS] Hot standby and synchronous replication status

to: 1) Enable archiving 2) pg_start_backup 3) rsync/tar/cpio/copy/etc. 4) pg_stop_backup 5) Disable archiving Because the default archive_command was something that supported a filesystem snapshot using a standard layout. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD

Re: [HACKERS] multi-threaded pgbench

. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] multi-threaded pgbench

want to chew on right now. I'll have updated performance results to submit later this week against the updated patch. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Upgrading our minimum required flex version for 8.5

-source-rpm-to.html Kind of annoying, but as special software you have to install on a server just to build something from CVS goes it's only a minor inconvenience. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] multi-threaded pgbench

-safety fixed first so that I can queue up and compare both versions when I go through that. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Docbook toolchain interfering with patch review?

this could be straightforward (I shudder to think what a Cygwin guide would look like), that would make it much easier to push toward having more people do doc review. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] Mysql.whynot or PG vs MySQL comparison table?

/mailsoftware42/db/ http://en.wikibooks.org/wiki/Converting_MySQL_to_PostgreSQL -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

Re: [HACKERS] multi-threaded pgbench

on anyway in the next month as part of my standard performance testing on new hardware. I'll be happy to mix in results using the multi-threaded pgbench to check the patch's performance, along with the rest of the initial review here. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com

Re: [HACKERS] multi-threaded pgbench

that goes into the log file. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] HEAD is open for 8.5 development

with timestamp, and it expands to --; that makes it easy to remember this particular bit. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] 8.4 open item: copy performance regression?

going down via increased shared_buffers that people tend to run into during beta. You can check via psql with show debug_assertions; -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] 8.4 open item: copy performance regression?

of WAL written during a particular chunk of code? We may need some sort of checkpoint/sync after the test to get correct results, because I've noticed that the tests I run sometimes continue writing out buffers for a few seconds after the test time is finished. -- * Greg Smith gsm

Re: [HACKERS] 8.4 open item: copy performance regression?

of problem than the whole ring buffer idea, which is a great start but bound to run into situations where the size of the buffer just isn't right anymore a few hardware generations down the road. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers

Re: [HACKERS] 8.4 open item: copy performance regression?

buffer? situation. Obviously actual measurements here would trump any theorizing as to what works better, it's hard to get any intuition about low-level optimizing given how complicated CPU caches are nowadays. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent

Re: [HACKERS] Managing multiple branches in git

=.git --exclude-dir=.svn --exclude=TAGS' The other alternative is to use ack: http://betterthangrep.com/ and have some better defaults. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] 8.4 open item: copy performance regression?

here involved as well. In any case, a bump of the ring multiplier to either 4096 or 8192 eliminates the worst of the regression here, good improvement so far. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] pg_migrator mention in documentation

of these topics on the wiki if this idea seems reasonable to the community, there are rough articles there already for all three ideas I can pull from. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Resolving 8.4 open items

in the last year building community consensus in this area, and I'd like to get at least an intro to that into the official docs. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] search_path vs extensions

to use the simplest possible schema standard that works for extensions and decouple the problems from one another if any progress is going to get made here. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] PostgreSQL Developer meeting minutes up

amount of time wasted playing around with tags that results in no benefit to users of the software. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] PostgreSQL Developer meeting minutes up

with things like these fleshed out git requirements. Example: http://wiki.postgresql.org/wiki/PgCon_2009_Developer_Meeting#Source_Code_Management Thoughts? -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] pg_migrator and an 8.3-compatible tsvector data type

. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] commitfest management webapp

to add support for foo rather than foo. I wasn't suggesting you pull the subject line and use it as a key for anything, was just thinking it would be nice to display it, as a way to double-check it points to the right place. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore

Re: [HACKERS] sun blade 1000 donation

. It's a tower form factor through, right? That would make it hard to install some places. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] effects of posix_fadvise on WAL logs

to the WAL log, partially negating the goal of using a smaller interval, and in any case causing more disk I/O. You've got checkpoint_segments set to 3000 in your tests and checkpoint_time to 1 hour, which means the tests you ran are really generating minimal WAL volume. -- * Greg Smith gsm

Re: [HACKERS] commitfest management webapp

own in this sort of situation. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] generic options for explain

immediate useful value were it to be committed. Something that returns a setof can also be easily used to implement the dump EXPLAIN to a table feature Josh Tolley brought up (which is another common request in this area). -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD

Re: [HACKERS] generic options for explain

/ A note about that got sent to this list at one point but I don't see any follow-up: http://archives.postgresql.org/pgsql-hackers/2008-06/msg00802.php Anybody have a better idea of what happened with that project than me? -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore

[HACKERS] Revisiting default_statistics_target

to actually do that, I really don't get a vote here anyway. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Revisiting default_statistics_target

that would be good for DW users, but not anyone else, that you were just making critical comments about. Anyway, thanks to Stephen for concisely clarifying the position I was trying to present here, which is quite different from the one you were arguing against. -- * Greg Smith gsm...@gregsmith.com

Re: [HACKERS] pg_views definition format

into the parsed form and returns it: $ v=select * from pg_views $ p=`psql -Atc create temporary view x as ${v}; select pg_get_viewdef('x'::regclass);` $ echo $p SELECT pg_views.schemaname, pg_views.viewname, pg_views.viewowner, pg_views.definition FROM pg_views; -- * Greg Smith gsm...@gregsmith.com

Re: [HACKERS] Patch to fix search_path defencies with pg_bench

. That can leave you with a longer effective path to search. Pretty unlikely to be a problem in the field though. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Patch to fix search_path defencies with pg_bench

that thrown into the mix right now. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Patch to fix search_path defencies with pg_bench

on such behavior could be rudely surprised at this change. For all I know I'm the only person to ever actually run into that particular situation though. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

Re: [HACKERS] Closing some 8.4 open items

-10/msg01482.php and the above MySQL documentation supports that it works on FreeBSD, too. I've seen claims that it works fine on Mac OS X, too, although MySQL may not support that: http://labs.cybozu.co.jp/blog/kazuhoatwork/2009/02/using_o_direct_on_mac_os_x.php -- * Greg Smith gsm

Re: [HACKERS] Closing some 8.4 open items

to POSIX_FADV_SEQUENTIAL, in order to show any improvement from that patch. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql

Re: [HACKERS] improving concurrent transactin commit rate

well spent, some of the most interesting parts of the codebase to understand from a low-level performance tuning perspective are in those two. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org

[HACKERS] Resetting cluster-wide statistics

of pgstat.c? -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Resetting cluster-wide statistics

that puts something similar back, perhaps with a more targeted UI given that pg_stat_reset has taken over its original primary function. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] Prepping to break every past release...

couple of template pieces I always end up needing for the various types of joins that always pop up and customize from there. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] The science of optimization in practical terms?

, but if the background writer is doing enough of them for you that should at least be asynchronous from when most backends are blocked waiting for an eviction. And that's as far as I got before I had to return to real work again. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD

Re: [HACKERS] A deprecation policy

. In trivial cases like sort_mem-work_mem, adding some backward compatibility concessions might make sense. Saddling GUC changes with any restrctions beyond what happens to be easy seems pretty impractical. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql

Re: [HACKERS] [PATCH] Space reservation v02

; that's how I found all those so fast. As just that subset consists of 22 threads, it's kind of messy to sort through most other ways. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes

Re: [HACKERS] pg_upgrade project status

the original script works as expected on the database problems it tries to solve rather than play with programming languages, I didn't think reporting progress just on that front was particularly exciting. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers

Re: [HACKERS] 8.4 release planning

? -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] 8.4 release planning

with SEPostgreSQL are concerned. It will just hint toward using a schema design with table-level controls instead if you care about high performance on that style of join. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql

Re: [HACKERS] pg_upgrade project status

of boring work volunteers on a project are traditionally good at, and you can expect any developers who aren't managing databases too large to dump/reload to scream about how it will slow the advance of the project. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent

[HACKERS] pgtune: postgresql.conf wizard

made most things pull right from the fields now. That cut out some code that was only supporting that poor data hiding. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD pgtune-0.9.0.tar.gz Description: Binary data -- Sent via pgsql-hackers mailing list (pgsql-hackers

Re: [HACKERS] New pg_dump patch, --no-stats flag, disables sending to statistics collector

the documentation suggesting such a syntax because I think this would be handy for a lot of people. I was already planning to do that for another use case (pgbench) once the 8.4 work here shifts from development to testing and I have some more time for writing. -- * Greg Smith gsm...@gregsmith.com http

Re: [HACKERS] Proposal: new border setting in psql

normally want next in this sort of situation is some more table input designed to render badly for testing. I'll see what I can put together there, I am rather good at breaking code. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing

Re: [HACKERS] Proposal: new border setting in psql

wants to try removing some escapes to make it prettier the onus is on them to try that without breaking things. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription

Re: [HACKERS] Improving compressibility of WAL files

to fill in for this particular requirement. Luckily there are many to choose from if it comes to that. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http

Re: [HACKERS] Improving compressibility of WAL files

been able to measure the impact of the similar case where zero-filling a brand new segment can impact things; this would be much less like to happen because the timing would have to line up just wrong, but I think it's still possible. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com

Re: [HACKERS] Proposal: new border setting in psql

is somewhat perilious as a known limitation. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Proposal: new border setting in psql

threw in his +1 too. So just on the relatively small -hackers list we're up to three people who think it's a nice addition. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your

Re: [HACKERS] Proposal: new border setting in psql

the rules that exist only via the code implementation it seems to me the only robust way around it is to just escape every special character. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make

Re: [HACKERS] Proposal: new border setting in psql

On Thu, 8 Jan 2009, D'Arcy J.M. Cain wrote: On Thu, 8 Jan 2009 13:51:44 -0500 (EST) Greg Smith gsm...@gregsmith.com wrote: A. Einstein was a really smart dude. Which character in the above example would you escape. . is on the long list of characters to be escaped I sent out earlier

Re: [HACKERS] Improving compressibility of WAL files

as possible. I think (1) is a better solution than most of these in the context of an improvement to core, with (4) pglesslog being the main other contender because of how it provides additional full-page write improvements. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD

Re: [HACKERS] Do we still need constraint_exclusion?

On Wed, 7 Jan 2009, Simon Riggs wrote: Who can set up an inherited table structure but can't remember to turn on constraint_exclusion? I thought the whole point of the WIP Auto Partitioning Patch was exactly to enable larger numbers of such people in the future. -- * Greg Smith gsm

Re: [HACKERS] version() output vs. 32/64 bits

. Again, you can just parse it out if that starts being included, but it would be cleaner to grab just that one piece. (Right now I just look at the maximum value for one of the settings I know changes size to figure that out when this pops up) -- * Greg Smith gsm...@gregsmith.com http

Re: [HACKERS] posix_fadvise v22

a stack of candidate ones I ran the earlier tests on to compare results against. -- * Greg Smith gsm...@gregsmith.com http://www.gregsmith.com Baltimore, MD -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref

<    7   8   9   10   11   12   13   14   15   16   >