Re: [HACKERS] Synchronous Log Shipping Replication

2008-09-10 Thread Aidan Van Dyk
, but can feed clients accross slow WAN links (that may not have the burst bandwidth to keep up with bursty master writes, but have agregate bandwidth to keep pretty close to the master), or networks that drop out for a period, etc. -- Aidan Van Dyk Create like

Re: [HACKERS] Proposal of SE-PostgreSQL patches (for CommitFest:Sep)

2008-09-24 Thread Aidan Van Dyk
many have just disabled it because it prevented what they thought should be a valid operation? I'm sure NSA can do both of these, but I would hazard that the number of other people able to do this well can probably be counted on my fingers... a. -- Aidan Van Dyk

Re: [HACKERS] Block-level CRC checks

2008-10-01 Thread Aidan Van Dyk
calculate your CRC, you're doing it on a local copy of the block, which you hand to the OS to write... If you're touching the whole block of memory to CRC it, it isn't *ridiculously* more expensive to copy the memory somewhere else as you do it... a. -- Aidan Van Dyk

Re: [HACKERS] Block-level CRC checks

2008-10-01 Thread Aidan Van Dyk
with a very high concurrency, high-write load... a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave. signature.asc

Re: [HACKERS] Block-level CRC checks

2008-10-02 Thread Aidan Van Dyk
be = the time of the write() syscall... Your fsync is your on disk guarentee, not the write, and that won't change. But I thought you didn't really care about hint-bit updates, even in the current strategy... but I'm fully ignorant about the code, sorry... a. -- Aidan Van Dyk

Re: [HACKERS] Block-level CRC checks

2008-10-02 Thread Aidan Van Dyk
... a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description: Digital signature

Re: [HACKERS] Block-level CRC checks

2008-10-02 Thread Aidan Van Dyk
CRC32 as well... -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description: Digital signature

Re: [HACKERS] Block-level CRC checks

2008-10-02 Thread Aidan Van Dyk
* is irrelevant, because it wasn't read from disk, it was completely constructed from WAL records, which are protected by checksums themselves individually..., and is now ready to be written to disk which will force a valid checksum to be on it. a. -- Aidan Van Dyk

Re: [HACKERS] Block-level CRC checks

2008-10-02 Thread Aidan Van Dyk
), so on next read... Without the CRC it doesn't matter, because the only change was hint-bits, so the page is half-old+half-new, but new == old+only hint-bits... Because ther'es no WAP. the torn page will be read next time that buffer is needed... a. -- Aidan Van Dyk

Re: [HACKERS] Block-level CRC checks

2008-10-02 Thread Aidan Van Dyk
that aren't high-velocity can probably spare a bit more Xlog bandwith anyways... But my experience is limitted to my small-scale databases... -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like

Re: [HACKERS] Block-level CRC checks

2008-10-03 Thread Aidan Van Dyk
the code a bit better... a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description: Digital

Re: [HACKERS] spoonbill is failing citext test

2008-10-14 Thread Aidan Van Dyk
-- a usage: diff [ -C n ] [ -S name ] [ -bcefhilnrstw ] dir1 dir2 diff [-C n ] [ -bcefhintw ] file1 file2 diff [ -D string ] [ -biw ] file1 file2 I'll bet /usr/bin/make pukes on PostgreSQL make files there too ;-) a. -- Aidan Van Dyk

Re: [HACKERS] Block-level CRC checks

2008-10-17 Thread Aidan Van Dyk
* to get a WAL backup of the block at some *any* point before the block's written to save from the torn-page on recovery leading to an inconsistent CRC. a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command

Re: [HACKERS] Multi CPU Queries - Feedback and/or suggestions wanted!

2008-10-24 Thread Aidan Van Dyk
any time in the near future... -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description

Re: [HACKERS] Block-level CRC checks

2008-11-13 Thread Aidan Van Dyk
that to be able to checksum the special space as well. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave. signature.asc

Re: [HACKERS] Block-level CRC checks

2008-11-13 Thread Aidan Van Dyk
WAL logged even for blocks written that aren't hint-bit only You trade WAL and simplicity for verifiable integrety. a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http

Re: [HACKERS] Block-level CRC checks

2008-11-17 Thread Aidan Van Dyk
, not dirty with already-wal-logged changes) -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave. signature.asc

Re: [HACKERS] Block-level CRC checks

2008-11-17 Thread Aidan Van Dyk
up? -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description: Digital signature

Re: [HACKERS] Block-level CRC checks

2008-11-17 Thread Aidan Van Dyk
* Matthew T. O'Connor [EMAIL PROTECTED] [081117 15:19]: Aidan Van Dyk wrote: * Greg Stark [EMAIL PROTECTED] [081117 03:54]: I thought of saying that too but it doesn't really solve the problem. Think of what happens if someone sets a hint bit on a dirty page. If the page is dirty from

Re: [HACKERS] Block-level CRC checks

2008-11-18 Thread Aidan Van Dyk
. then your consitent. At least as consistent as the original write was. So you're CRC ends up being: Buffer the page Calculate CRC on the buffered page WAL (in bulk) the hint bits (and maybe CRC?) write buffered page -- aidan van dyk create

Re: [HACKERS] Block-level CRC checks

2008-11-18 Thread Aidan Van Dyk
* Tom Lane [EMAIL PROTECTED] [081118 12:43]: Aidan Van Dyk [EMAIL PROTECTED] writes: But why can't you wal-log the hint bits from the buffered page. then your consitent. At least as consistent as the original write was. So you're CRC ends up being: Buffer the page Calculate

Re: [HACKERS] default_stats_target WAS: Simple postgresql.conf wizard

2008-12-02 Thread Aidan Van Dyk
) bias is showing, but nobody else has (yet) showed otherwise ;-) a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave

Re: [HACKERS] Sync Rep: First Thoughts on Code

2008-12-10 Thread Aidan Van Dyk
* then connect and allow sync rep 2. Preferred Choice * connect to primary and allow sync rep * catch up Call me think, but I'm confused... In sync rep, there *can't be* any catchign up do do... i.e. if the slave isn't accepting the WAL the master stops doing *anything*... -- Aidan Van Dyk

Re: [HACKERS] cvs head initdb hangs on unixware

2008-12-10 Thread Aidan Van Dyk
you call it is still arbitrary... But where that line is drawn currently defined in the buildfarm code... Not that it can't be changed, but I thin there's much better things to worry about ;-) a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED

Re: [HACKERS] Block-level CRC checks

2009-11-30 Thread Aidan Van Dyk
into place... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description: Digital signature

Re: [HACKERS] Block-level CRC checks

2009-12-01 Thread Aidan Van Dyk
that information into the buffer in/out would be a huge wart on the modularity of the PG code... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca

Re: [HACKERS] Block-level CRC checks

2009-12-01 Thread Aidan Van Dyk
of gigs, so I acknowledge my priorities are probably quite different then some of the companies driving a lot of the heavy development. a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http

Re: [HACKERS] Block-level CRC checks

2009-12-01 Thread Aidan Van Dyk
seem to hold with flash/SSD's too... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc

Re: [HACKERS] Backup history file should be replicated in Streaming Replication?

2009-12-22 Thread Aidan Van Dyk
synchronously writes WAL into an archive directory setup is exactly what I want... And once SR has settled, it's something I'm interested in working on... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command

Re: [HACKERS] Add .gitignore files to CVS?

2010-01-09 Thread Aidan Van Dyk
properly :-) It's already been done. It was not a lot of work (just processor time). It's even already been posted to -hackers, including what the differences were (i.e. which $Tags$ differed, and where, and where the CVS history had been hacked by hand). a. -- Aidan Van Dyk

Re: [HACKERS] Add .gitignore files to CVS?

2010-01-11 Thread Aidan Van Dyk
* Magnus Hagander mag...@hagander.net [100109 13:05]: On Sat, Jan 9, 2010 at 18:33, Aidan Van Dyk ai...@highrise.ca wrote: * Magnus Hagander mag...@hagander.net [100109 12:03]: If that's the only remaining obstacle, I'm willing to work up some test scripts around that. But I'm not going

Re: [HACKERS] mailing list archiver chewing patches

2010-01-12 Thread Aidan Van Dyk
is not truly the right tool for the job, but we might be able to customise it to suit our needs. Are there any other requirements that weren't specified? -- Aidan Van Dyk Create like a god, ai...@highrise.ca command

Re: [HACKERS] mailing list archiver chewing patches

2010-01-12 Thread Aidan Van Dyk
as new messages are delivered, etc. Documented queries that show how to use CTEs, ltree, etc to get threaded views, good FTS support (with indexes and triggers managing them), etc. a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca

Re: [HACKERS] plpython3

2010-01-14 Thread Aidan Van Dyk
, because we *all* will appreciate it... -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc

Re: [HACKERS] Streaming replication and non-blocking I/O

2010-01-15 Thread Aidan Van Dyk
change... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description: Digital signature

Re: [HACKERS] Git out of sync vs. CVS

2010-01-19 Thread Aidan Van Dyk
projects too, so I needed it for my own conversions... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave

Re: [HACKERS] Git out of sync vs. CVS

2010-01-19 Thread Aidan Van Dyk
, do a one-time conversion (a la parsecvs/cvs2git) and get on with life... As long as CVS is the tool of choice, pretty good is really good... -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king

Re: [HACKERS] 8.5 vs. 9.0, Postgres vs. PostgreSQL

2010-01-22 Thread Aidan Van Dyk
database... So despite that they have no idea what SQL actually means, or where it came from, it's got the desired association. So, my neck of the woods ain't necessarily yours, but... -- Aidan Van Dyk Create like a god, ai...@highrise.ca

Re: [HACKERS] MySQL-ism help patch for psql

2010-01-25 Thread Aidan Van Dyk
a section for whoever has an itch. a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description

Re: [HACKERS] development setup and libdir

2010-01-30 Thread Aidan Van Dyk
that the PGXS gripes Ivan has are valid, but your perl example probably *supports* his case more than you think... -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca

Re: [HACKERS] PG 9.0 and standard_conforming_strings

2010-02-03 Thread Aidan Van Dyk
into another release and another year of it. a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL

2010-02-10 Thread Aidan Van Dyk
the requirements... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description: Digital signature

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL

2010-02-11 Thread Aidan Van Dyk
, because I'm going to cry... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL

2010-02-11 Thread Aidan Van Dyk
of plain SCP, etc. So ya, we should probably mention that somewhere in the docs. Section 24.3.6. Caveats? a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make standby server continuously retry restoring the next WAL

2010-02-11 Thread Aidan Van Dyk
consistently... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description: Digital signature

Re: [HACKERS] Re: Hot Standby query cancellation and Streaming Replication integration

2010-02-26 Thread Aidan Van Dyk
again can be a HUP'able knob so I can change it occasionally without taking the server down... -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca

Re: [HACKERS] Hot Standby query cancellation and Streaming Replication integration

2010-02-26 Thread Aidan Van Dyk
, the royal we) be willing to say that if you want the benifit of removing the MVCC overhead of long-running queries you need to run PITR backup/archive recovery, and if you want SR, you get a closed-loop master-follows-save-xmin behaviour? a. -- Aidan Van Dyk

Re: [HACKERS] Re: Hot Standby query cancellation and Streaming Replication integration

2010-03-01 Thread Aidan Van Dyk
successively is a good idea... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description

Re: [HACKERS] Questions about 9.0 release note

2010-03-31 Thread Aidan Van Dyk
comparisons ... These isn't wrong, but if people are being confused about the objects these refer to, being explicit can at least avoid that confusion. a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-12 Thread Aidan Van Dyk
of them in buffers (shared, or OS cache), but the WAL producer, by it's very nature being a multi-task-io-load producing random read/write is always going to go quicker than single-stream random-io WAL consumer... a. -- Aidan Van Dyk Create like a god, ai

Re: [HACKERS] testing HS/SR - 1 vs 2 performance

2010-04-12 Thread Aidan Van Dyk
And I see now that he's doing a stream of read-only queries on a slave, presumably with no WAL even being replayed... Sorry for the noise a. * Aidan Van Dyk ai...@highrise.ca [100412 09:40]: * Robert Haas robertmh...@gmail.com [100412 07:10]: I think we need to investigate this more

Re: [HACKERS] Thoughts on pg_hba.conf rejection

2010-04-14 Thread Aidan Van Dyk
, and works for both no entry, and a rejecting entry... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave

Re: pg_start_backup and pg_stop_backup Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

2010-04-28 Thread Aidan Van Dyk
all be done in userspace with just PG (and pg-compatible) tool, etc... -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like

Re: pg_start_backup and pg_stop_backup Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

2010-04-28 Thread Aidan Van Dyk
they talked about in their presentation... -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

2010-04-29 Thread Aidan Van Dyk
... And I'll make sure I look more carefully at logs when deploying 9 as well ;-) a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

2010-04-29 Thread Aidan Van Dyk
config of: wal_mode = hot_standby recovery_connections = on Make it set to generate enough WAL and actually do recovery connections. But also make the recover_connections boolean really mean what it s called. It's not called try_recovery_connections a. -- Aidan Van Dyk

Re: [HACKERS] Re: [COMMITTERS] pgsql: Make CheckRequiredParameterValues() depend upon correct

2010-04-29 Thread Aidan Van Dyk
, but in a slightly different state... But I know that's just a preference... And one from an old-school unix admin too... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca

Re: [HACKERS] missing file in git repo

2010-05-03 Thread Aidan Van Dyk
really fantastic git presentations... He's done them to many of the local *UGs, Is there interest from the core committers in getting one done at PGcon? a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca

Re: [HACKERS] missing file in git repo

2010-05-03 Thread Aidan Van Dyk
of broken CVS checkouts... Of course, if the repository was git, the buildfarm wouldn't need to worry if the git repository/commit it's fetching is a good approximation of the CVS ;-) a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca

Re: [HACKERS] max_standby_delay considered harmful

2010-05-10 Thread Aidan Van Dyk
a reasonable estimate as to when data I know is live on the primary will be seen on the standby... bonus points if it works similarly for archive recovery ;-) a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca

Re: [HACKERS] BYTEA / DBD::Pg change in 9.0 beta

2010-05-19 Thread Aidan Van Dyk
* Magnus Hagander mag...@hagander.net [100519 11:08]: How do the distros generaly deal with that? E.g. do we have to wait for RHEL7 for it to actually show up in redhat? Don't worry, 9.0 won't show up in redhat for a while yet either... ;-) -- Aidan Van Dyk

Re: [HACKERS] Hacking on PostgreSQL via GIT

2007-04-16 Thread Aidan Van Dyk
Martin Langhoff wrote: Hi Florian, I am right now running an rsync of the Pg CVS repo to my work machine to get a git import underway. I'm rather keen on seeing your cool PITR Pg project go well and I have some git+cvs fu I can apply here (being one of the git-cvsimport maintainers) ;-)

Re: [HACKERS] Hacking on PostgreSQL via GIT

2007-04-16 Thread Aidan Van Dyk
* Aidan Van Dyk [EMAIL PROTECTED] [070416 14:08]: Note that this is a special conversion - I intentionally unmunge all the $PostgreSQL$ tags in this repo. Blah - and I just noticed that I actually missed the $PostgreSQL$ (although I did catch the Date/Modified/From/etc)... I hate

Re: [HACKERS] Hacking on PostgreSQL via GIT

2007-04-16 Thread Aidan Van Dyk
on repo.or.cz. I'm now just putting conversion notes up in the public branch... IT's *not* a PostgreSQL branch. a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca

Re: [HACKERS] Hacking on PostgreSQL via GIT

2007-04-16 Thread Aidan Van Dyk
* Tom Lane [EMAIL PROTECTED] [070416 19:03]: Aidan Van Dyk [EMAIL PROTECTED] writes: Would anyone know if these were hand moved to Attic? Seems unlikely, since there's a commit log entry for the removal. But this all happened seven-plus years ago and I'm sure there's an old CVS bug

Re: [HACKERS] Hacking on PostgreSQL via GIT

2007-04-16 Thread Aidan Van Dyk
again. So it's still a gotcha if you're trying to get a copy of CVS from ages ago via one of the alternative SCM conversions... But my git one works, so I'll let others worry about the others ;-) a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED

Re: [HACKERS] Hacking on PostgreSQL via GIT

2007-04-17 Thread Aidan Van Dyk
that my conversion is *not* a direct CVS import - I intentionally *unexpand* all Keywords before stuffing them into GIT so that merging and branching can ignore all the Keyword conflicts... a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED

Re: [HACKERS] Hacking on PostgreSQL via GIT

2007-04-17 Thread Aidan Van Dyk
is that we don't really need an official one... And with GIT, you can even graft history in if you want. So you could even start your GIT work from a cvs checkout of whenever, and graft any commit from any of the CVS-GIT conversion history as a parent to your starting point. a. -- Aidan Van Dyk

Re: [HACKERS] Hacking on PostgreSQL via GIT

2007-04-18 Thread Aidan Van Dyk
regularly see Modified, Date, Id, Log, etc keywords, as well as project specific ones like PostgreSQL, OpenBSD, FreeBSD, etc... Un-expansion *may* not be perfect... a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED

Re: [HACKERS] Hacking on PostgreSQL via GIT

2007-04-18 Thread Aidan Van Dyk
enough that I have it everywhere. I realise not everyone's that lucky.. ;-) a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work

Re: [HACKERS] Hacking on PostgreSQL via GIT

2007-04-18 Thread Aidan Van Dyk
* Aidan Van Dyk [EMAIL PROTECTED] [070418 15:03]: Then how do you tell what version a file is if it's outside of a checkout? That's what all the fun is about ;-) Some would say that labelling the file is the job of the release processes. Others say it's the job of the SCM system

Re: [HACKERS] Hacking on PostgreSQL via GIT

2007-04-30 Thread Aidan Van Dyk
* recommend using at least 1.5 (1.5.2.X is current stable). Please, do your self a favour, and don't use 1.4.4. a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca

Re: [HACKERS] What is happening on buildfarm member baiji?

2007-05-14 Thread Aidan Van Dyk
allows the new server to listen again right away. a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave

Re: [HACKERS] Not ready for 8.3

2007-05-15 Thread Aidan Van Dyk
: http://news.gmane.org/find-root.php?message_id=$MSGID It uses non-PostgreSQL infrastructure, but hey, I think gmane does list archives better than PostgreSQL right now ;-) Try it: http://news.gmane.org/[EMAIL PROTECTED] a. -- Aidan Van Dyk

Re: [HACKERS] Not ready for 8.3

2007-05-16 Thread Aidan Van Dyk
on particular archival infrastructure. Isn't that what the Message-Id field is for? http://news.gmane.org/[EMAIL PROTECTED] a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca

Re: [HACKERS] Not ready for 8.3

2007-05-16 Thread Aidan Van Dyk
guaranteed to be gapless anyways (sure, there are work solutions, but I'm not about to audit any MTA/list software for that...) ;-) -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http

Re: [HACKERS] EXPLAIN omits schema?

2007-06-13 Thread Aidan Van Dyk
* Alvaro Herrera [EMAIL PROTECTED] [070613 09:58]: BTW can I bug you to add the Message-Ids in the messages as displayed in our archives? Yes! Yes! Yes! Pretty please! -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED

Re: [HACKERS] EXPLAIN omits schema?

2007-06-13 Thread Aidan Van Dyk
/mhonarc/'+id; a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description: Digital

Re: [HACKERS] We should Axe /contrib/start-scripts

2009-08-25 Thread Aidan Van Dyk
it before getting the PID out of it, you know it's not an active postmaster... It may be a pid that corresponds with something else, or it may be a pid of a racing postmaster, but since you have the exclusive lock, it's not going to get that lock... a. -- Aidan Van Dyk

Re: [HACKERS] RfD: more powerful any types

2009-09-10 Thread Aidan Van Dyk
forever then forget about all that tedious formatting in PosgreSQL... a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like

Re: [HACKERS] RfD: more powerful any types

2009-09-11 Thread Aidan Van Dyk
... l-) It's doable, but it's going got be a lot of explicit casting and coercion, and going to require a lot of documentation and error states... Remember, users using sprintf are really going to want it to act exactly as it would if they were using C, minus the crash part. a. -- Aidan Van Dyk

Re: [HACKERS] Rejecting weak passwords

2009-10-01 Thread Aidan Van Dyk
don't think there is documentation required; correct me if I am wrong. Can we have the check password hook function called in both the plaintext/encrypted case, with a flag as to whether it's encrypted or not? a. -- Aidan Van Dyk Create like a god, ai

Re: [HACKERS] Could postgres be much cleaner if a future release skipped backward compatibility?

2009-10-19 Thread Aidan Van Dyk
a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca command like a king, http://www.highrise.ca/ work like a slave. signature.asc Description: Digital signature

Re: [HACKERS] write ahead logging in standby (streaming replication)

2009-11-12 Thread Aidan Van Dyk
* Fujii Masao masao.fu...@gmail.com [091112 20:52]: Personally, I think that semi-synchronous replication is sufficient for HA. Often, but that's not synchronous replication so don't call it such... -- Aidan Van Dyk

Re: [HACKERS] next CommitFest

2009-11-13 Thread Aidan Van Dyk
... They scratch that, and massage some other places (like docs and tests) to make their itch more palatable/pleasant for the rest of the community, because the community expects docs, tests, and reviews. a. -- Aidan Van Dyk Create like a god, ai...@highrise.ca

Re: Status of GIT mirror (Was [HACKERS] having problem in rsync'ing cvs)

2008-03-28 Thread Aidan Van Dyk
. Looking at the CVS logs, there was definitely commit action in that timeframe, but none of it is showing up on the git shortlog. OK, so it should all be valid again. Sorry for any issues I caused to those trying to use that mirror regularly... a. -- Aidan Van Dyk

Re: Status of GIT mirror (Was [HACKERS] having problem in rsync'ing cvs)

2008-03-31 Thread Aidan Van Dyk
* Brendan Jurd [EMAIL PROTECTED] [080328 11:16]: On 29/03/2008, Aidan Van Dyk [EMAIL PROTECTED] wrote: * Brendan Jurd [EMAIL PROTECTED] [080327 16:36]: Looking at the CVS logs, there was definitely commit action in that timeframe, but none of it is showing up on the git shortlog

Re: [HACKERS] build multiple indexes in single table pass?

2008-04-01 Thread Aidan Van Dyk
at any of the code, but would the synchronized scans heap machinery help the multiple index creations walk the heap together, basically giving you this for free (as long as you start concurrent index creation)? a. -- Aidan Van Dyk Create like a god, [EMAIL

Re: [HACKERS] Several tags around PostgreSQL 7.1 broken

2008-04-01 Thread Aidan Van Dyk
= cvs_file_add_revision(file, rev_str); put_hash_object_ex(file-symbols, tag_str, rev, HT_NO_KEYCOPY, NULL, NULL); a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http

Re: [HACKERS] Several tags around PostgreSQL 7.1 broken

2008-04-01 Thread Aidan Van Dyk
us all a big warning, and hopefully pause the anoncvs/rsync sync stuff for the duration of the history change, so we (those of us out here working off anoncvs/rsync) get an atomic swap of ancient history? a. -- Aidan Van Dyk Create like a god, [EMAIL

Re: [HACKERS] modules

2008-04-03 Thread Aidan Van Dyk
is better vetted and organized than pgfoundry? Or is it because the projects that go into CPAN are better quality and projects in pgroundry? Or is it something else? I'm pretty sure the answers to the above questions aren't all yes... a. -- Aidan Van Dyk

Re: [HACKERS] Patch queue - wiki (was varadic patch)

2008-04-03 Thread Aidan Van Dyk
ahead --- this would be one less job for me to do. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave

Re: [HACKERS] modules

2008-04-03 Thread Aidan Van Dyk
... We're using CVS, so we live with disjoint history on renames... As long as the commit comment is clear, the history isn't lost, just another command away. a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED

Re: [HACKERS] modules

2008-04-04 Thread Aidan Van Dyk
*packages* (rpms, debs, pkg, etc) installed by default, and the DB owners can do the PostgreSQL install part themselves. Would this slight change of the game be of any value? a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED

Re: [HACKERS] modules

2008-04-04 Thread Aidan Van Dyk
* Andrew Dunstan [EMAIL PROTECTED] [080404 10:17]: Aidan Van Dyk wrote: This was simply about changing the user permissions needed to run CREATE FUNCTION ... LANGUAGE C so that distros/packages could have whatever module they want packaged (in system RPM/DEB/PKG context) and available

Re: [HACKERS] modules

2008-04-04 Thread Aidan Van Dyk
* Andrew Dunstan [EMAIL PROTECTED] [080404 09:35]: Aidan Van Dyk wrote: This changes the game slightly from trying to get systems to come with PostreSQL modules installed into PostgreSQL by default, to where systems come with PostgreSQL module *packages* (rpms, debs, pkg, etc) installed

Re: [HACKERS] modules

2008-04-04 Thread Aidan Van Dyk
Assuming others think something like this might be interesting, would something to do this be an OK candidate for my first patch, if only to start this ball rolling? a. * Gregory Stark [EMAIL PROTECTED] [080404 14:57]: Aidan Van Dyk [EMAIL PROTECTED] writes: What if you didn't need super

Re: [HACKERS] modules

2008-04-04 Thread Aidan Van Dyk
discussions and know better next time ;-) -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca/ work like a slave. signature.asc

Re: [HACKERS] modules

2008-04-04 Thread Aidan Van Dyk
and incomplete idea either put anybody out, or got anybody's hopes up for not... a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca

Re: [HACKERS] Commit fest queue

2008-04-09 Thread Aidan Van Dyk
mailbox anyways too, but it does seem like the 2 lists are a needless split as they currently are used. a. -- Aidan Van Dyk Create like a god, [EMAIL PROTECTED] command like a king, http://www.highrise.ca

  1   2   3   4   >